[Phpmyadmin-devel] Tr:bug report 2.3.0 rc2 (continue)

Sorry guys, I'm really too busy to work on PMA these days... Loïc -----Message d'origine----- De: SailorMax <max@elkor.lv> A: Lo?c <loic-div@ifrance.com> Date: 28/06/02 Objet: bug report 2.3.0 rc2 (continue) Yahoo Loic! Previous my message: ~~~~~~~~~~~~~~~~~~~~ Sorry, don't have any time for find bug-place :) Example: I have table 'sys_user_data' with field 'ID' and some else. query 'DELETE FROM sys_user_data WHERE ID >= 23' convert to 'DELETE FROM sys_user_DATA WHERE ID >= 23' and myAdmin sad 'error' :) ~~~~~~~~~~~~~~~~~~~~ The decision: ~~~~~~~~~~~~~ file: sql.php line1: 588 is: $res_words_arr = array("DROP", "SELECT", "DELETE", "UPDATE", "INSERT", "LOAD", "EXPLAIN", "SHOW", "FROM", "INTO", "OUTFILE", "DATA", "REPLACE", "CHECK", "ANALYZE", "REPAIR", "OPTIMIZE", "TABLE", "ORDER", "HAVING", "LIMIT", "GROUP" , "DISTINCT"); must be: $res_words_arr = array("DROP", "SELECT", "DELETE", "UPDATE", "INSERT", "LOAD", "EXPLAIN", "SHOW", "FROM", "INTO", "OUTFILE", "DATA", "REPLACE", "CHECK", "ANALYZE", "REPAIR", "OPTIMIZE", "TABLE", "ORDER BY", "HAVING", "LIMIT", "GROUP" , "DISTINCT", "WHERE", "VALUES", "IGNORE"); (and so on. I can give you mysql.chm ;) ----------------- file: sql.php line1: 602 is: $sql_str = eregi_replace("$w ", "$w ", $sql_str); must be: $sql_str = eregi_replace("([^A-Za-z_]+)$w ", "\\1$w ", $sql_str); $sql_str = eregi_replace("^$w ", "$w ", $sql_str); ----------------- -- Go-seiko:-o inorimas! (SailorMax) mails: mailto:max@elkor.lv mailto:sailormax@navigators.lv mailto:sailormax@inbox.lv Web-Page: http://www.fao.lv/sm-info http://sm-info.h1.ru ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif
participants (1)
-
Lo�c