Member
Member
Mnemonic   2008-03-11, 05:31
#1
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?
Developer
Developer
trisweb   2008-03-11, 06:09
#2
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.
Member
Member
sbillard   2008-03-11, 16:20
#3
Actually, it is fixed in the nightly build.
  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.