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); -----------------