ZenphotoCMS Forum
Error showing upon logging of restricted user - 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: Error showing upon logging of restricted user (/thread-9061.html)



Error showing upon logging of restricted user - barton - 2011-09-12

Hello,
I'm rather new to this and getting to know ZENphoto and so far I had been able to work out any issues or troubles. But now I'm stuck with the following problem. When I create any new user and give him access only to specific albumus via the manage album tab and the user logs in, he/she would encounter the following error

Zenphoto encountered an error
MySQL Query ( SELECT images.albumid, images.filename AS filename, images.mtime as mtime, images.title AS title, albums.folder AS folder, images.show, albums.show, albums.password FROM zp_images AS images, zp_albums AS albums WHERE (images.albumid = albums.id) AND (albums.id=) ORDER BY images.mtime DESC ) 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 ') ORDER BY images.mtime DESC' at line 1

Only way how I could get rid of this is to give me rights by checking the box in Album rights which is Manage all albums, but this way I have no option to restrict albums, which is something I need

I droped the MSQL DB on my server, recreate it, but it wont help, so any hint would be nice.

Thanks a lot for any advice in advance
VB.




Error showing upon logging of restricted user - acrylian - 2011-09-12

You are running 1.4.1.2. Please upgrade and retry.