mysql error number: 1136

[taffy056]

Hi,

I have a problem with people regisitering on my forums, it is probably related to a hack, can someone determine which hack is the problem from the info below, or maybe have a solution.

thanks
taffy

installed hacks:

Petz
Arcade
RPG
Vbookie
vbchat
Shoutbox Ver 1.04
vstocks


Database error in vBulletin 3.0.5:

Invalid SQL:

INSERT INTO user

(username, salt, password, passworddate, email, parentemail,

showvbcode, usertitle, joindate, daysprune, lastvisit, lastactivity, usergroupid, timezoneoffset,

options, maxposts, threadedmode, startofweek, ipaddress, pmpopup, referrerid,

reputationlevelid, reputation, autosubscribe, birthday, birthday_search)

VALUES

('testing',

'}u`',

'2f24bed5f62b0cd5c1f17568fcbe7f1d',

NOW(),

'testing@DOMAIN.net.uk',

7,

'',

1,

'Junior Member',

1105541745,

0,

1105541745,

1105541745,

3,

'0',

3159,

-1,

0,

1,

'84.*.*.*',

0,

0,

5,

10,

-1,

'05-05-0000',

'0000-05-05'

)



mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Wednesday 12th of January 2005 03:55:45 PM

Script: http://domain.com/forum/register.php (http://domain.com/forum/register.php)

Referer: http://domain.com/forum/register.php (http://domain.com/forum/register.php)

Username: testing

IP Address: 84.*.*.*

[manguish]

When did the problem occur?

What was the last hack installed?

Think about these - if all was well until you installed something (i'm guessing you didn't hack them all at once without testing) then that'll point the finger.

[Andreas]

Check the changes you made to register.php.

The query which generates the error tries to insert a value (7) between email and parentemail for which the columnname is not defined.

[taffy056]

Hi Kirby,

Thanks for the answer to the problem, after checking register.php I discovered a stray line of code from a hack I removed, once deleted everything is fine :)

taffy