| phpMyEdit - Viewing Bug Advanced Details | [ Go Back ] | ||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 343 | core / general | major | always | 2005-09-03 15:44 | 2007-04-13 12:42 |
|
|
|||||
| Reporter: | paco | Platform: | x86 | ||
| Assigned To: | michal | OS: | FreeBSD | ||
| Priority: | normal | Version: | 5.4-STABLE | ||
| Status: | resolved | Product Version: | 5.4 (stable) | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | Duplicate ID: | 0000094 | ||
| ETA: | none | ||||
|
|
|||||
| Summary: | Need back-ticks on INSERT statements with MySQL 5.0 | ||||
| Description: |
I'm using PHP 4.3.6 and MySQL 5.0.9 on FreeBSD 5.4-STABLE. By default, insert statements generated by phpMyEdit do not work. They look like this: INSERT INTO rtype (desc) VALUES ('foo'); MySQL 5.0 seems to be enforcing backticks around column names. When i changed the query (manually) to be: INSERT INTO rtype (`desc`) VALUES ('foo'); it worked. |
||||
| Steps To Reproduce: | It seems to be a straightforward bug. Just use phpMyEdit with a 5.0 db. | ||||
| Additional Information / Solution: | Attached is a 3-line patch that worked for me. | ||||
| Attached Files: | 0000343-patch.txt.txt (1 KB) 1970-01-01 01:33 | ||||
| Bug Notes | ||||
|
|
||||
|
|
|||