Announcement

Collapse
No announcement yet.

sql error when adding new usergroup

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

  • sql error when adding new usergroup

    getting this error when i try to add a user group

    mysql error: Unknown column 'phydelpermissions' in 'field list'

  • #2
    What's the complete error message?
    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


    • #3
      Database error in vBulletin 3.0.3:

      Invalid SQL:
      ### INSERT QUERY GENERATED BY fetch_query_sql() ###
      INSERT INTO usergroup
      (title, description, usertitle, opentag, closetag, passwordexpires, passwordhistory, ispublicgroup, canoverride, attachlimit, avatarmaxwidth, avatarmaxheight, avatarmaxsize, profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize, pmquota, pmsendmax, forumpermissions, pmpermissions, calendarpermissions, wolpermissions, adminpermissions, genericpermissions, genericoptions, phydelpermissions)
      VALUES
      ('newgroupname', '', '', '', '', '', '', '0', '0', '1000000', '50', '50', '20000', '100', '100', '25000', '0', '5', '122887', '0', '0', '1', '0', '5123', '9', '0')
      mysql error: Unknown column 'phydelpermissions' in 'field list'

      mysql error number: 1054

      Date: Thursday 14th of October 2004 02:37:49 PM
      Script: http://www..com/forums/admincp/usergroup.php
      Referer: http://www.com/forums/admincp/usergroup.php?do=add

      Comment


      • #4
        The field 'phydelpermissions' is not in the default vB 3.0.3 database. This error is from a hack you've installed. Reupload the original vB 3.0.3 to stop this error.
        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


        • #5
          Could i get around it by just upload the user.php or usergroup.php files?

          Comment


          • #6
            Maybe, but I doubt it. It depends on what other files were changed by this hack.
            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

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