Announcement

Collapse
No announcement yet.

Admin > vBulletin CMS > Permissions (Invalid SQL)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    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
    Last edited by kontagio.us; Mon 12 Apr '10, 5:08pm.
    vBulletin Rules!

    Comment


    • #17
      i guess its the semicolon

      Comment


      • #18
        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:

        Code:
        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.
        Last edited by kontagio.us; Wed 21 Dec '11, 11:07pm. Reason: unlinked
        vBulletin Rules!

        Comment


        • #19
          bump
          vBulletin Rules!

          Comment


          • #20
            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.
            Last edited by kontagio.us; Mon 12 Apr '10, 5:08pm.
            vBulletin Rules!

            Comment


            • #21
              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.
              Last edited by kontagio.us; Mon 12 Apr '10, 5:08pm.
              vBulletin Rules!

              Comment


              • #22
                Do you have any content in your cms?

                Comment


                • #23
                  Yes, I have over 300 articles.
                  Last edited by kontagio.us; Mon 12 Apr '10, 5:08pm.
                  vBulletin Rules!

                  Comment


                  • #24
                    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:

                    Code:
                    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

                    Comment


                    • #25
                      Originally posted by Sandtimes View Post
                      I am getting a similar error in 4.0.2 PL1 in my AdminCP > vBulletin CMS > Permissions also:

                      Code:
                      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.

                      Originally posted by kontagio.us View Post
                      When I try to access Admin > vBulletin CMS > Permissions I get this error message:

                      Code:
                      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!
                      Last edited by kontagio.us; Mon 12 Apr '10, 5:09pm.
                      vBulletin Rules!

                      Comment


                      • #26
                        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.

                        Comment


                        • #27
                          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:

                          Code:
                          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?
                          Last edited by kontagio.us; Wed 21 Dec '11, 11:08pm. Reason: unlinked
                          vBulletin Rules!

                          Comment


                          • #28
                            Have you put in a support ticket?

                            Comment


                            • #29
                              Alright I set one up: http://www.vbulletin.com/forum/proje...?issueid=37521
                              Last edited by kontagio.us; Mon 12 Apr '10, 5:09pm.
                              vBulletin Rules!

                              Comment


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

                                Comment

                                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                                Working...
                                X