[jarcher]

I just upgraded to vb3.6.0

and I am running into all sorts of issues
this being one of them:

Warning: Division by zero in /includes/functions.php on line 1924
Database Error Database error

Database error in vBulletin 3.6.0:

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=12 OR journals.private != 1 OR FIND_IN_SET('12', 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 : Wednesday, August 16th 2006 @ 10:13:02 PM
Script : http://www.longislandphil.com/journal.php
Referrer : http://www.longislandphil.com/index.php
IP Address : xxxxxxxxxx
Username : jarcher
Classname : vb_database

I am just stuck. .

can someone assist,tutor,guide,guess
or have any info that will point me in the right direction. . .?


I have searched the thread and I can only find similer issues
and no solutions. . ( I cannot find them, mind you. . )

thank you in advance. .

jarcher