Ok, I'm getting weird errors when I try to post a journal entry. And I'm getting a weird error when I try to access the journal now. Here is the error:
Database error in vBulletin 3.5.0:
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=1
AND entry_active='1'
GROUP BY journal_entries.entry_id
ORDER BY entrydate DESC
LIMIT 0,10;
MySQL Error : Unknown column 'journal_entries.np' in 'field list'
|