Announcement

Collapse
No announcement yet.

error message in admincp

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

  • error message in admincp

    I recently upgraded to 3.8 newest version, I tried to edit the password expiry of the admin usergroup but got this error message, can someone help me as to what to fix? Thanks


    Code:
    Database error in vBulletin 3.8.7:
    
    Invalid SQL:
    UPDATE usergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    	`title` = 'Administrators',
    	`description` = '',
    	`usertitle` = 'Administrator',
    	`opentag` = '',
    	`closetag` = '',
    	`passwordexpires` = '0',
    	`passwordhistory` = '0',
    	`postsforurls` = '',
    	`forumpermissions` = '16777215',
    	`genericpermissions` = '2147483583',
    	`attachlimit` = '0',
    	`pmquota` = '10000',
    	`pmpermissions` = '7',
    	`pmsendmax` = '10',
    	`pmthrottlequantity` = '0',
    	`calendarpermissions` = '63',
    	`wolpermissions` = '31',
    	`adminpermissions` = '3',
    	`genericpermissions2` = '1',
    	`genericoptions` = '62',
    	`profilepicmaxwidth` = '200',
    	`profilepicmaxheight` = '200',
    	`profilepicmaxsize` = '131070',
    	`avatarmaxwidth` = '100',
    	`avatarmaxheight` = '100',
    	`avatarmaxsize` = '40000',
    	`signaturepermissions` = '172031',
    	`sigpicmaxwidth` = '640',
    	`sigpicmaxheight` = '120',
    	`sigpicmaxsize` = '30000',
    	`sigmaxrawchars` = '2000',
    	`sigmaxchars` = '1000',
    	`sigmaxlines` = '8',
    	`sigmaxsizebbcode` = '7',
    	`sigmaximages` = '2',
    	`albumpermissions` = '255',
    	`albumpicmaxwidth` = '600',
    	`albumpicmaxheight` = '600',
    	`albumpicmaxsize` = '100000',
    	`albummaxpics` = '100',
    	`albummaxsize` = '0',
    	`usercsspermissions` = '63',
    	`visitormessagepermissions` = '63',
    	`socialgrouppermissions` = '65535',
    	`maximumsocialgroups` = '5',
    	`groupiconmaxsize` = '131070'
    WHERE usergroupid=6;
    
    MySQL Error   : Unknown column 'postsforurls' in 'field list'
    Error Number  : 1054
    Request Date  : Wednesday, April 6th 2011 @ 01:14:18 PM
    Error Date    : Wednesday, April 6th 2011 @ 01:14:18 PM
    Script        : http://xxxxxxxxxxx.org/vb/admincp/usergroup.php?do=update
    Referrer      : http://xxxxxxxxxx.org/vb/admincp/usergroup.php?do=edit&usergroupid=6
    IP Address    : 24.185.203.17
    Username      : Mikexxx
    Classname     : vB_Database
    MySQL Version : 5.0.91-community-log
    lincolnsofdistinction.org

  • #2
    There is no "postforurls" field in the default database, this is from a third party addon that you did not remove their permissions files and possibly other files.

    Check includes/xml for xml files from third party addons you're no longer using.

    Comment


    • #3
      aaahhh ok, before I upgraded I did remove a few spam hacks, thanks, I will look there and report back
      lincolnsofdistinction.org

      Comment


      • #4
        yes that was it, good looking, thanks
        lincolnsofdistinction.org

        Comment

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