Hi Support, I have created a user with limited admin rights but want to allow them to upload images and files for their articles. However on the image upload screen the following error message displays:
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 'AND uploader = '6380' ORDER BY uid DESC' at line 1 Statement: SELECT * FROM news30images WHERE uid NOT IN (SELECT storyid FROM news30groupcats WHERE type = 'image') AND uploader = '6380' UNION SELECT * FROM news30_images AND uploader = '6380' ORDER BY uid DESC Arguments:
Array ( )
Please can you assist?
Regards, Lloyd
Is this error happening with all the accounts in the image upload section or just the non-admin accounts you've created? It's only happening with the non-admin account you created, can you take a screenshot of the Access Level
that particular account is using so I can try replicate the problem?
Navigate to Options > Access Levels > edit the access level that account is using and take a screenshot of that page.
Hello Chris, I'm having same problem. It's not occurring when looking at images for a particular Cat but when viewing all Cats. Here is a screenshot, pretty big shot, sorry about the size :((