+- 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: User without "User Admin" rights creates errors (/thread-2396.html)
User without "User Admin" rights creates errors - Mnemonic - 2008-03-11
Hi,
After creating a new user everything was just fine. When I changed that user's privileges so they no longer have "User Admin" rights I got errors in certain sections.
[b]Overview
10 Most Recent Comments[/b]
Zenphoto Error
MySQL Query ( SELECT id, name, website, type, ownerid, (date + 0) AS date, comment, email, inmoderation FROM zp_comments WHERE (type='albums' AND ()) ORDER BY id DESC LIMIT 10 ) 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 ')) ORDER BY id DESC LIMIT 10' at line 1
[b]And then in Comments[/b]
Zenphoto Error
MySQL Query ( SELECT id, name, website, type, ownerid, (date + 0) AS date, comment, email, inmoderation FROM zp_comments WHERE (type='albums' AND ()) ORDER BY id DESC LIMIT 20 ) 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 ')) ORDER BY id DESC LIMIT 20' at line 1
Is there a fix I can apply?
User without "User Admin" rights creates errors - trisweb - 2008-03-11
Not yet a fix I don't think, but if you submit it as a bug here: http://www.zenphoto.org/newticket it will surely get fixed.
User without "User Admin" rights creates errors - sbillard - 2008-03-11
Actually, it is fixed in the nightly build.