Announcement

Collapse
No announcement yet.

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

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

  • 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...

  • #2
    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)
    )

    Comment


    • #3
      thanks, that worked

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X