PHP register error!
 

hey peoples, someone got this error while trying to sign up, so can you please try and help? i recently installed the stars hack if it has something to do with this

if any1 could help please do!

Database error in vBulletin 2.2.5:

Invalid SQL: INSERT INTO user (userid,username,password,email,styleid,parentemai l,coppauser,homepage,icq,aim,yahoo,signature,admin email,showemail,invisible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotification,receivepm,emailo npm,options,birthday,maxposts,startofweek,ipaddres s,pmpopup,referrerid,nosessionhash,avatarid,starle vel,starimg) VALUES (NULL,'Marcaveli','Marc','marcaveli@freenet.de','1 7','','0','http://www.makavelishakur.de.vu','112050545','Don Marcaveli','','','1','1','0','Junior Member','1019943374','1','-1','1019943374','1019943374','2','0','0','1','0',' 15','1982-10-3','-1','2','213.168.111.45','1','0','1','1','star')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Saturday 27th of April 2002 10:36:14 PM
Script: http://www.thugnature.net/forums/forums/register.php
Referer: http://www.thugnature.net/forums/register.php


thanks!

did you add a hack?

The error means that the number of columns listed in the user table doesn't match the number of VALUES() supplied.

yes, i added the stars hack.

im not sure how to fix the problem though, im a newbie to VB

Check the install instructions for the hack again, and make sure you followed them completely. You might have missed something. At least that's what it looks like.

We already solved it. :)

nm, then :P

I'm having the same problem and I would like to know how you guys fixed it ....
in my case, english letters and numbers are excepted for user's name for registration but Arabic letters are not. My Board is in Arabic and most of people who come to register are Arabic speekers and they would like to use arabic names.
Also, Arabic letters are excepted only and only if combined with english letters or numbers like "ÇáÎÈÑ2002" or "ÇáÎÈÑyes" or "ÇáÎÈÑ2002yes"
I have award hack installed ...

please help...

and here is the error message i get when i try to register a member from admin cp

Database error in vBulletin Control Panel 2.2.2: Invalid SQL: INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,receivebulletin,showemail,invisi ble,usertitle,customtitle,joindate,cookieuser,days prune,lastvisit,lastactivity,lastpost,posts,timezo neoffset,emailnotification,receivepm,emailonpm,ipa ddress,pmpopup,options,birthday) VALUES (NULL,'2','??????','godfather','bandar@saudiadesig n.com','1','','0','http://www.','','','','','1','1','0','','0',1022865614,'1 ','-1',1022865614,1022865614,1022865614,'0','0','1','1 ','0','','0','15','birthday') mysql error: Column count doesn't match value count at row 1 mysql error number: 1136

please help ... :(

khobar, count the fields you want to insert a value and count the values you gave to your MYSQL, they dont match.

You either applied a hack wrong or if it's your query you formed it uncorrectly.

Try matching fields and values one by one like:
userid= NULL
usergroupid=2
...
...

You'll catch which value/field you missed..