Hello fellow vBHackers,
It looks like i'm in need of your help as well...
I get this error now and then:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT searchid, search.userid, query, searchuser, user.userid AS targetuserid
FROM search AS search
LEFT JOIN user AS user ON (user.username = search.searchuser)
WHERE searchid IN (0,4055);

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Sunday, March 4th 2007 @ 01:06:42 PM
Script : http://www.xxxxxxxx.xx/member_ajax.php?u=585
Referrer : http://www.xxxxxxxx.xx/index.php
IP Address : xx.xxx.xx.xx
Username : Magnumutz
Classname : vB_Database

I'm using vBAdvanced and AJAX Mouse over Profile View...
I'm almost sure rogersnm will find the solution

__________________

says that your using different character sets for your sql database, try matching

__________________

Thanks. Hope i make it work...