Thread

I created a new “Admin” group in preparation for handing off to my client.  I created a new “Admin” group “based off an existing group” (which was the Super Admin group).  I didn’t change any settings yet.  I customized some of the Publish screens for the Admin group, removing the options and tabs that they didn’t need.  Otherwise, they had “Super” admin powers.

I added my new “Admin” users, and upon testing their login, I received the following error message:

A Database Error Occurred

Error Number: 1064

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 edit_date DESC LIMIT 12' at line 4

SELECT t.entry_id, t.channel_id, t.title, t.entry_date, c.channel_title FROM exp_channel_titles as t, exp_channels as c WHERE t.channel_id = c.channel_id AND t.channel_id IN () ORDER BY edit_date DESC LIMIT 12

Filename: C:\MYSERVERPATH\webroot\SYSTEM\codeigniter\system\database\DB_driver.php

Line Number: 330

I changed the user to “Super Admin”, and was able to log in without a problem.  As soon as I switch them back, I get the error message.

I thought it might be related to the Zoo Flexible Admin module, so I uninstalled it.  Still get the same error message.

I’m running EE 2.2.1. Thanks for your thoughts!

Todd

SOLVED

I deleted the group, then recreated it (again, based off existing group of Super Admin).  I then moved my user back to the new admin group, and was able to log in without any problems.

Not sure what happened, but it seems to be working now!

Todd

Glad you were able to figure out what the problem was. Don’t hesitate to post again as needed.