|
phpMyEdit - Viewing Bug Advanced Details |
[ Go Back ]
|
|
|
ID:
|
Category:
|
Severity:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
454 |
core / general |
crash |
always |
2007-09-07 02:23 |
2007-09-07 02:23 |
|
|
Reporter:
|
bf |
Platform:
|
xampp 1.6.3a: php 4.4.7, mysql 5 |
|
|
Assigned To:
|
|
OS:
|
win xp |
|
|
Priority:
|
normal |
Version:
|
sp2 |
|
|
Status:
|
new |
Product Version:
|
5.7 (stable) |
|
|
Product Build:
|
|
Resolution:
|
open |
|
|
Projection:
|
none |
Duplicate ID:
|
|
|
|
ETA:
|
none |
|
|
|
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:
|
Generate a php file normally, then try to run it. |
|
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:
|
|