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
 
Referer: 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