[abrecher]

Originally Posted by abrecher

I also upgraded to the latest version. Users get the following when they visit the journal page:

Database error in vBulletin 3.6.1:

Invalid SQL:

### Journal Listing ###
SELECT
journals.lastentry_uids, journals.journal_id, journals.journalname, journals.journaldesc,
journals.journalist, journals.journalist_id, entrycount, commentcount, usertextfield.jbuddylist, ipaddress, journals.lastentry,
journals.lastentry_date, journals.private, journals.whocanview, journals.lastentry_id, journals.status, journals.allowbuddies, journals.journalviews,
journals.journal_totalrating AS totalrating, journals.journal_totalvotes AS totalvotes
FROM journals AS journals
LEFT JOIN usertextfield AS usertextfield ON (journals.journalist_id=usertextfield.userid)
WHERE journals.active=1
AND (journals.journalist_id=1 OR journals.private != 1 OR FIND_IN_SET('1', journals.allowedusers))
ORDER BY lastentry_date DESC
LIMIT 0,;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 12
Error Number : 1064
Date : Friday, September 15th 2006 @ 06:22:43 PM
Script : http://www.XX.X.com/journal.php
Referrer :
IP Address : XXXXX
Username : XXXXX
Classname : XXXXX


HELP!!! ;-)

Please please someone help me!!