Need help!

[Dan]

I was informed by one of my members friends can't register at my site and I get this in the mail.


Database error in vBulletin 2.3.0:

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,starlevel,stari mg) VALUES
NULL,'FewynTest','74c358ae3c5a35e6322fd9ae96360d95 ','fewyn@halodex.com','1','','0','http://','','','','','1','1','0','Gamer','1055034878','1' ,'-1','1055034878','1055034878','3','0','1','1','0',' 15','0','-1','1','69.47.35.154','0','0','1','33')
mysql error: You have an error in your SQL syntax near 'NULL,'FewynTest','74c358ae3c5a35e6322fd9ae96360d9 5','fewyn@halodex.com','1','','' at line 2

mysql error number: 1064

Date: Saturday 07th of June 2003 09:14:38 PM
Script: http://www.eternalgamers.com/forums/forums/register.php
Referer: http://www.eternalgamers.com/forums/register.php

[filburt1]

Note the line break at the end of the first line of the query where "yahoo" is broken.

[Rufus69]

Meh, I would try to fix it, but either I don't have have db access or I forgot how get in. :P

[filburt1]

Look in register.php for the query, it's probably broken there (unless your e-mail client is just adding a linebreak).

[Rufus69]

I forgot the ftp password. :P I'll look for the txt that has it later, if dan doesn't fix it first.

[Rufus69]

Hmm..I'm thinking it just put a line break in, becaus eI looked at it, but no break.

[TECK]

Yes, that's the 50chars setting to break a line in VB.
Your query is wrong because you are missing a bracket. A query should have the shape:
$DB_site->query( "INSERT INTO table ( column1 , column2 ) VALUES ( 'data1' , 'data2' )" );

[Rufus69]

hm ok, thanks.