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

[Lo�c]

Sorry guys, I'm really too busy to work on PMA these days...

Loïc

-----Message d'origine-----
De: SailorMax <max at elkor.lv>
A: Lo?c <loic-div at 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 at elkor.lv
 mailto:sailormax at navigators.lv 
 mailto:sailormax at 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