| Index
» Projects
» phpMyEdit
» Bug list
» Bug #720 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000720 |
core / general |
major |
always |
2012-06-10 21:13 |
2012-06-10 21:13 |
|
|
|
Reporter |
catranch |
View Status |
public |
|
|
Assigned To |
|
|
Priority |
normal |
Resolution |
open |
Platform |
|
|
Status |
new |
Duplicate ID |
|
OS |
|
|
Projection |
none |
|
Version |
|
|
ETA |
none |
|
Product Version |
5.7.1 (stable) |
|
|
Product Build |
|
|
|
Votes |
1 |
|
|
|
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. |
|
|
Login
Registration
Slovak
