Getting an error when making a new thread..

[MaDCaT75]

I get this error when I create a new forum and make a new thread in it. The latest hack I installed was lesane's store 3.0....... can anyone help please?

PHP Code:

Database error in vBulletin 2.3.0:

Invalid SQL: UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1,lastpost='1071699888',lastposter='?ilverWolf' WHERE forumid IN (47,)
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

mysql error number: 1064

Date: Wednesday 17th of December 2003 05:24:48 PM
Script: [url]http://www.sims2forums.com/newthread.php[/url]
Referer: [url]http://www.sims2forums.com/newthread.php?s=&forumid=47[/url] 


[g-force2k2]

there shouldn't be the space inbetwen lastposter

ie:

PHP Code:

lastposter 


not

PHP Code:

lastpost  er 


Also the end part if the sql doesn't need a comma if you're only using one forum instead just put

PHP Code:

WHERE forumid=47 


instead of

PHP Code:

WHERE forumid IN (47,) 


Regards,
g-force2k2

[MaDCaT75]

I'm looking thru my newthread.php right now.... I dont see any of those errors which you mention..... can you msg me on icq or aim or msn or something please?

[g-force2k2]

Sure, you can pm me your AIM screenname OR if you prefer you can send me the newthread.php file and I can see what changes have to be made.

The first change is probably just an error created when using php tags on vb.org, but as for the second change look for:

PHP Code:

WHERE forumid IN 


You should find that code instance, it could be a variable and not numbers in the parentheses following that code. Hope that helps.

Regards,
g-force2k2