Opensource.Platon.SK: phpMyEdit: Report extension problem

Index » Projekty » phpMyEdit » Fórum » Report extension problem

phpMyEdit Configuration Report extension problem

Odoslať novú tému Odpovedať na tému

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.

denisbeta Založený: 25.08.2023 Príspevky: 3997

Zaslal: 2024-07-09 15:53
Návrat hore Odpovedať s citátom

Odoslať novú tému Odpovedať na tému



	Vedenie
	Aktivity
	Komercia
	Podpora
	História
	Kontakt



	Akcie
	Administrácia
	Rozličné
	Tipy a triky
	Vývojárske zdroje
	Tlačové správy



	ep
	fastcgi-gallery
	libcfg+
	Metafox
	mylist
	phpMyEdit
	phpWebFileManager
	PLaTos
	thinkpad-status
	Tučniak
	sendxmpp
	vimconfig



	Webhosting
	Doménový Backorder
	Nginx podpora
	MôjFax
	Heslo.sk
	Dostupnosť


Copyright © 2002-2006 Platon Group Stránka používa redakčný systém Metafox	Na začiatok · Odkazový formulár · Prihláška Upozorniť na chybu na PLATON.SK webstránke · Podmienky použitia · Ochrana osobných údajov