[mvfenda]

Database error in vBulletin 4.1.4:

Invalid SQL:

				SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.IF(lastthreadprefix <> '' AND allowprefix != 0, CONCAT('', lastthreadprefix, ' - ', lastthread), lastthread) AS lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
					, forumread.readtime AS forumread
				FROM forum AS forum
				 LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 705)
				LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
				LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 705);

MySQL Error   : FUNCTION forum.IF does not exist
Error Number  : 1305
Request Date  : Saturday, December 10th 2011 @ 07:41:39 AM
Error Date    : Saturday, December 10th 2011 @ 07:41:40 AM
Script        : http://**********.com/showthread.php?t=93583
Referrer      : http://***********.com/forum.php
IP Address    : ***.*.***.*
Username      : ******
Classname     : vB_Database
MySQL Version : 5.0.92-community-log