What hack is this!?!?!?

[Gio~Logist]

PHP Code:

MySQL Error  : Unknown column 'showbirthday' in 'field list'
Error Number : 1054
Date         : Saturday, September 10th 2005 @ 02:53:20 PM
Script       : [url]http://www.reasons2rhyme.com/community/profile.php[/url]
Referrer     : [url]http://www.reasons2rhyme.com/community/profile.php?do=editprofile[/url]
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]

PHP Code:

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       : [url]http://www.reasons2rhyme.com/community/profile.php[/url]
Referrer     : [url]http://www.reasons2rhyme.com/community/profile.php?do=editprofile[/url]
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.