ZenphotoCMS Forum
I got error when display image (NighBuild). - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: I got error when display image (NighBuild). (/thread-7846.html)



I got error when display image (NighBuild). - midas - 2010-11-11

Hi
I got error when display image.
Zenphoto version 1.3.1.2 [6160] (Official Build)
theme Zenpage

Zenphoto encountered an error
MySQL Query ( SELECT id, data FROM zp_plugin_storage WHERE aux=2 type = "multiple_layouts_albums_images" ) failed. MySQL returned the 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 'type = "multiple_layouts_albums_images"' at line 1
Backtrace:

-> query (functions-db-MySQL.php [103])
-> query_full_array (multiple_layouts.php [190])
-> checkLayoutUseForImages (multiple_layouts.php [373])
-> getLayout
-> call_user_func_array (functions-filter.php [147])
-> zp_apply_filter (index.php [170])




I got error when display image (NighBuild). - acrylian - 2010-11-11

Please file a ticket so it does not get forgotten. The chief developer is currently away for a few days.

Also add if you actually use this plugin. Thanks.




I got error when display image (NighBuild). - midas - 2010-11-11

I found bug
multiple_layouts.php
line 190
$parentimagelayouts = query_full_array('SELECT id, data FROM '.prefix('plugin_storage').' WHERE aux='.$parent->getID().' type = "multiple_layouts_albums_images"');

should be
$parentimagelayouts = query_full_array('SELECT id, data FROM '.prefix('plugin_storage').' WHERE aux='.$parent->getID().' AND type = "multiple_layouts_albums_images"');

No "AND" for sql

Chris




I got error when display image (NighBuild). - acrylian - 2010-11-12

Thanks, will take a look.

UPDATE: Seems this has already been fixed.