Announcement

Collapse
No announcement yet.

MySQL Error: Can't find file: 'vb3_threadviews' (errno: 2)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SecTa
    replied
    thanks, that worked

    Leave a comment:


  • Jake Bunce
    replied
    Since the repair is failing and that table doesn't contain any important information, I recommend you drop and recreate the table with these two queries:

    DROP TABLE threadviews

    CREATE TABLE threadviews (
    threadid INT UNSIGNED NOT NULL DEFAULT '0',
    KEY threadid (threadid)
    )

    Leave a comment:


  • SecTa
    started a topic MySQL Error: Can't find file: 'vb3_threadviews' (errno: 2)

    MySQL Error: Can't find file: 'vb3_threadviews' (errno: 2)

    Greetings. I've got the following error continuously sent to administrative mail:
    Code:
    Database error in vBulletin 3.6.8:
    
    Invalid SQL:
    
    	INSERT INTO vb3_taggregate_temp_1203980580
    		SELECT threadid, COUNT(*) AS views
    		FROM vb3_threadviews
    		GROUP BY threadid;
    
    MySQL Error  : Can't find file: 'vb3_threadviews' (errno: 2)
    Error Number : 1017
    Date         : Tuesday, February 26th 2008 @ 01:03:09 AM
    Script       : http://www.mysite.net/cron.php?&rand=133123
    Referrer     : http://www.mysite.net/showthread.php?t=31885&page=2
    IP Address   : xxx.xx.xxx.xxx
    Username     : Unregistered
    Classname    : vb_database
    Tried to do optimize/repair several times - problem still there:
    Code:
    vb3_threadredirect  	Check  	Status: OK
    vb3_threadredirect 	Optimize 	Status: Table is already up to date
    vb3_threadviews 	Check 	Error: Can't find file: 'vb3_threadviews' (errno: 2)
    vb3_threadviews 	  	
    vb3_upgradelog 	Check 	Status: OK
    vb3_upgradelog 	Optimize 	Status: Table is already up to date
    Running vB 3.6.8pl2. DB maintenance was done recently and there were no errors occurred back then...
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X