Could you try replacing it with this, and telling me what happens then?
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']
");
Thanks.