Admin > vBulletin CMS > Permissions (Invalid SQL)

[kontagio.us]

The table usergroup has these columns:

usergroupid title description usertitle passwordexpires passwordhistory pmquota pmsendmax opentag closetag canoverride ispublicgroup forumpermissions pmpermissions calendarpermissions wolpermissions adminpermissions genericpermissions genericpermissions2 genericoptions signaturepermissions visitormessagepermissions attachlimit avatarmaxwidth avatarmaxheight avatarmaxsize profilepicmaxwidth profilepicmaxheight profilepicmaxsize sigpicmaxwidth sigpicmaxheight sigpicmaxsize sigmaximages sigmaxsizebbcode sigmaxchars sigmaxrawchars sigmaxlines usercsspermissions albumpermissions albumpicmaxwidth albumpicmaxheight albummaxpics albummaxsize socialgrouppermissions pmthrottlequantity groupiconmaxsize maximumsocialgroups importusergroupid vbblog_general_permissions vbblog_entry_permissions vbblog_comment_permissions vbblog_customblocks vbblog_custompages vbcmspermissions

[rob aiken]

i guess its the semicolon

[kontagio.us]

I downloaded the suite from the members section and re-uploaded /admincp/cms_permissions.php and it still gives me the error. I looked inside the file and there is no semicolon.

It is as follows:

if ($rst = $vbulletin->db->query_read(" 
        SELECT u.usergroupid, u.title, p.permissions, p.permissionid 
        FROM " . TABLE_PREFIX . "usergroup AS u 
        LEFT JOIN " . TABLE_PREFIX . "cms_permissions AS p on p.usergroupid = u.usergroupid AND 
            p.nodeid = " . $section['nodeid'] . " 
        ORDER BY title 
    "))

I thought it might help if I add a screen shot.

[kontagio.us]

bump

[kontagio.us]

I don't think it's the semicolon. It still seems to be broken.

I can't add new usergroups untill I get this working.

[kontagio.us]

Okay even after the latest patch (4.0.2 PL1) I am getting this error. I downloaded a fresh version of the file and over wrote it. I still get the same error.

[Zachery]

Do you have any content in your cms?

[kontagio.us]

Yes, I have over 300 articles.

[Sandtimes]

Same errors in 4.0.2 PL1 ... and Fatal Error in CMS Content Manager

I am getting a similar error in 4.0.2 PL1 in my AdminCP > vBulletin CMS > Permissions also:

Database error in vBulletin 4.0.2:

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  : Monday, March 1st 2010 @ 12:28:57 AM
Error Date    : Monday, March 1st 2010 @ 12:28:57 AM
Script        : http://(hidden IP)/board/admincp/cms_permissions.php
Referrer      : http//(hidden IP)/board/admincp/index.php?do=nav 
IP Address    : (hidden)
Username      : (hidden)
Classname     : vB_Database
MySQL Version : 5.0.67-log

I also get this fatal error in the AdminCP > vBulletin CMS > Content Manager:

"Fatal error:[/code][code] Checking if a package is enabled for an invalid package '3' on line 392 in [path]/vb/types.php in [path]/vb/vb.php on line 284 ..."

Any suggestions on how to fix it? I already tried downloading and installing a fresh version of 4.0.2 PL1.


Thanks

[kontagio.us]

I am getting a similar error in 4.0.2 PL1 in my AdminCP > vBulletin CMS > Permissions also:

Database error in vBulletin 4.0.2:

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  : Monday, March 1st 2010 @ 12:28:57 AM
Error Date    : Monday, March 1st 2010 @ 12:28:57 AM
Script        : http://(hidden IP)/board/admincp/cms_permissions.php
Referrer      : http//(hidden IP)/board/admincp/index.php?do=nav 
IP Address    : (hidden)
Username      : (hidden)
Classname     : vB_Database
MySQL Version : 5.0.67-log

I also get this fatal error in the AdminCP > vBulletin CMS > Content Manager:

"Fatal error:[/code][code] Checking if a package is enabled for an invalid package '3' on line 392 in [path]/vb/types.php in [path]/vb/vb.php on line 284 ..."

Any suggestions on how to fix it? I already tried downloading and installing a fresh version of 4.0.2 PL1.


Thanks

Your error is the exact same as mine.

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?

Did you install any plugins? Did you use Wordpress import? This is going to be easier to solve with 2 people!

[Sandtimes]

I haven't installed any plugins. I'm just trying to upgrade from 3.8.4 to the 4.0.2 suite. But I'm just about ready to give up and revert back to the old stable software.

[kontagio.us]

I'm still having this problem. I'm using 4.0.3 and it's been happening since 4.0.0 release candidate 4.. it worked in 3. Really annoying problem to still have.

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

Database error in vBulletin 4.0.3:

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  : Sunday, April 11th 2010 @ 08:52:29 PM
Error Date    : Sunday, April 11th 2010 @ 08:52:29 PM
Script        : 
Referrer      :
IP Address    : **********
Username      : **********
Classname     : **********
MySQL Version : 5.0.86-log

Any ideas on what could be wrong?

[Zachery]

Have you put in a support ticket?

[kontagio.us]

Alright I set one up: http://www.vbulletin.com/forum/proje...?issueid=37521

[Zachery]

Thats a bug report tickets go here: http://members.vbulletin.com/