Update Database Error

OS Master

vBulletin Owner

#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 |

Brandon

vBSetup Team
vBulletin Owner
vBSetup Owner

#2 09-17-2007, 07:45 PM

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.

Post your URL and a link to your vb.com username here to get full access.

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 |

Lizard King

vBulletin Owner

#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.

--------------------
Ayyas.Com | Ayyas.Com Boards | Ayyas.Com Archive | Ayyas.Com Pic. Gal. | Ayyas.Com Blogs.

Quote |

eric

vBulletin Owner
vBSetup Mods

#4 09-18-2007, 02:06 AM

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 |

OS Master

vBulletin Owner

#5 09-18-2007, 04:18 AM

Join Date: Aug 2007

Posts: 173

Location: Raleigh, NC, USA

Re: Update Database Error

Quote:

Originally Posted by Lizard King