| Index
» Projects
» phpMyEdit
» Bug list
» Bug #308 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000308 |
core / general |
major |
always |
2005-02-17 23:32 |
2005-05-04 13:36 |
|
|
|
Reporter |
gardnc |
View Status |
public |
|
|
Assigned To |
|
|
Priority |
normal |
Resolution |
open |
Platform |
Intel |
|
Status |
feedback |
Duplicate ID |
|
OS |
Linux |
|
Projection |
none |
|
Version |
Fedora Core 2 |
|
ETA |
none |
|
Product Version |
5.4 (stable) |
|
|
Product Build |
? |
|
|
Votes |
1 |
|
|
|
Summary |
Fails with table error |
|
Description |
php 4.3.10-2.4
Mature scripts fail on this server. Error:
Unknown column 'PMEtable0.Array' in 'field list'
SELECT PMEtable0.Array AS qf0,PMEtable0.Array AS qf1,PMEtable0.Array AS qf2,PMEtable0.Array AS qf3,PMEtable0.Array AS qf4,PMEtable0.Array AS qf5,PMEtable0.Array AS qf6,PMEtable0.Array AS qf7,PMEtable0.Array AS qf8,PMEtable0.Array AS qf9,PMEtable0.Array AS qf10,PMEtable0.Array FROM dealer AS PMEtable0 ORDER BY PMEtable0.Array LIMIT 1245,157.344 miliseconds
|
|
Steps To Reproduce |
https://gosafco.com/Sysadmin/testdealer.php |
|
Additional Information / Solution |
Error shows PMEtable0.Array instead of PMEtable0.COLUMN-NAME |
|
Attached Files |
testdealer.php (6,512 bytes) 2005-02-17 23:32 |
|
|
|
Bug Notes |
nepto
2005-03-05 13:20
|
This is not related to the phpMyEdit homepage.
There is no need to have this as a private entry. |
|
|
gardnc
2005-03-05 13:56
|
This was an issue with PHP 4.3.10 and a less than current copy of Zend Optimizer. foreach loops failed unless syntax as:
foreach ($file as $key -> $record)
I cnanged every occurance in phpMyEdit to use this syntax and it resolved this problem. |
|
|
nepto
2005-03-06 21:09
|
Just a question I understand the problem well.
Current phpMyEdit foreach() loops look like this:
foreach ($array as $key => $val)
Do you suggest to change it to:
foreach ($array as $key -> $val)
Note the => substitution for -> (regexp: s/=>/->/g)
Am I right? |
|
|
bd
2005-05-04 13:36
|
Im a running a mature script which works fine on PHP 4.3.4.
I have a production server running with PHP 4.3.10 and I have the same problem.
And the substitution foreach ($array as $key -> $val) instead of foreach ($array as $key => $val) doses not change anything.
In both case, I have this error message :
MySQL error 1054
Unknown column 'PMEtable0.Array' in 'field list'
------------------------------------------------------------------------
phpMyEdit error: invalid SQL query
-------------------------------------------------------------------------------
SELECT PMEtable0.Array AS qf0,PMEtable0.Array AS qf1,PMEtable0.Array AS qf2,PMEtable0.Array AS qf3,PMEtable0.Array AS qf4,PMEtable0.Array AS qf5,PMEtable0.Array FROM mytable AS PMEtable0 ORDER BY PMEtable0.Array LIMIT 0,15
Any advice or solution ???
Thank you. |
|
|
|
Bug History |
|
Date Modified |
Username |
Field |
Change |
|
2005-02-17 23:32 |
gardnc |
New Bug |
|
|
2005-02-17 23:32 |
gardnc |
File Added: testdealer.php |
|
|
2005-03-05 13:20 |
nepto |
category |
website / homepage => core / general |
|
2005-03-05 13:20 |
nepto |
status |
new => feedback |
|
2005-03-05 13:20 |
nepto |
view_state |
private => public |
|
2005-03-05 13:20 |
nepto |
Bugnote Added: 0001522 |
|
|
2005-03-05 13:56 |
gardnc |
Bugnote Added: 0001524 |
|
|
2005-03-06 21:09 |
nepto |
Bugnote Added: 0001534 |
|
|
2005-05-04 13:36 |
bd |
Bugnote Added: 0001635 |
|
|
|
Login
Registration
Slovak
