Log in

View Full Version : Error in database

DivineMessenger
01-21-2009, 08:28 PM
Database error in vBulletin 3.8.0:

Invalid SQL:
UPDATE vbusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12300799',
`genericpermissions` = '1512576711',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '350',
`profilepicmaxheight` = '500',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '55159',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`vbblog_general_permissions` = '257022',
`vbblog_customblocks` = '5',
`vbblog_custompages` = '5',
`vbblog_entry_permissions` = '8191',
`vbblog_comment_permissions` = '974',
`fcpermissions` = '1',
`ms_wic_addon_permissions` = '0',
`ms_wic_addon_blog_permissions` = '0',
`ms_wic_addon_vba_permissions` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'ms_wic_addon_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, January 21st 2009 @ 03:26:59 PM
Error Date : Wednesday, January 21st 2009 @ 03:26:59 PM
Script : http://300-spartans.com/forums/admincp/usergroup.php?do=update
Referrer : http://300-spartans.com/forums/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : 67.174.143.66
Username : Dexter Lee
Classname : vB_Database
MySQL Version : 5.0.67-log

I had an addon that I got rid of and my guess is that i didn't get rid of it right. What can I do?
Lynne
01-21-2009, 10:20 PM
Make sure you remove all the files you uploaded for the modification also. Especially ones in the includes/xml folder.
isatice
01-21-2009, 11:59 PM
Make sure you remove all the files you uploaded for the modification also. Especially ones in the includes/xml folder.

thanks , that was a very good tip
DivineMessenger
01-22-2009, 01:48 AM
Database error in vBulletin 3.8.0:

Invalid SQL:
UPDATE vbusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12300799',
`genericpermissions` = '1512576711',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '350',
`profilepicmaxheight` = '500',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '55159',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`vbblog_general_permissions` = '257022',
`vbblog_customblocks` = '5',
`vbblog_custompages` = '5',
`vbblog_entry_permissions` = '8191',
`vbblog_comment_permissions` = '974',
`fcpermissions` = '1',
`ms_wic_addon_permissions` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'ms_wic_addon_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, January 21st 2009 @ 08:47:30 PM
Error Date : Wednesday, January 21st 2009 @ 08:47:30 PM
Script : http://300-spartans.com/forums/admincp/usergroup.php?do=update
Referrer : http://300-spartans.com/forums/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : 67.174.143.66
Username : Dexter Lee
Classname : vB_Database
MySQL Version : 5.0.67-log

Now I get that, the problem is that the column of permissions wont delete but they are all blank...
Lynne
01-22-2009, 02:25 AM
That's the same error. Did you remove all the files for that modification? Which modification was it (link also)?
Dismounted
01-22-2009, 02:27 AM
That is caused by a bitfield_*.xml file that you have not deleted from the /includes/xml directory.
DivineMessenger
01-22-2009, 11:35 PM
I did. it made the fields blank. I just reinstalled the mods and disabled them and its all fine now.
Dismounted
01-23-2009, 03:00 AM
By having the file in there, you are causing the problem. The reason why the query is looking for the field is because it detected the bitfield file.
samuelss
03-17-2009, 07:16 PM
I am having the same problem but simply cannot remember the name of this mod. Does anyone knows the name? The xml file is called bitfiled_ms_wic_addon.xml

Thanks for any help.
Lynne
03-17-2009, 07:20 PM
Go to User CP and select your list of Installed Mods. It should be there.
samuelss
03-17-2009, 07:58 PM
Was able to sought this out.

Thanks
PGAmerica
03-28-2009, 04:53 PM
What is the name of the mod I need to re-install?
Lynne
03-28-2009, 05:38 PM
What is the name of the mod I need to re-install?
Look at your Installed Mods under User CP. It should be listed there.
PGAmerica
03-28-2009, 06:35 PM
That is no help at all. I have lots of mods there. I am trying to figure out which one is causing the problem.
mcrider
03-28-2009, 06:54 PM
It is the Flashchat who is chatting mod
PGAmerica
04-11-2009, 03:09 PM
I have removed all my flashchat modules and still have the same problem.
Lynne
04-11-2009, 03:17 PM
If you still have the problem, then you have not removed all the files, file edits, and plugins for the product. Look at the installation script and undo everything you did for installation. If you continue to have problems, you should post in the modification thread for help.
Trip3151
08-05-2009, 05:20 PM
Worked for me :) thanks for the info
kpmedia
05-31-2012, 09:12 PM
As mentioned previously, you need to remove all the xml files, some of which are not obviously part of the various Flashchat integrations.

These include:
- bitfield_fc_admincp.xml
- bitfield_fci_38.xml
- bitfield_ms_wic_addon.xml
- cpnav_flashchat.xml

I wasted about an hour on this today. :mad:

Maybe this info can help somebody save some time. :cool:

FlashChat was always a really crappy chat program anyway. I had installed it, and then disabled it due to poor communication and poor resource (ab)use. If you're wanting a quality chat program, look at AJAX Chat instead. Unlike FlashChat, it's behavior can be highly customized. (I'm not too keen on the default install, so I think customization is a must anyway.)

You'll find it here: http://sourceforge.net/projects/ajax-chat