Announcement

Collapse
No announcement yet.

Cannot create/edit Usergroups

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

  • Cannot create/edit Usergroups

    For some reason, I cannot edit user groups or create new ones. I always get a database error within the frame of the user group manager.

    Anyone know what could be wrong? (DB Error report on request)

    Thank you

  • #2
    Whats the database error?

    Comment


    • #3
      Database error in vBulletin 3.6.7:

      Invalid SQL:

      ### INSERT QUERY GENERATED BY fetch_query_sql() ###
      INSERT INTO usergroup
      (`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `nbmsgshowchatbox`, `mgccustomusergroupperms`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`)
      VALUES
      ('t3t', '3t3t', '', '', '', '', '', '0', '0', '', '0', '651271', '2626563', '1000000', '0', '0', '5', '0', '1', '0', '41', '100', '100', '25000', '50', '50', '20000', '0', '', '', '', '', '', '', '7', '');

      MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
      Error Number : 1054
      Date : Tuesday, July 10th 2007 @ 02:04:27 AM
      Script : http://*********.com/forums/admincp/....php?do=update
      Referrer : http://*********.com/forums/admincp/...oup.php?do=add
      IP Address : **.**.**.***
      Username : ************
      Classname : vB_Database

      Comment


      • #4
        Youve got an addon causing the error, there is no nbmsgshowchatbgox permission in vBulletin.

        Try removing all of the files from includes/xml and reuploading the default ones from the vfBulletin zip.

        Comment


        • #5
          Worked like a charm. Thanks Zach.

          Comment


          • #6
            Originally posted by Zachery View Post
            Youve got an addon causing the error, there is no nbmsgshowchatbgox permission in vBulletin.

            Try removing all of the files from includes/xml and reuploading the default ones from the vfBulletin zip.
            thanks for this
            Elite Culturismo Forum Elite Culturismo Bodybulding and Fitness

            Comment


            • #7
              I get this error tried the above fix did not help me


              Database error in vBulletin 3.5.4:
              Invalid SQL:
              UPDATE usergroup SET
              ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
              `title` = 'Unregistered / Not Logged In',
              `description` = '',
              `usertitle` = 'Visitor',
              `opentag` = '',
              `closetag` = '',
              `passwordexpires` = '0',
              `passwordhistory` = '0',
              `forumpermissions` = '655361',
              `pmquota` = '0',
              `pmpermissions` = '0',
              `pmsendmax` = '0',
              `calendarpermissions` = '32',
              `wolpermissions` = '0',
              `genericpermissions` = '0',
              `genericoptions` = '0',
              `profilepicmaxwidth` = '100',
              `profilepicmaxheight` = '100',
              `profilepicmaxsize` = '100000',
              `avatarmaxwidth` = '150',
              `avatarmaxheight` = '150',
              `avatarmaxsize` = '400000',
              `photoplogpermissions` = '0',
              `photoplogmaxfilesize` = '512000',
              `photoplogmaxfilelimit` = '100',
              `usmilie_permissions` = '0',
              `adminpermissions` = '0'
              WHERE usergroupid=1;
              MySQL Error : Unknown column 'usmilie_permissions' in 'field list'
              Error Number : 1054
              Date : Sunday, October 14th 2007 @ 05:08:19 PM
              Script : http://www.xxxx.xxxx/xxxxxxx/admincp/usergroup.php
              Referrer : http://www.xxxx.xxxxxx/xxxxxxxxx/adm...&usergroupid=1
              IP Address : xxxxxxxxx
              Username : SmokeRing
              Classname : vb_database

              Comment


              • #8
                fixed it it was an xml file still there from a hack i uninstalled

                Comment


                • #9
                  There is no 'usmilie_permissions' field in the default vB usergroup table. This is from an add-on you installed. To fix this reupload the original vB files and/or remove your add-ons.
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment

                  Loading...
                  Working...
                  X