Tried again, and had someone else check the install. First one looked fine to him.
Installed it again with a fresh annoucement.php, same error.
Lines 37-44 w/o the // comments
PHP Code:
LEFT JOIN userfield ON userfield.userid=announcement.userid
".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid LEFT JOIN customavatar ON customavatar.userid=announcement.userid","")."
WHERE startdate<='$datenow' AND enddate>='$datenow' AND $forumlist $announcementsql ORDER BY startdate DESC");
while ($post=$DB_site->fetch_array($announcements)) {