Bug VBMail database error?

[ClutchThese]

I keep getting this email today after i did the upgrade.

Database error in vBulletin 4.1.6:

Invalid SQL:

SELECT user.*
FROM `dbtech_vbmail_message` AS dbtech_vbmail_message
INNER JOIN user AS user ON(user.email = dbtech_vbmail_message.fromaddress)
WHERE dbtech_vbmail_message.fromaddress != ''
AND dbtech_vbmail_message.bounce = '1'
AND user.dbtech_vbmail_bounceflag = '0'
GROUP BY dbtech_vbmail_message.fromaddress
HAVING COUNT(*) >= 5;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Tuesday, September 20th 2011 @ 12:46:10 PM
Error Date : Tuesday, September 20th 2011 @ 12:46:10 PM
Script : http://www.gamerumors.net/cron.php?rand=1316537169
Referrer : Xbox 360 RSS Feed
IP Address : 99.184.110.253
Username : Unregistered
Classname : vB_Database
MySQL Version :




Can anyone tell me what's wrong?

 

[Fillip H.]

Not a vBMail bug, your database tables were created with different character sets.

Figure out which character set is used in all your tables, and then check all vBMail tables and columns to ensure they're all running this character set. You can do this in phpMyAdmin

 

[ClutchThese]

uhhh..... Great.


LOL, now i have to fumble around on the server.... this should be interesting.