CADguru |
01-04-2006 02:59 PM |
Hi,
Just installed on 3.5.2 and i can post a new journal but if i try and access the journal list i get the following SQL error:
Quote:
Database error in vBulletin 3.5.2:
Invalid SQL:
### Journal Lisiting Pagination ####
SELECT COUNT(*) AS journals FROM journals
WHERE active=1
AND (journalist_id=1 OR private !=1 OR FIND_IN_SET('1', allowedusers));
MySQL Error : Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_unicode_ci,IMPLICIT) for operation 'find_in_set'
Error Number : 1267
|
I have looked at the journals table and the allowed users column is set for utf8_unicode_ci (as are all the others)
Does anyone have any ideas?
|