| phpMyEdit - Viewing Bug Advanced Details | [ Go Back ] | ||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 670 | core / general | major | always | 2010-03-14 20:20 | 2010-03-14 20:20 |
|
|
|||||
| Reporter: | PatRaf | Platform: | all | ||
| Assigned To: | OS: | all | |||
| Priority: | normal | Version: | all | ||
| Status: | new | Product Version: | 5.7.1 (stable) | ||
| Product Build: | Resolution: | open | |||
| Projection: | none | Duplicate ID: | |||
| ETA: | none | ||||
|
|
|||||
| Summary: | Delimiters needed for table and filed names in DELETE clause | ||||
| Description: | SQL allows table names and field names with white space characters. Table and field names should always be delimited by back-quote characters. | ||||
| Steps To Reproduce: |
Create a table or a field name with a space inside. Try to create and then delete a record. SQL errors are displayed. |
||||
| Additional Information / Solution: |
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.' = ' |
||||
| Attached Files: | |||||
| There are no notes attached to this bug. |