Log in

View Full Version : I get this error when i try to add a user from the admin CP

Gutspiller
09-27-2002, 10:07 PM
Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,showemail,invisible,usertitle,cu stomtitle,joindate,cookieuser,daysprune,lastvisit, lastactivity,lastpost,posts,timezoneoffset,emailno tification,receivepm,emailonpm,ipaddress,pmpopup,o ptions,birthday) VALUES (NULL,'2','THIS WAS THE USERS NAME','THEIR PASSWORD WAS HERE','THEIR EMAIL WAS HERE','1','','0','http://www.','','','','','1','0','0','','0',1033167780,'1 ','-1',1033167780,1033167780,1033167780,'0','0','1','1 ','0','','','1','15','birthday')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Friday 27th of September 2002 05:03:00 PM
Script: /forumz/admin/user.php
Referer: http://www.theforumz.com/forumz/admin/user.php?action=add

Can somebody please help me troubleshoot this problem? I kinda need this function, but I haven't used it in a long time if ever, but now it doesn't work. It could have been any hack out of 60+ hacks. Any ideas? :(
Xenon
09-28-2002, 09:28 AM
try to copy the add user function out of an original file and replace the hacked one in your user.php
Gutspiller
10-11-2002, 11:47 PM
What exactly does the function file do? What will happen if I replace it with my original? Is this what you meant?
Xenon
10-12-2002, 08:58 AM
what will happen?
it'll work ;)

you surely have made a mistake while hacking user.php so you have to replace it with original parts and it'll work again
Gutspiller
10-12-2002, 12:29 PM
I tried replacing the whole file and I got the same error. One of the times I replaced it with an older version and it gave some error about line 14 in global.php

What else can I try? :(
NTLDR
10-12-2002, 06:27 PM
You shouldn't get any errors in global.php if only the query is wrong, check that you have the right number of options in the first row (the one with the names) and the second row (the one with the data) ;)
Gutspiller
10-12-2002, 06:53 PM
Originally posted by NTLDR
You shouldn't get any errors in global.php if only the query is wrong, check that you have the right number of options in the first row (the one with the names) and the second row (the one with the data) ;) UH... come agian. I'm sorta a noob when it comes to knowing my way around the php files. Can you give me some steps to follow as what I should look for in the php files?

When it comes to php I'm about as smart as this guy here -> :banana:

:D
NTLDR
10-12-2002, 06:57 PM
What error are you getting in global.php that you said you had? The problem should only be within user.php, can you edit users OK or do you get a DB error then too?