[YLP1]

Hi everyone,

I get this DB error intermittingly and it has been driving me nuts. I have searched high and low for an answer on correcting this but it still rears it's ugly head Can someone help me fix this issue? Any help is greatly appreciated:

 Database error in vBulletin 3.0.7:
Invalid SQL: 
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM vb3_user AS user
LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 
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 5
mysql error number: 1064

And this is what that section of the Calendar.php looks like:

 
$eventcomments = $DB_site->query("

SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,usertextfield.signature " . iif($vboptions['avatarenabled'], ", customavatar.dateline AS avatardateline") . " FROM " . TABLE_PREFIX . "eventcomments AS eventcomments

LEFT JOIN " . TABLE_PREFIX . "event AS event ON(event.eventid=eventcomments.eventid)

LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid=eventcomments.evecomuserid)

LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid=eventcomments.evecomuserid)

LEFT JOIN " . TABLE_PREFIX . "usertextfield as usertextfield ON(usertextfield.userid=eventcomments.evecomuserid)

" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = eventcomments.evecomuserid)") . "

WHERE eventcomments.eventid=$eventid

ORDER BY eventcomments.evecomid ASC

LIMIT $startingfrom, $perpage

");



$evecomrow = $DB_site->num_rows($eventcomments);