Announcement

Collapse
No announcement yet.

Databse error on usergroup permissions

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

  • Databse error on usergroup permissions

    Please, I could use some help. It seems that error is caused by this hack I was trying:

    http://www.vbulletin.org/forum/showthread.php?t=148472

    At lest I think so because of this being mentioned "nbmsgshowchatbox", I can't think of any other hack that it would match.

    I've uninstalled the product but there seems to be some leftovers:

    Database error in vBulletin 3.6.7:

    Code:
    Invalid SQL:
    UPDATE usergroup SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    	`title` = 'Registered Users',
    	`description` = '',
    	`usertitle` = '',
    	`opentag` = '',
    	`closetag` = '',
    	`passwordexpires` = '0',
    	`passwordhistory` = '0',
    	`ispublicgroup` = '0',
    	`canoverride` = '0',
    	`nbmsgshowchatbox` = '',
    	`mgccustomusergroupperms` = '0',
    	`forumpermissions` = '1074762239',
    	`attachlimit` = '0',
    	`pmquota` = '50',
    	`pmpermissions` = '1',
    	`pmsendmax` = '1',
    	`calendarpermissions` = '51',
    	`wolpermissions` = '0',
    	`adminpermissions` = '0',
    	`genericpermissions` = '338171587',
    	`genericoptions` = '62',
    	`profilepicmaxwidth` = '100',
    	`profilepicmaxheight` = '100',
    	`profilepicmaxsize` = '25535',
    	`avatarmaxwidth` = '120',
    	`avatarmaxheight` = '120',
    	`avatarmaxsize` = '90000',
    	`signaturepermissions` = '169983',
    	`sigpicmaxwidth` = '500',
    	`sigpicmaxheight` = '100',
    	`sigpicmaxsize` = '20000',
    	`sigmaxrawchars` = '1000',
    	`sigmaxchars` = '500',
    	`sigmaxlines` = '0',
    	`sigmaxsizebbcode` = '7',
    	`sigmaximages` = '3',
    	`pagerpermissions` = '5',
    	`pagerquota` = '10',
    	`pagerminpost` = '1',
    	`pagerminpostperday` = '0',
    	`pagermaxperday` = '20',
    	`pagersendmax` = '1',
    	`pagersendmaxchar` = '300',
    	`tinviterpermissions` = '1',
    	`arcadepermissions` = '15',
    	`vbimghost` = '1',
    	`vbimghost_upslots` = '3',
    	`vbimghost_files` = '5',
    	`bluntswhodlpermissions` = '0'
    WHERE usergroupid=17;
    
    MySQL Error  : Unknown column 'nbmsgshowchatbox' in 'field list'
    Error Number : 1054
    Date         : Wednesday, June 6th 2007 @ 04:47:37 PM
    Script       : http://www.sat-universe.com/admincp/usergroup.php?do=update
    Referrer     : http://www.sat-universe.com/admincp/usergroup.php?do=edit&usergroupid=17
    I get this error any time I try to update any user group permissions.

  • #2
    showchatbox

    This is not a default vbulletin table/field.

    This is probably from a modification, ask the author of that mod for support please. We can't provide support for code we didn't write.

    Comment


    • #3
      Ok, I've managed to sort it out. I saw someone else reported similar problem. Author suggested that it is because all files weren't removed prior to uninstall and suggested solution to remove all the files and rebuild bitfields by hand.
      But I just installed the product again, then removed all the files. And uninstalled it. No errors now.

      Comment

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