Announcement

Collapse
No announcement yet.

Strange SQL Usergroup error

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

  • Strange SQL Usergroup error

    Hey there. Recently went to update a usergroup. I changed the avatar limits. Like the size to upload etc etc... went to save them changes and got this database error..

    Code:
    Database error in vBulletin 3.6.0:
    
    Invalid SQL:
    UPDATE usergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Registered Users',
        `description` = '',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `forumpermissions` = '782847',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `calendarpermissions` = '51',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions` = '338171591',
        `genericoptions` = '62',
        `profilepicmaxwidth` = '150',
        `profilepicmaxheight` = '200',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '150',
        `avatarmaxheight` = '170',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '172031',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '20000',
        `sigmaxrawchars` = '1000',
        `sigmaxchars` = '500',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '0',
        `profileviewpermissions` = '0'
    WHERE usergroupid=2;
    
    MySQL Error  : Unknown column 'profileviewpermissions' in 'field list'
    Error Number : 1054
    Date         : Monday, August 14th 2006 @ 11:55:00 AM
    Script       : http://chimairaboard.com/admincp/usergroup.php?do=update
    Referrer     : http://chimairaboard.com/admincp/usergroup.php?do=edit&usergroupid=2
    IP Address   : 84.9.71.9
    Username     : Severity
    Classname    : vb_database
    i have recently updated from vBulletin 3.5.2 to vBulletin 3.6.0
    Maybe this is what caused this.
    hope to get some help on this matter.
    thanks

  • #2
    Originally posted by chimaira View Post
    MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
    Any way i can remove this.. as maybe thats the problem... As it used to be a hack

    EDIT
    After browsing database in Phpmyadmin i have located this in datastore
    Code:
    SELECT *  FROM `chimaira_vbulletin`.`datastore` WHERE `title` LIKE CONVERT(_utf8 '%profileviewpermissions%' USING latin1) COLLATE latin1_swedish_ci OR `data` LIKE CONVERT(_utf8 '%profileviewpermissions%' USING latin1) COLLATE latin1_swedish_ci OR `unserialize` LIKE '%profileviewpermissions%'
    Worth deleting?
    Last edited by chimaira; Mon 14 Aug '06, 11:03am.

    Comment


    • #3
      Anyone?

      Comment

      Loading...
      Working...
      X