| Index
» Projects
» phpMyEdit
» Bug list
» Bug #456 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000456 |
core / general |
crash |
always |
2007-09-07 02:33 |
2007-09-07 02:33 |
|
|
|
Reporter |
bf |
View Status |
public |
|
|
Assigned To |
|
|
Priority |
normal |
Resolution |
open |
Platform |
xampp 1.6.3a: php 4.4.7, mysql 5 |
|
Status |
new |
Duplicate ID |
|
OS |
win xp |
|
Projection |
none |
|
Version |
sp2 |
|
ETA |
none |
|
Product Version |
5.7 (stable) |
|
|
Product Build |
2007-09-03 00:55 |
|
|
Votes |
1 |
|
|
|
Summary |
Double LIMIT: PME generates invalid SQL queries |
|
Description |
phpMyEdit 5.7 is generating SQL queries that have two LIMIT keywords back-to-back. Obviously, the MySQL server doesn't like that. :o
(BTW, I don't know if you call that a crash or a block, but it doesn't work at all, and is 100% unusable.)
|
|
Steps To Reproduce |
Use pmpMyEdit to generate a php file normally, then try to run the generated php. |
|
Additional Information / Solution |
In phpMyEdit.class.php, I found that line 359 and 571 both seem to be adding the LIMIT keyword (to something?) so I took out the word LIMIT from line 359, and suddenly the generated files seem to work OK. I have not yet tried every function from every direction, but it looks normal (like 5.6) instead of a screen full of errors. :) I may not have tweaked the right thing... keeping my fingers crossed...
|
|
Attached Files |
|
|
|
|
There are no notes attached to this bug. |
|
Bug History |
|
Date Modified |
Username |
Field |
Change |
|
2007-09-07 02:33 |
bf |
New Bug |
|
|
|
Login
Registration
Slovak
