Wait, is the the journal script posted on evB? Last I heard that has alot more errors then just then one, just so you know.
You can try throwing this at it, are you sure you set up all the vBoptions for that script correctly?
PHP Code:
$journal_views = $DB_site->query("SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views FROM journal j LEFT JOIN user u ON u.userid = j.userid WHERE j.enabled = 1 ORDER BY j.views DESC LIMIT".$vboptions[journals_viewdisplaylimit]);
Altho im not sure why the single quotes in the array would throw it off any.