| phpMyEdit - Viewing Bug Advanced Details | [ Go Back ] | ||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 720 | core / general | major | always | 2012-06-10 21:13 | 2012-06-10 21:13 |
|
|
|||||
| Reporter: | catranch | Platform: | |||
| Assigned To: | OS: | ||||
| Priority: | normal | Version: | |||
| Status: | new | Product Version: | 5.7.1 (stable) | ||
| Product Build: | Resolution: | open | |||
| Projection: | none | Duplicate ID: | |||
| ETA: | none | ||||
|
|
|||||
| Summary: | SQL error on DELETE record | ||||
| Description: |
SQL DELETE query generated in class lines 2777 through 2778 contains syntax error (1065) if key field is named "index". |
||||
| Steps To Reproduce: | Attempt to delete a row from a table in which the key field is named "index". | ||||
| Additional Information / Solution: |
Enclose key field's name in back-quotes as follows: $query = 'DELETE FROM '.$this->tb.' WHERE (`'.$this->key.'` = '.$this->key_delim.$this->rec.$this->key_delim.')'; |
||||
| Attached Files: | |||||
| There are no notes attached to this bug. |