| Index
» Projekty
» phpMyEdit
» Fórum
» Report extension problem |
 |
bede
Založený: 02.07.2008
Príspevky: 1
Zaslal: 2008-07-02 14:13
Návrat hore
Odpovedať s citátom
|
Have installed and tested PME - OK with main interface forms. Slide extension OK. Not sure what Xstandard extension does (no clue within the file itself). Have not tried mce-cal yet, not sure we need it yet.
Very impressed so far - but need reports to work (assuming they will produce what I think they will - is it the same as the 'export to' option on the demo? or something different?)
Have installed latest versions of all scripts from CVS.
When running a script with report extension config at bottom (replacing default setting) I get:
MySQL error 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1
Warning: array_keys() [function.array-keys]: The first argument should be an array in /var/www/bdb/extensions/phpMyEdit-report.class.php on line 147
phpMyEdit error: database fetch error
Same script with default settings works OK.
Have also searched forums to no avail.
PHP expertise is limited.
Any constructive help gratefully received.
TIA
[PHP 5.1.2 MySQL 5.0.22 on Ubuntu 6.06LTS]
|
mcfatema
Založený: 17.09.2008
Príspevky: 4
Zaslal: 2008-09-20 20:12
Návrat hore
Odpovedať s citátom
|
I am seeing exactly the same errors as listed here but nothing in the forum link provided in the previous post was helpful.
Anybody else got an idea what these errors indicate?
|
dugoutdog
Založený: 01.10.2008
Príspevky: 2
Zaslal: 2008-10-01 01:03
Návrat hore
Odpovedať s citátom
|
Like you folks, I'm experiencing the same problem. Some of the forums I've been on seem to suggest a PHP incompatible version issue, but I haven't talked to the host techs yet. If this is s phpmyedit bug can any of the support folks respond? Thanks. [/quote]
|
mcfatema
Založený: 17.09.2008
Príspevky: 4
Zaslal: 2008-10-01 13:27
Návrat hore
Odpovedať s citátom
|
Actually, I found a solution to my problem last week and got it working. Ultimate problem was with the generated mySQL syntax. The php code for the corrected query looks like this:
$query_parts = array(
'type' => 'select',
'select' => '*',
'from' => $this->tb,
'limit' => ' WHERE 1'); // added WHERE to this clause to correct a bug
As you can see from my comment this statement was previously missing the "WHERE" keyword. The occurs in my copy of phpMyEdit-report.class.php at line 145.
|
dugoutdog
Založený: 01.10.2008
Príspevky: 2
Zaslal: 2008-10-01 14:32
Návrat hore
Odpovedať s citátom
|
Hey mcfatema,
Good job. I should have spotted that. Everything's fine now.
|
|
Odoslať novú tému
Odpovedať na tému
|
|
|
|
Prihlásiť
Registrácia
English
