[Forum] Admin > vBulletin CMS > Permissions (Invalid SQL)

[kontagio.us]

When I try to access Admin > vBulletin CMS > Permissions I get this error message:

Database error in vBulletin 4.0.0 Release Candidate 4:

Invalid SQL:
SELECT u.usergroupid, u.title, p.permissions,
        p.permissionid  FROM usergroup AS u
        LEFT JOIN cms_permissions AS p on p.usergroupid = u.usergroupid and
            p.nodeid = 
        ORDER BY title;

MySQL 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 title' at line 5
Error Number  : 1064

MySQL Version : 5.0.86-log

Any ideas on what could be wrong? I'm using 4.0.3.

[kontagio.us]

I tried re-uploading /admincp/cms_permissions.php and I still get the error.

I think it has something to do with:

        LEFT JOIN cms_permissions AS p on p.usergroupid = u.usergroupid and
            p.nodeid =

[kontagio.us]

I think if I find out how to define p.nodeid then it will be ok?

[Trevor Hannant]

Can you post the full error please

[kontagio.us]

Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT u.usergroupid, u.title, p.permissions,
p.permissionid FROM usergroup AS u
LEFT JOIN cms_permissions AS p on p.usergroupid = u.usergroupid and
p.nodeid =
ORDER BY title;

MySQL 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 title' at line 5
Error Number : 1064
Request Date : Wednesday, December 30th 2009 @ 08:05:14 AM
Error Date : Wednesday, December 30th 2009 @ 08:05:14 AM
Script :
Referrer :
IP Address : (hidden)
Username : (hidden)
Classname :
MySQL Version : 5.0.86-log

[bagpiper]

I see that you got your upgrade to 4.0 to finally work, any tips on how you accomplished this?

Thanks,

Kevin

[kontagio.us]

I'm still looking for an answer to this question. My permissions are set up but I cannot add a new group that can see the CMS or edit any existing permission.

[bagpiper]

I am still having problems getting the forums to work, I found the above error on my boards and thought that this may be the "one" error holding up the forums from working

[kontagio.us]

Bump.

[Trevor Hannant]

Are you still running RC4 or have you upgraded to a stable release?

[kontagio.us]

My vBulletin is fully up-to-date. (4.0.1)

[Trevor Hannant]

Is it exactly the same error you get when accessing the CMS permissions page?

[rob aiken]

i have a similar problem check if

usergroupid,title, permissions, permissionid, usergroup, cms_permissions, usergroupid

are in your database you may have prefix on you database

[kontagio.us]

i have a similar problem check if

usergroupid,title, permissions, permissionid, usergroup, cms_permissions, usergroupid

are in your database you may have prefix on you database

In the cms_permissions table I only have "permissionid, usergroupid, nodeid and permissions" as fields.

Is it exactly the same error you get when accessing the CMS permissions page?

It's been the same error the whole time. When I try to go to Admin > vBulletin CMS > Permissions

[rob aiken]

SELECT
u.usergroupid, u.title, p.permissions, p.permissionid //these are columns names
FROM
usergroup //this is the table it is selecting from
ORDER BY title; // column name

check the table usergroup for those columns.
another thing why is there a semicolon there? i think the semicolon may be you problem tbh