Fatal zp_eror: anything to do with MySQL query's (Suhosin???)

warp4ever

Independent of used theme I get an error like (my site is online since 2010 and the error is spontaniously there)

What changed is that my ISP is using a server "running with Suhosin" (??)

I had also some difficulties while removing an album.
The album disapeared in Zenphoto but was persistent in the database, and I had to remove it manually.

{Tue, 19 Nov 2013 15:02:31 GMT}
Backtrace: fatal zp_error:MySQL Query ( SELECT * FROM WHERE `id`='0') failed. MySQL error: 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 'WHERE `id`='0'' at line 1.
zp_error called
from query (functions-db-MySQL.php [76])
from query_single_row (functions-db-MySQL.php [92])
from Gallery->garbageCollect (class-gallery.php [373])
from gallery_statistics.php [36]

acrylian

I hope that is not a Zenphoto version from 2010 as well. Otherwise you really should upgrade.

Suoshin should actually not affect this. But I am no expert on that.

warp4ever

Update:
When doing an metadata-refresh this error occurs:
MySQL Query ( SELECT * FROM [prefix] WHERE `id`='0' ) failed. MySQL error: Table 'databasename.zp_' doesn't exist.

I know, I know! Looking for "databasename_zp" while the database is just called "databasename" gets us nowhere :-)

Zenphoto versie 1.4.2.3 [9710] (Official Build)
Huidig locale instelling: nl_NL.UTF8
Huidig thema: Stopdesign Theme
PHP versie: 5.3.10-1ubuntu3.8
Grafische ondersteuning: PHP Imagick library 3.1.0RC1
ImageMagick 6.6.9-7 2012-08-17 Q16 http://www.imagemagick.org
PHP geheugenlimiet: 128M (De server kan minder toewijzen!)
MySql versie: 5.5.34

acrylian

Sorry, current release is 1.4.5.7. Please update, we cannot support 1.4.2.3 anymore.

warp4ever

Thanx, I'll do that right away and see where that leads...