[dethfire]

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT journal_entries.entry_id, journal_entries.entrytitle,
journal_entries.entrytext, journal_entries.mood, journal_entries.np, journal_entries.allowbuddies,journal_entries.entry date,
journal_entries.entry_totalvotes, journal_moods.mood_name, journal_entries.ipaddress,journal_moods.mood_image , journal_entries.entry_totalrating,
journal_entries.private, journal_entries.whocanview,
COUNT(journal_comments.comment_text) AS comments
FROM journal_entries AS journal_entries
LEFT JOIN journal_comments AS journal_comments ON (journal_entries.entry_id=journal_comments.entry_i d)
LEFT JOIN journal_moods AS journal_moods ON (journal_moods.mood_id=journal_entries.mood)
WHERE journal_entries.journal_id=2
AND entry_active='1'
AND (journal_entries.private != 1 OR FIND_IN_SET('1', journal_entries.allowedusers))
GROUP BY journal_entries.entry_id
ORDER BY entrydate DESC
LIMIT 0,10;

MySQL Error : Unknown column 'journal_entries.np' in 'field list'
Error Number : 1054
Date : Tuesday, November 22nd 2005 @ 02:17:07 PM
Script : http://www.physicsforums.com/journal...howjournal&j=2
Referrer : http://www.physicsforums.com/journal.php
Classname : vb_database