Results 1 to 3 of 3

Invalid SQL:usergroup SET MySQL Error

This is a discussion on Invalid SQL:usergroup SET MySQL Error within the Troubleshooting forums, part of the vBSEO SEO Plugin category; I tried to update userpermissions on admin area of bvulletin but when I try to update, i have this error ...

  1. #1
    Member
    Real Name
    patrick
    Join Date
    Sep 2007
    Posts
    43
    Liked
    0 times

    Invalid SQL:usergroup SET MySQL Error

    I tried to update userpermissions on admin area of bvulletin but when I try to update, i have this error sql.

    Do you know What is the problem ??
    Thannks you very much.

    Database error in vBulletin 3.6.0:
    Invalid SQL:
    UPDATE usergroup SET
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Administrators',
    `description` = '',
    `usertitle` = 'Administrator',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '180',
    `passwordhistory` = '360',
    `photoplogpermissions` = '458751',
    `photoplogmaxfilesize` = '512000',
    `photoplogmaxfilelimit` = '200',
    `forumpermissions` = '1048575',
    `genericpermissions` = '1072693183',
    `attachlimit` = '0',
    `pmquota` = '100',
    `pmpermissions` = '7',
    `pmsendmax` = '5',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '3',
    `genericoptions` = '63',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '20000',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `anymediapermissions` = '3',
    `arcadepermissions` = '255',
    `minpoststoplay` = '1',
    `minreptoplay` = '0',
    `minreglengthtoplay` = '0',
    `nbmsgshowchatbox` = ''
    WHERE usergroupid=6;
    MySQL Error : Champ 'nbmsgshowchatbox' inconnu dans field list
    Error Number : 1054
    Date : Wednesday, December 12th 2007 @ 01:24:06 PM
    Script : forum/admincp/usergroup.php?do=update
    Referrer : /forum/admincp/usergroup.php?do=edit&usergroupid=6
    IP Address : 84.99.000.00
    Username : *****
    Classname : vB_Database

  2. #2
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    Hello ,

    You have a third party hack installed which probably creates the problem. Try to uninstall nbmsgshowchatbox and remove all the files to see if it is the problem.
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  3. #3
    Member
    Real Name
    patrick
    Join Date
    Sep 2007
    Posts
    43
    Liked
    0 times
    I will try your solution and I will tell you later if it works.
    Thanks again.

Similar Threads

  1. vBSEO 3.0.0 Gold is Here!
    By Juan Muriente in forum vBSEO Announcements
    Replies: 55
    Last Post: 04-23-2007, 09:57 AM
  2. database error help
    By hornstar6969 in forum General Discussion
    Replies: 1
    Last Post: 02-01-2007, 06:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •