in "image.php" line 78 79 80 supress "$showhide". This will supress buton show and hide. in "comments.js" replace all "hidecomments" with "showcomments".
Hi guys, i'm new to all this gallery thing and i definitely don't know any codings. I am using the stopdesign theme and completely stuck after encountering the same problem as Nico was back in Jan...i'm getting the same :
--->MySQL Query ( SELECT `zp_images`.filename,`zp_images`.title, `zp_albums`.folder, `zp_images`.show, `zp_albums`.show, `zp_albums`.password FROM `zp_images` INNER JOIN `zp_albums` ON `zp_images`.albumid = `zp_albums`.id WHERE `zp_albums`.folder!="" ORDER BY RAND() LIMIT 1 ) Failed. 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 'show, `zp_albums`.show, `zp_albums`.password FROM `zp_images`<---
Please help, and yes, this does only happen if "random images" is selected in the theme options.
No, 1.1.5 is the last official version. You see the actual version in the footer of the zenphoto admin. The nightly build is the developer version that is updated frequently to become the next version some time. The current version is zenphoto version 1.1.5 [1459] (the version number is written in the footer of the zenphoto admin)
You can download the nightly on our download page.
Thank you, the nightly build versions defintely help solve some issues. Is there a way to update these nightly version without having me to go into the codes and doing all my custom settings again?
I guess my question is, what are the files that i MUST update when installing the newer nightly build versions? For example, can i not change the .htaccess file? Can i not change the zp_config.php file? etc...
Generally speaking, you need to update all the files from the release. However, the .htaccess file does not change often, so may not need updating. You could keep an unmodified copy of files you have used and compare them to the build. Anything that has changed in this comparrison you would need to deal with.
zp-config.php is not included in the build, it is generated when you first run setup.php. So you do not change it when you install the nightly build.
Comments
How did you "suppress" function showhide? Could you provide more detailed information?
in "comments.js" replace all "hidecomments" with "showcomments".
That's all. This hack is OK on my gallerie: http://nicospeech.fr
This will not really supress the function showhide.
Thanks also to sbillard... I will follow in Trac.
--->MySQL Query ( SELECT `zp_images`.filename,`zp_images`.title, `zp_albums`.folder, `zp_images`.show, `zp_albums`.show, `zp_albums`.password FROM `zp_images` INNER JOIN `zp_albums` ON `zp_images`.albumid = `zp_albums`.id WHERE `zp_albums`.folder!="" ORDER BY RAND() LIMIT 1 ) Failed. 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 'show, `zp_albums`.show, `zp_albums`.password FROM `zp_images`<---
Please help, and yes, this does only happen if "random images" is selected in the theme options.
btw, i am currently running ZenPhoto version 1.1.5...is that nightly build?
You can download the nightly on our download page.
I guess my question is, what are the files that i MUST update when installing the newer nightly build versions? For example, can i not change the .htaccess file? Can i not change the zp_config.php file? etc...
zp-config.php is not included in the build, it is generated when you first run setup.php. So you do not change it when you install the nightly build.