Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
10-24-2013, 03:35 AM #1
- Join Date
- Oct 2013
- Thanked 0 Times in 0 Posts
Vbulletin database error can't find file but the file is there.
I keep getting this database error. I tried repairing in phpmyadmin but it tells me can't find file.
Also the site seems to be working fine.
Any help would be appreciated..
Database error in vBulletin 3.8.4:
INSERT INTO vbtaggregate_temp_1382554560
SELECT threadid, COUNT(*) AS views
GROUP BY threadid;
MySQL Error : Can't find file: 'vbthreadviews' (errno: 2)
Error Number : 1017
Request Date : Wednesday, October 23rd 2013 @ 11:57:03 AM
Error Date : Wednesday, October 23rd 2013 @ 11:57:03 AM
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :
10-24-2013, 03:10 PM #2
- Join Date
- Sep 2002
- Saskatoon, Saskatchewan
- Thanked 2,662 Times in 2,631 Posts
phpmyadmin won't help you. This also isn't a problem with the vb from the looks of it.
If the vbthreadviews.frm is there, than it is likely a permissions issue preventing the iteration of the directory files from whatever using is running the mysql service. If its not there, than you'll probably need to pull from a restore point. So you'll need to hop onto the os and check out the my.ini file, and grab the location for the data directories from there. Find the files in the directory path, and verify that they do exist. If they do, check that the ownership is given to the proper user (system on windows or mysql on nix). If its not there, check a backup to see if its available for restore.
Been gone for a few months, and haven't programmed in that long of a time. Meh, I'll wing it ;)PHP Code:
header('HTTP/1.1 420 Enhance Your Calm');