| Index
» Projects
» phpMyEdit
» Bug list
» Bug #343 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000343 |
core / general |
major |
always |
2005-09-03 15:44 |
2007-04-13 12:42 |
|
|
|
Reporter |
paco |
View Status |
public |
|
|
Assigned To |
michal |
|
Priority |
normal |
Resolution |
fixed |
Platform |
x86 |
|
Status |
resolved |
Duplicate ID |
0000094 |
OS |
FreeBSD |
|
Projection |
none |
|
Version |
5.4-STABLE |
|
ETA |
none |
|
Product Version |
5.4 (stable) |
|
|
Product Build |
|
|
|
Votes |
1 |
|
|
|
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 |
patch.txt (868 bytes) 2005-09-03 15:44 |
|
|
|
Bug Notes |
michal
2007-04-13 12:42
|
fixed in cvs, please check if works ok. |
|
|
|
Bug History |
|
Date Modified |
Username |
Field |
Change |
|
2005-09-03 15:44 |
paco |
New Bug |
|
|
2005-09-03 15:44 |
paco |
File Added: patch.txt |
|
|
2007-04-13 12:42 |
michal |
duplicate_id |
0 => 94 |
|
2007-04-13 12:42 |
michal |
resolution |
open => fixed |
|
2007-04-13 12:42 |
michal |
status |
new => resolved |
|
2007-04-13 12:42 |
michal |
Bugnote Added: 0001865 |
|
|
2007-04-13 12:42 |
michal |
handler_id |
=> michal |
|
|
Login
Registration
Slovak
