I have been adding quite a few good hacks from here but since doing one of them, I have the following error when I try and click on a members profile -
Invalid SQL:
SELECT thread.threadid,
thread.title AS tht,
thread.postusername,
thread.replycount,
thread.lastposter,
thread.lastpost,
thread.dateline,
user.userid AS lastposterid2,
thread.views,
thread.attach,
forum.title AS fot,
forum.forumid AS fir
FROM thread AS thread, forum AS forum, user AS user
WHERE thread.postuserid = 1
AND thread.forumid = forum.forumid
AND thread.threadid IN ()
AND thread.lastposter = user.username
LIMIT XX;
MySQL Error : You have an error in your SQL syntax near ')
AND thread.lastposter = user.username
LIMIT XX
' at line 17
Error Number : 1064
Date : Saturday, February 18th 2006 @ 06:29:15 PM
Script :
http://212.67.202.205/~mad4it4/forums/member.php?u=1
Referrer :
http://212.67.202.205/~mad4it4/forum...ead.php?t=1441
Classname : vb_database
Could anyone shed some light as to what I might have done wrong, what to look for and where to look for it.
Many thanks