I moved to a new server with new SQL 5.
Now i get this error when i Search the forum.

Is it possible to make it work?


Database error in vBulletin 2.2.6:

Invalid SQL:
SELECT DISTINCT post.userid,
thread.threadid,thread.threadid AS postid,thread.title AS
threadtitle,thread.iconid AS threadiconid,thread.replycount,
thread.views,thread.pollid,thread.open,thread.lastpost AS
postdateline,thread.lastpost,thread.lastposter,
forum.forumid,forum.title AS forumtitle,forum.allowicons,attach,
thread.postusername AS usrname,
user.userid AS postuserid,
threadicon.iconpath AS threadiconpath,threadicon.title AS
threadicontitle
FROM
thread,forum
LEFT JOIN user ON user.username=thread.postusername
LEFT JOIN icon AS threadicon ON thread.iconid=threadicon.iconid
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid =
'2')
WHERE
thread.forumid=forum.forumid AND thread.threadid IN
(0,7172,6346,5773,8988,9049,8218,8665,8329,8300,8063,8007,7980,7812,7551,693
9,7286,7212,7214,7110,6838,6753,6707,6706,5400,6146)
ORDER BY
thread.lastpost DESC,thread.lastpost DESC
mysql error: Unknown column 'thread.postusername' in 'on clause'

mysql error number: 1054

First I would suggest that you should upgrade to 3.6.3.

Second, if you must run version 2, post your query here and an expert will help.

Third, if you cant do step one or two then go and buy a license and don't use WAREZ!