MySQL Error

[lolzers]

Whenever I try to create usergroup or modify them, plus other things, I get an error like this. What do I do to fix this?

Database error in vBulletin 3.6.8:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
	(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `hkc_competition_permissions`, `imghost`, `imghostset`, `imghost_width`, `imghost_height`, `imghost_files`, `advanced_bbcode_usergroup_on`, `advanced_bbcode_usergroup_permissions`, `advanced_bbcode_usergroup_permissions_custom`)
VALUES
	('weee', '', '', '', '', '', '', '0', '0', '651271', '2626563', '1000000', '0', '0', '5', '0', '1', '0', '41', '100', '100', '25000', '50', '50', '20000', '0', '', '', '', '', '', '', '7', '', '0', '0', '', '', '', '', '0', '0', 'a0');

MySQL Error  : Unknown column 'imghost' in 'field list'
Error Number : 1054
Date         : Monday, November 5th 2007 @ 05:33:17 PM
Script       : http://habboboards.com/forum/admincp/usergroup.php?do=update
Referrer     : http://habboboards.com/forum/admincp/usergroup.php?do=add
IP Address   : 24.137.201.155
Username     : Will
Classname    : vb_database

[snakes1100]

Looks like you have a hack installed that is causing that error, disable all your hacks and see if it goes away.

[lolzers]

I disabled them all and its still there.

[snakes1100]

It appears at some point then you had a hack installed that used "imghost" as a column in the DB, i also see numerous other columns in there that arent default columns.

If the hack is removed from the site, you will need to remove those columns manually.

[lolzers]

How do I remove them?

[snakes1100]

You should probably first check and make sure what hack was using that column and make sure its no longer needed, then you can use phpmyadmin to remove them if they arent needed,

[Paul M]

You don't need to remove any columns - that error mesage is telling you that a column no longer exists, so you cannot possibly remove it (again).

Most likely you have an old bitfield xml file from a mod you have removed still in your includes/xml folder.