What hack is this!?!?!?

[Gio~Logist]

MySQL Error : Unknown column 'showbirthday' in 'field list'
Error Number : 1054
Date : Saturday, September 10th 2005 @ 02:53:20 PM
Script : http://www.reasons2rhyme.com/community/profile.php
Referrer : http://www.reasons2rhyme.com/community/profile.php?do=editprofile
IP Address : xx.xxx.xxx.xx
Username : gio~logist
Classname : vb_database


I'm helping to run a forum and they have some hacks installed that i don't know about, but the person who installed most of the hacks isn't available. What hack is it causing this problem?

[Marco van Herwaarden]

I don't know, but 'showbirthday' is a standard vB column in the user table and should be there.

It would help if you posted the full error message including the SQL statement.

[Gio~Logist]

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
UPDATE user SET
parentemail = '',
icq = '',
msn = '',
aim = '',
yahoo = '',
homepage = '',
birthday_search = '1991-04-16',
birthday = '04-16-1991',
showbirthday = 0,
usertitle = 'BLAH MY USERTITLE',
customtitle = 2
WHERE userid = 327;

MySQL Error : Unknown column 'showbirthday' in 'field list'
Error Number : 1054
Date : Sunday, September 11th 2005 @ 01:13:29 AM
Script : http://www.reasons2rhyme.com/community/profile.php
Referrer : http://www.reasons2rhyme.com/community/profile.php?do=editprofile
IP Address : xx.xxx.xxx.xx
Username : gio~logist
Classname : vb_database

[Marco van Herwaarden]

Sounds to me like the database is messed up, that column should be in the user table.

[Marco van Herwaarden]

Hmm actually the field was added in RC3, looks like you are running some RC3 code against a RC2 database.

[Gio~Logist]

hhhhhhhhmmmmmm any idea how to fix it?
Altering the user table using a querie and adding that?

[Marco van Herwaarden]

Fix it? Simple don't use RC3 hacks on RC2.
So either remove the hack, or upgrade to RC3.

[Gio~Logist]

Lmao whoever installed that hack ont he board is an idiot....

Now i need to figure out what hack it is blah..

Thanks Marco, you've been a good help believe it or not, in both my threads so far. Lets see what comes of the other thread. All this coding is giving me a headache.