(problem) - mysql error when i push UPDATE button.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GigaSb
    New Member
    • Nov 2005
    • 11

    (problem) - mysql error when i push UPDATE button.

    when i push "update" button after changing basic group Permissions.
    i get this error:


    Database error in vBulletin 3.6.8:

    Invalid SQL:
    UPDATE vbforumusergroup SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'מנהלי האתר',
    `description` = '',
    `usertitle` = '<img src=\"http://www.mysite.com/forum/images/dargot/menahel-rashi.gif\"></img>',
    `opentag` = '<b><font color=\"blue\">',
    `closetag` = '</font></b>',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `forumpermissions` = '1040383',
    `genericpermissions` = '535779055',
    `solvedthreadpermissions` = '1',
    `attachlimit` = '0',
    `pmquota` = '100',
    `pmpermissions` = '7',
    `pmsendmax` = '0',
    `calendarpermissions` = '63',
    `wolpermissions` = '15',
    `adminpermissions` = '1',
    `genericoptions` = '63',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '2000',
    `sigmaxrawchars` = '1000',
    `sigmaxchars` = '500',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '4',
    `awardpermissions` = '1',
    `mgccustomusergroupperms` = '0',
    `nbmsgshowchatbox` = '',
    `invites_permissions` = '0',
    `invites_target_ugp` = '0'
    WHERE usergroupid=5;

    MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
    Error Number : 1054
    Date : Friday, August 10th 2007 @ 04:07:56 PM
    Script : http://www.mysite.com/forum/admincp/....php?do=update
    Referrer : http://www.mysite.com/forum/admincp/...&usergroupid=5
    IP Address : XX.XXX.XX.XX
    Username : Webmaster
    Classname : vb_database
  • DelphiVillage
    Senior Member
    • Apr 2002
    • 1051
    • 4.1.x

    #2
    that is from a plugin/hack you have installed ....

    Comment

    • GigaSb
      New Member
      • Nov 2005
      • 11

      #3
      PROBLEM SOLVED!!!

      can lock.
      Last edited by GigaSb; Fri 10 Aug '07, 6:45am.

      Comment

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