| Index
» Projekty
» phpMyEdit
» Fórum
» Resolved:All our phpMyEdit scripts are broken .. web server. |
 |
gardnc
Založený: 16.02.2005
Príspevky: 3
Zaslal: 2005-02-16 19:22
Návrat hore
Odpovedať s citátom
|
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
Naposledy upravil gardnc dňa 2005-02-19 23:41, celkom upravené 2 krát
|
gardnc
Založený: 16.02.2005
Príspevky: 3
Zaslal: 2005-02-16 21:23
Návrat hore
Odpovedať s citátom
|
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
Založený: 16.02.2005
Príspevky: 3
Zaslal: 2005-02-19 23:38
Návrat hore
Odpovedať s citátom
|
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
|
|
Odoslať novú tému
Odpovedať na tému
|
|
|
|
Prihlásiť
Registrácia
English
