Announcement

Collapse
No announcement yet.

(fixed) edit usergroup = mysql error

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • (fixed) edit usergroup = mysql error

    Code:
    Database error in vBulletin 3.6.7:
    
    Invalid SQL:
    UPDATE vbusergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Comfirmed Members',
        `description` = '1+ posts',
        `usertitle` = 'MAF Member',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `ispublicgroup` = '0',
        `canoverride` = '1',
        `forumpermissions` = '782463',
        `genericpermissions` = '44570307',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '1',
        `pmsendmax` = '5',
        `calendarpermissions` = '55',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericoptions` = '62',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '102400',
        `avatarmaxwidth` = '100',
        `avatarmaxheight` = '100',
        `avatarmaxsize` = '102400',
        `signaturepermissions` = '0',
        `sigpicmaxwidth` = '0',
        `sigpicmaxheight` = '0',
        `sigpicmaxsize` = '0',
        `sigmaxrawchars` = '0',
        `sigmaxchars` = '0',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '0',
        `sigmaximages` = '0',
        `profileviewpermissions` = '0'
    WHERE usergroupid=25;
    
    MySQL Error  : Unknown column 'profileviewpermissions' in 'field list'
    Error Number : 1054
    Date         : Thursday, June 7th 2007 @ 12:29:55 PM
    Script       : http://antimisandry.com/xxx/usergroup.php?do=update
    Referrer     : http://antimisandry.com/xxx/usergroup.php?do=edit&usergroupid=25
    IP Address   : my.i.p.addy
    Username     : admin
    Classname    : vB_Database_MySQLi
    This occurs on any attempt to edit a usergroup.
    VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
    No Addons - none at all.

  • #2
    resolved... looking at the above, I realised it was from a plugin I'd been using - yet I hadn't installed it on this installation. I guess it was pulled over during the impex transfer. weird.
    Anyway, all sorted
    VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
    No Addons - none at all.

    Comment

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