Go Back   vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Please Register to get full access to the forums.
Post New Thread  Reply



#1   09-17-2007, 07:06 PM
OS Master will become famous soon enough Join Date: Aug 2007 Posts: 173 Location: Raleigh, NC, USA
Update Database Error


If I try to edit a setting in my Admin CP, I get this error message:

Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = 'Normal members.',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ei_auto` = '0',
`ei_forumid` = '',
`mgcvbprojetsugpcustomperms` = '5',
`nbmsgshowchatbox` = '',
`mgccustomusergroupperms` = '37',
`grpspermissions` = '127',
`forumpermissions` = '782847',
`genericpermissions` = '505943751',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`vbarticles` = '1999',
`credit_induction` = '0',
`credit_referral` = '50',
`credit_refbonus` = '0',
`credit_daily` = '0',
`credit_active` = '0',
`credit_birthday` = '50',
`credit_repgive` = '0',
`credit_reppos` = '0',
`credit_repneg` = '-15',
`credit_thread` = '3',
`credit_threadrate` = '0',
`credit_post` = '2',
`credit_ownthreadpost` = '2',
`credit_postsize` = '0',
`credit_pollmake` = '1',
`credit_pollvote` = '1',
`credit_unthread` = '-3',
`credit_unpost` = '-2',
`creditpermissions` = '0',
`unreq_perms` = '0',
`ws_options` = '40'
WHERE usergroupid=2;

MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date : Monday, September 17th 2007 @ 08:04:41 PM
Script : Log in - Using Your OS Forum - vBulletin Admin Control Panel
Referrer : Log in - Using Your OS Forum - vBulletin Admin Control Panel
IP Address : [removed]
Username : OS Master
Classname : vB_Database_MySQLi
I know it's referring to the column nbmsgshowchatbox. I have uninstalled that mod in the Product Manager properly. Is there a way to fix this?
Quote   |  



#2   09-17-2007, 07:45 PM
Send a message via AIM to Brandon Send a message via MSN to Brandon Send a message via Yahoo to Brandon Brandon is a glorious beacon of lightBrandon is a glorious beacon of lightBrandon is a glorious beacon of lightBrandon is a glorious beacon of light Join Date: Jul 2006 Posts: 9,827 Location: Topeka, KS
Re: Update Database Error


You might try importing the product then un-installing it again.
I've been able to clear up left over hacks b4 like that.

Make a backup first.
--------------------
Brandon Sheley / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.

Please do not PM me for support, that's what the forums are for.
Have you heard about Crowdgather?
Find it on Forums


Stay up to date by installing our Tool Bar
Quote   |  



#3   09-17-2007, 08:45 PM
Lizard King has a spectacular aura about Join Date: Sep 2006 Posts: 112 Location: istanbul
Re: Update Database Error


You need to check includes/xml folder and delete that hacks bitfield xml.
Quote   |  



#4   09-18-2007, 02:06 AM
eric is a jewel in the rougheric is a jewel in the rough Join Date: Oct 2006 Posts: 864 Location: France
Re: Update Database Error


the error report gives the answer

"MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'"

since that field doesn't exist, it can't update, most probably a hack that messed, or re import the hack or delete it completely as described by Brandon
--------------------
Eric / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.

Aeroclix -- DistantHost link directory
Domains hosting, server rent... -- Distant-Help link directory
Quote   |  



#5   09-18-2007, 04:18 AM
OS Master will become famous soon enough Join Date: Aug 2007 Posts: 173 Location: Raleigh, NC, USA
Re: Update Database Error


Quote:
Originally Posted by Lizard King View Post
You need to check includes/xml folder and delete that hacks bitfield xml.
It worked. Thank you very much. Thank you Brandon and Eric for helping as well.
Quote   |  



#6   09-18-2007, 04:50 AM
Lizard King has a spectacular aura about Join Date: Sep 2006 Posts: 112 Location: istanbul
Re: Update Database Error


Quote:
Originally Posted by OS Master View Post
It worked. Thank you very much. Thank you Brandon and Eric for helping as well.
You're welcome
Quote   |  
Post New Thread  Reply
vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Thread Tools
Display Modes

 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database error in vBulletin 3.6.7: Help. Corey vBulletin Questions 1 08-12-2007 01:32 PM
Database Error dprundle vBulletin Questions 1 06-07-2007 05:57 PM
HELP WINDOWS XP update last night now recieve error? ARealRedneck Computer Tech Information 6 04-04-2007 08:57 AM
update / read PM tespara vBulletin Questions 0 12-15-2006 05:19 PM


All times are GMT -6. The time now is 09:50 PM.

vBulletin Setup, vBulletin Setup Forums, vBulletin Services, vBulletin Blogs, vBulletin SEO, vBulletin Questions, vBulletin Skins, Styles, Templates
vBulletin Hacks / Modifications, vBulletin Monetization, Blogs, vBulletin Link Directory,Quality Link Directory