MySQL error while trying to edit HTML Markup for usergroups.

[john1744]

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Sheep',
`description` = 'Nintendo Fanboys',
`usertitle` = '',
`opentag` = '<span style=\"font-weight: bold;color: #fe0000\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '1',
`canoverride` = '1',
`mh_unm_permissions` = '0',
`mh_unm_changelimit` = '30',
`mh_unm_viewhistorylimit` = '1',
`forumpermissions` = '269213703',
`attachlimit` = '1000000',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '5',
`calendarpermissions` = '32',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '5123',
`genericoptions` = '8',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`arcadepermissions` = '0'
WHERE usergroupid=152;

MySQL Error : Unknown column 'arcadepermissions' in 'field list'
Error Number : 1054
Date : Saturday, December 3rd 2005 @ 04:25:58 AM
Script : ***************
Referrer : *********************
IP Address : *******
Username : HAL-9000
Classname : vb_database

It looks like this is an error due to the uninstall of the v3arcade system. I uninstalled that and installed the ibProArcade system.

Any ideas?

Nevermind fixed it.

[wizardace]

Hey, I have the same problem. How did you fix it?

[Marco van Herwaarden]

Looks like an incomplete uninstall of an arcade hack.

[wizardace]

That's right. When I try to uninstall it there is another sql error but in this case it makes the forum obsolete as you can't post so I had to deactivate the product.

[Marco van Herwaarden]

Then also remove the added files from ./includes/xml

[wizardace]

Actually after running this: ALTER TABLE vb3_usergroup ADD arcadepermissions INT( 10 ) UNSIGNED NOT NULL
everything's okay.