Help Parse Error!!

[chad777]

$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,NP,allowsmilie,showsignature,i paddress,iconid,visible,usermoodid,usermoodpath,us ermoodmessage) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername))."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','".addslashes($nowplaying)."','$allowsmilie','$signature','$ipaddress','$iconi d','$visible','$usermoodid','$usermoodpath','".addslashes(htmlspecialchars($usermoodmessage))."')");

Can anyone tell me where the error is in this please ???

Its been driving me crazy

error I am getting is Parse error: parse error, unexpected ')' in /home/ravescen/public_html/newreply.php on line 336

[chad777]

nevermind i found it the above error now I am getting another error about wrong syntax can anyone look at this and see if they see anything wrong thanks

[g-force2k2]

the query looks okay to me...what kind of sytax error is it giving you? regards...

g-force2k2

[chad777]

well i fixed that one. now I am having a problem with newtread after installing the sticky thing.

at around line 287:

$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,p ostusername,postuserid,lastposter,dateline,iconid, visible,attach,sticky) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."','$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount','$stickynow' )");

everytime i try to start a new tread (push the submit buttom) I get this database error:

Database error in vBulletin 2.2.6:

Invalid SQL: select uid, newthread from storepoint where uid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

[g-force2k2]

thats because the uid value that you're trying to select either is getting the wrong variable or doesn't exist... it doesn't have to do with the INSERT INTO thread query... regards...

g-force2k2

[chad777]

Have any idea what I should look for to check if it is right like [userid]

The reason I was looking at the query is because there was a database error before the one above before that, that said that line.....then i fixed or atleast I thought and now i get that error

[chad777]

The only things that have uid= in them are:

$gettotalpoint=mysql_query("SELECT uid, newthread, reply, admin_mod, morereply from storepoint where uid=$bbuserinfo[userid]");

$result=$DB_site->query("select uid, newthread from storepoint where uid=$postuserid");

$DB_site->query("UPDATE storepoint SET newthread=$newpoints where uid=$postuserid");

[g-force2k2]

chad open the file that the error was in and find that select query and post it here so i can see whats up with it... regards...

g-force2k2

[chad777]

here is the whole newthread.php file

:)

[g-force2k2]

first of chad please remove the file you can't post full vb files just don't want you to get in trouble ;) second find this:

$gettotalpoint=mysql_query("SELECT uid, newthread, reply, admin_mod, morereply from storepoint where uid=$bbuserinfo[userid]");

replace it with this:

$gettotalpoint = $DB_site->query_first("SELECT uid, newthread, reply, admin_mod, morereply FROM storepoint WHERE uid='$bbuserinfo[userid]'");

see if that works regards...

g-force2k2

[chad777]

Database error in vBulletin 2.2.6:

Invalid SQL: select uid, newthread from storepoint where uid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

same...

I have noticed when I do start a new thread it does the post the thread even though it errors. :(

[chad777]

the new thread post but nothing as the message if that helps any

[g-force2k2]

just pm me the file this time ;) so i can look through it and see what i can do... regards...

g-force2k2