[cfuk]

Can anyone help with this error. I keep getting this when i try to change the admin pm settings

PHP Code:

Database error in vBulletin 3.6.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Administrators',
    `description` = '',
    `usertitle` = 'Administrator',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '180',
    `passwordhistory` = '360',
    `forumpermissions` = '1048575',
    `genericpermissions` = '1073741759',
    `attachlimit` = '0',
    `pmquota` = '200',
    `pmpermissions` = '7',
    `pmsendmax` = '0',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '3',
    `genericoptions` = '55',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '2000',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `canviewlinks` = '0',
    `canaddlinks` = '0',
    `caneditlinks` = '0',
    `caneditotherslinks` = '0',
    `candelete` = '0',
    `candeleteothers` = '0',
    `moderatelinks` = '0',
    `canreplytolinks` = '0',
    `canviewreplies` = '0',
    `cansearchlinks` = '0',
    `cansendlinktofriend` = '0',
    `canratelinks` = '0',
    `caneditposts` = '0',
    `caneditothersposts` = '0',
    `candeleteposts` = '0',
    `candeleteothersposts` = '0',
    `canviewlinksdir` = '0',
    `canviewprivate` = '0',
    `moderateposts` = '0'
WHERE usergroupid=6;

MySQL Error  : Unknown column 'canviewlinks' in 'field list'
Error Number : 1054
Date         : Monday, March 5th 2007 @ 11:44:13 AM
Script       : http://www.cruisesanks.com/forum/admincp/usergroup.php?do=update
Referrer     : http://www.cruisesanks.com/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address   : 82.33.142.176
Username     : cfuk
Classname    : vB_Database 


[Code Monkey]

MySQL Error : Unknown column 'canviewlinks' in 'field list'

Just what it says. You have an unknown collumn called canviewlinks. Must be from some hack that was installed or uninstalled incorrectly.

[cfuk]

thing is that i can't find any of that info in the db

[Code Monkey]

And MySQL can't find it either thus the error. You have a script or mod that is adding this to your vBulletin codebase.