Announcement

Collapse
No announcement yet.

db error when updating usergroups

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

  • db error when updating usergroups

    apologies for posting this here as it isnt a fault with vBulletin directly, more a fault with my database used by vBulletin..
    i have posted this on .org but getting very little help..

    i uninstalled an extension (ecDownloads) and since then i am getting db errors when i try to update usergroup permissions..

    here is the error:

    Database error in vBulletin 3.5.1:

    Invalid SQL:
    UPDATE vb_usergroup SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Unregistered / Not Logged In',
    `description` = '',
    `usertitle` = 'Guest',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `vbpicgallerypermissions` = '0',
    `vbpicgallerygmaxgalleries` = '5',
    `vbpicgallerymaxupload` = '6',
    `vbpicgallerymaxfilesize` = '102400',
    `forumpermissions` = '131072',
    `pmquota` = '50',
    `pmpermissions` = '0',
    `pmsendmax` = '0',
    `calendarpermissions` = '0',
    `wolpermissions` = '0',
    `genericpermissions` = '0',
    `genericoptions` = '0',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `ecdownloadpermissions` = '0',
    `adminpermissions` = '0'
    WHERE usergroupid=1;

    MySQL Error : Unknown column 'ecdownloadpermissions' in 'field list'
    Error Number : 1054
    Date : Monday, March 13th 2006 @ 08:20:45 PM
    Script : http://xxxxxxx.co.uk/admincp/usergroup.php
    Referrer : http://xxxxxxx.co.uk/admincp/usergro...&usergroupid=1
    IP Address : xxxxxxxx
    Username : xxxxxxxx
    Classname : xxx_database


    it looks to me to be a db problem, anyone give me some pointers for repairing my 'field list' (where) to not contain the 'ecdownloadpermissions' column..??!!

    once again apologies for not being directly vB related..

    thanks
    (vb3.5.1 MySQL4.0)

  • #2
    There are still plugins or code modifications that are trying to access database fields from ecdownload.
    Make sure that you completely uninstall the modification.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment

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