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?


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: http://www.sims2forums.com/newthread.php
Referer: http://www.sims2forums.com/newthread.php?s=&forumid=47

[g-force2k2]

there shouldn't be the space inbetwen lastposter

ie:
lastposter

not
lastpost er

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

instead of
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:
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