[powerful_rogue]

Originally Posted by powerful_rogue

Ive just installed on the latest 3.7 vb and it comes up with this error when I click on the "Total guests that have vistied....."

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT COUNT(dateline) AS count, guest.*
FROM guest AS guest
LEFT JOIN guestviews as guestviews
ON (guest.guestid = guestviews.guestid AND guestviews.dateline > 1219964400)
WHERE lastactive > 1219964400 AND spider = ''
GROUP BY guestid
ORDER BY lastactive DESC
LIMIT 1000;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, August 29th 2008 @ 12:35:16 AM
Error Date : Friday, August 29th 2008 @ 12:35:16 AM
Script : http://www.thefreebiefinder.co.uk/fo...&type=Visitors
Referrer : http://www.thefreebiefinder.co.uk/forum/index.php
IP Address : 80.4.18.212
Username : Dave
Classname : vb_database
MySQL Version : 4.1.20

Any help greatly appreciated