[DR2000]

Originally posted by Sufian
Can someone please help me? Again, I installed the hack and all on 2.2.0, but I got this error when I went to my forum:

Database error in vBulletin 2.2.0:

Invalid SQL: SELECT forum.*, CASE WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon, thread.title as thtitle FROM forum left outer join thread on thread.forumid = forum.forumid and thread.lastpost >= (forum.lastpost-30) LEFT OUTER JOIN icon ON icon.iconid=thread.iconid WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
mysql error: You have an error in your SQL syntax near 'WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon, thread.title ' at line 1

Eh, don't know what you did wrong. Make sure when you were inserting lines, you didn't insert any extra line breaks... That's the only thing I could think of at this moment. Maybe some one else will have an idea where you did wrong.