database error help please

[bahisyeri]

i need help about data base error,what i to do about this error.
Please help me.

thats my error about db:
------------------------------------------------------
Database error in vBulletin 3.6.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Adminler',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<b>',
`closetag` = '</b>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '1048575',
`genericpermissions` = '1073741823',
`attachlimit` = '1000',
`pmquota` = '1000',
`pmpermissions` = '7',
`pmsendmax` = '100',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericoptions` = '63',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '250',
`avatarmaxsize` = '65535',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '200',
`sigpicmaxheight` = '200',
`sigpicmaxsize` = '65535',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '10',
`vbgmepermissions` = '31',
`profileviewpermissions` = '15',
`vbarticles` = '4095',
`vbspacecomments` = '31',
`fcpermissions` = '0',
`vbmates` = '0',
`grpspermissions` = '511'
WHERE usergroupid=6;

MySQL Error : Unknown column 'fcpermissions' in 'field list'
Error Number : 1054
Date : Tuesday, February 13th 2007 @ 03:34:24 PM
Script : http://www.***.org/admincp/usergroup.php?do=update
Referrer : http://www.***.org/admincp/usergroup...&usergroupid=6
IP Address :
Username :
Classname : vB_Database
----------------------------------------------------------------------------------

Thanks...

And that error.

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT groupid
FROM grps
WHERE approved = '1';

MySQL Error : Table 'wenom_forum.grps' doesn't exist
Error Number : 1146
Date : Tuesday, February 13th 2007 @ 04:39:48 PM
Script : http://www.***.org/groups/
Referrer :
IP Address :
Username :
Classname : vB_Database

[Alfa1]

I have the same error. Does anyone have an idea what it is and how to solve it?

[Paul M]

fcpermissions belongs to my Flashchat Integration mod - you appear to have uninstalled the mod, but not removed the bitfield xml file.

[Alfa1]

I have the same error again. It seems as if this is connected to a hacking attack.
My chat room was working fine. Now it hangs, my chat admin shows an error message and my vbulletin user group administration shows an error as well.

Chat admin error:

vBulletin 3.6.x : Integration Error 03 : No permissions set for usergroup 6.

vbulletin usergroup admin error:

MySQL Error  : Unknown column 'fcpermissions' in 'field list'
Error Number : 1054

[Paul M]

Same as before - the field 'fcpermissions' has been removed from the usergroup table.

[Alfa1]

How does this happen and how do I resolve this?
My flashchat was running fine and I do not understand what has caused this.

[Paul M]

Someone or something runs a query to remove it.

If you uninstall the integration mod and then re-install it, it will recreate the field.

[Alfa1]

Done that and that fixed the problem. Though I am afraid it might happen again. I have addressed this here and here.

[boxerman]

It wasnt flash chat that did the problem... the error was u didnt unistall everything!