[johnstires]

okay so now I have a new problem. If I have vba cmps in my root directory along with forums and forums2 (my temp), how do I upgrade vba cmps without touching my currently live files?

Also I am getting this error on my forums2/admin/index.php

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT adminmessage.adminmessageid
FROM adminmessage AS adminmessage
INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
WHERE adminmessage.status = 'undone'
AND adminmessage.script <> ''
AND adminlog.dateline > adminmessage.dateline
GROUP BY adminmessage.adminmessageid;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Thursday, August 10th 2006 @ 11:11:51 PM
Script : http://localhost/forums2/admincp/index.php?do=home
Referrer : http://localhost/forums2/admincp/index.php?do=nav
IP Address :
Username : admin
Classname : vB_Database