| Index
» Projects
» phpMyEdit
» Forum
» Resolved:All our phpMyEdit scripts are broken .. web server. |
 |
gardnc
Joined: 16 Feb 2005
Posts: 3
Posted: 2005-02-16 19:22
Back to top
Reply with quote
|
Our web server was re-imaged due to a bad disk drive and Red Hat 9 was replaced with Fedor Core 2. Since that re-image all our phpMyEdit scripts fail with a similar error:
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 models AS PMEtable0 WHERE (make = '') ORDER BY PMEtable0.Array LIMIT 0,15
Pages using MySql and PHP other than phpMyEdit are working. It looks to me like maybe a setting in the new php.ini, but I don't know where to start. I replaced my older version of phpMyEdit with 5.4 and the same error persists.
Anyone have any ideas? I'd really appreciate some help.
Larry
Last edited by gardnc on 2005-02-19 23:41, edited 2 times in total
|
gardnc
Joined: 16 Feb 2005
Posts: 3
Posted: 2005-02-16 21:23
Back to top
Reply with quote
|
The problem I have discovered is that the data in the $opts array is not passing to the class invocation. I know this must be a php issue but I don't have the background to know what in php needs to be altered to pass the $opts to the phpMyEdit Class instance.
Anyone able to assit?
Larry
|
gardnc
Joined: 16 Feb 2005
Posts: 3
Posted: 2005-02-19 23:38
Back to top
Reply with quote
|
For those that may be interested, the problem outlined above is solved. Turned out to be a bug in php 4.3.10 and a less than current Zend Optimizer that caused array data to be returned incorrectly with one syntax of foreach:
foreach($file as $record)
failed and returned $record as array.
Changing the systax to
foreach($ffile as $key => $record)
returned $record with a proper value.
Modified each occurence in phpMyEdit and resolved.
Larry
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
