[sabret00the]

Originally Posted by perfphysio

since upgrading the 3.6.3 I have encontered the following error

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT u.username, u.userid, u.email, u.joindate, ua.activationid, u.languageid
FROM vb_user u
LEFT JOIN vb_useractivation ua ON (u.userid = ua.userid)
WHERE u.usergroupid = 3 AND u.posts = 0;

MySQL Error : Can't open file: 'vb_useractivation.MYI'. (errno: 145)
Error Number : 1016
Date : Friday, November 24th 2006 @ 04:30:40 AM
Script : http://www.physiobob.com/forum/admin...ncron&cronid=9
Referrer : http://www.physiobob.com/forum/admin....php?do=modify
IP Address : 81.149.142.220
Username : physiobob
Classname : vb_database


Any ideas

Run a repair on your useractivation table.