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.
Overview
10 Most Recent Comments
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
And then in Comments
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?
Zenphoto
Comments