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.
