phpMyEdit - Viewing Bug Advanced Details [ Go Back ]
670 core / general major always 2010-03-14 20:20 2010-03-14 20:20
PatRaf all  
all  
normal all  
new 5.7.1 (stable)  
open  
none  
none  
Delimiters needed for table and filed names in DELETE clause
SQL allows table names and field names with white space characters. Table and field names should always be delimited by back-quote characters.
Create a table or a field name with a space inside.
Try to create and then delete a record. SQL errors are displayed.
Line 2789 in version v1.211 of phpMyEdit.class.php must be changed into :
$query = 'DELETE FROM '.$this->sd.$this->tb.$this->ed.' WHERE ('.$this->sd.$this->key.$this->ed.' = '

There are no notes attached to this bug.