When I run the task threadviews -attachmentviews or 'blog_views' I get a database error:
Database error in vBulletin 4.1.10:
Invalid SQL:
TRUNCATE TABLE threadviews;
MySQL Error : MyISAM table 'threadviews' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Error Number : 1105
Request Date : Tuesday, January 24th 2012 @ 09:14:10 PM
Error Date : Tuesday, January 24th 2012 @ 09:14:10 PM
Script : http://XXXXXXXXXX/cronadmin.php?do=runcron&cronid=2
Referrer : http://XXXXXXXXXX/cronadmin.php?do=modify
Username : Administrator
Classname : vB_Database
MySQL Version : 5.0.92-community-log
The same error for
MyISAM table 'attachmentviews' is in use (most likely by a MERGE table). Try FLUSH TABLES.
And the same error for:
MyISAM table 'blog_views' is in use (most likely by a MERGE table). Try FLUSH TABLES.
After reading this forum for hours I have reboot the server and that solved the problem.
But only for two hours and than the same database error is back.
Please any suggestion to solved this errors
Database error in vBulletin 4.1.10:
Invalid SQL:
TRUNCATE TABLE threadviews;
MySQL Error : MyISAM table 'threadviews' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Error Number : 1105
Request Date : Tuesday, January 24th 2012 @ 09:14:10 PM
Error Date : Tuesday, January 24th 2012 @ 09:14:10 PM
Script : http://XXXXXXXXXX/cronadmin.php?do=runcron&cronid=2
Referrer : http://XXXXXXXXXX/cronadmin.php?do=modify
Username : Administrator
Classname : vB_Database
MySQL Version : 5.0.92-community-log
The same error for
MyISAM table 'attachmentviews' is in use (most likely by a MERGE table). Try FLUSH TABLES.
And the same error for:
MyISAM table 'blog_views' is in use (most likely by a MERGE table). Try FLUSH TABLES.
After reading this forum for hours I have reboot the server and that solved the problem.
But only for two hours and than the same database error is back.
Please any suggestion to solved this errors
Comment