database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • willy888
    Member
    • Dec 2007
    • 73

    database error

    In admin cp setting in usergroups / members if I change anything (example) Blog Entry Permissions Can Post New Blog Entries no I have database error

    Code:
    Database error in vBulletin 4.2.2:
    
    Invalid SQL:
    UPDATE vbusergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Members',
        `description` = '',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `vbblog_general_permissions` = '519166',
        `vbblog_customblocks` = '5',
        `vbblog_custompages` = '5',
        `vbblog_entry_permissions` = '40955',
        `vbblog_comment_permissions` = '3022',
        `forumpermissions` = '12308735',
        `genericpermissions` = '1319638915',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '63',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '5',
        `genericoptions` = '39',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '150',
        `profilepicmaxsize` = '955350',
        `avatarmaxwidth` = '100',
        `avatarmaxheight` = '150',
        `avatarmaxsize` = '900000',
        `signaturepermissions` = '235519',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '1000000',
        `sigmaxrawchars` = '1000',
        `sigmaxchars` = '500',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '4',
        `sigmaxvideos` = '1',
        `albumpermissions` = '255',
        `albumpicmaxwidth` = '1000',
        `albumpicmaxheight` = '700',
        `albummaxpics` = '100',
        `albummaxsize` = '100000000',
        `usercsspermissions` = '159',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '0',
        `maximumsocialgroups` = '0',
        `groupiconmaxsize` = '65535',
        `vbcmspermissions` = '1',
        `ms_findmyposts_permissions` = '0'
    WHERE usergroupid=2;
    
    MySQL Error   : Unknown column 'ms_findmyposts_permissions' in 'field list'
    Error Number  : 1054
    Request Date  : Tuesday, June 10th 2014 @ 06:46:08 AM
    Error Date    : Tuesday, June 10th 2014 @ 06:46:08 AM
    Script        : http://www.ultragreek.com/forums/admincp/usergroup.php?do=update
    Referrer      : http://www.ultragreek.com/forums/admincp/usergroup.php?do=edit&usergroupid=2
    IP Address    : 2**.***.***.**0
    Username      : hammer
    Classname     : vB_Database
    MySQL Version : 5.5.33-31.1
    Any change I make , I have this error
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73976

    #2
    You have a badly uninstalled addon. Please remove all files for the findmyposts addon.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • willy888
      Member
      • Dec 2007
      • 73

      #3
      Thanks for your answer , but how can I do this?

      Comment

      • willy888
        Member
        • Dec 2007
        • 73

        #4
        I find it
        I had to delete "bitfield_ms_findmyposts.xml" from "/includes/xml" directory.

        Comment

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