Announcement

Collapse
No announcement yet.

Database Error

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

  • Database Error

    As I open Usergroups in AdminCP and into UserGroup Manager and from there I select Registered Users and into the persmissions setup, in this part there are many like Forum Viewing Permissions Attachment Permissions ect, before this I have a table an unidentified table with no name and four elements ! I cannot modify any permissions as soon as I try I get this error !!!!


    Database error in vBulletin 3.8.4:
    Invalid SQL:
    UPDATE turkceusergroup SET
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Registered Users',
    `description` = '',
    `usertitle` = '',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `profileviewpermissions` = '15',
    `forumpermissions` = '12317183',
    `genericpermissions` = '1546131143',
    `attachlimit` = '100000',
    `pmquota` = '50',
    `pmpermissions` = '3',
    `pmsendmax` = '5',
    `pmthrottlequantity` = '0',
    `calendarpermissions` = '63',
    `wolpermissions` = '1',
    `adminpermissions` = '0',
    `genericpermissions2` = '1',
    `genericoptions` = '62',
    `profilepicmaxwidth` = '65535',
    `profilepicmaxheight` = '10000',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '110',
    `avatarmaxheight` = '110',
    `avatarmaxsize` = '30000',
    `signaturepermissions` = '235519',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '20000',
    `sigmaxrawchars` = '1000',
    `sigmaxchars` = '500',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '5',
    `albumpermissions` = '255',
    `albumpicmaxwidth` = '600',
    `albumpicmaxheight` = '600',
    `albumpicmaxsize` = '100000',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '63',
    `visitormessagepermissions` = '63',
    `socialgrouppermissions` = '51063',
    `maximumsocialgroups` = '5',
    `groupiconmaxsize` = '65535'
    WHERE usergroupid=2;
    MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
    Error Number : 1054
    Request Date : Thursday, October 15th 2009 @ 11:48:34 PM
    Error Date : Thursday, October 15th 2009 @ 11:48:34 PM
    Script : http://mysite.com/myforum/admincp/us....php?do=update
    Referrer : http://mysite.com/myforum/admincp/us...&usergroupid=2
    IP Address : xx.xx.xx.xxx
    Username : xxxxx
    Classname : vB_Database
    MySQL Version : 5.0.32-Debian_7etch11-log

    please assist

  • #2
    As the error says, there's no column 'profileviewpermissions' in the Usergroup table. This has probably been part of an add-on that you've installed previously and has not been properly uninstalled.

    For assistance with that, you'll need to post over at www.vbulletin.org
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment

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