2.0.2?
I dont remember there being a 2.0.2 but ill give you the sql query that ought to work for all 2.0.x installs.
1. Grab this zip:
http://www.village-idiot.org/makecomments.zip
2. Unpack the zip, inside it is ONE file named makecomments.php
3. Open the file on your local computer. Please note that there is nothing that is nothing that does any deletion or alterations other then one SQL statement that creates a table.
(I bring that up because I wont hear later that it did something wrong or malicious.)
4. Upload that file, makecomments.php to the root of your WordPress install. Thats where wp-config.php is.
5. Browse to the file in your browser of choice:
http://www.yoursite.com/makecomments.php
After it loads, you should have a new comments table, assuming one didnt already exist. If one exists, it will not make one.
6. DELETE the file, makecomments.php, off your server.
You can, by the way, rename that file to anything you desire, as long as it ends in .php
That way you can rest assured that someone here isnt hunting down the file on your server. Just substitute the new file name for all the references I made to makecomments.php above.
additionally, please note that that error code isnt always indicative of a missing table. If you continue to see that error after running that script — the table exists and it’s something else. perhaps something you can fix via a repair, perhaps something your host may need to address.
since there’s been no reply to this thread in 6 hours, Ive removing that file from link above.
If you need it (again), pleaase repost.
Whooami,
Thanks but you’ve removed the link before I had a chance to use it!!! Sorry, was off air because my ISP (vigin Media) was down. Can you put it back so I can apply your fix please? Many thanks in advance.
David
done 🙂 dont forget to follow the instructions above!
Hi whooami,
I really appreciate the help, but somehow the problem has moved forwards and changed. (Sometimes this internet stuff feels like alchemy to my poor brain.) The wp_comments table reappeared, and comments showed up back (amongst the DB errors) on my site. But then three other tables were giving DB errors issues, and phpMyAdmin showed them to be “in use”. They were wp_bas_visitors, wp_bas_log and wp_bas_refer. I found guidance that suggested I run a CHECK TABLE and then a REPAIR TABLE on each of these. That worked find for the first two, but on wp_bas_refer it gives a file not found error.
So my blog still fails with DB errors for that missing file (http://biztwozero.com)
Do you have another script that could recreate that table? Is there anything else you suggest.
Your help is most appreciated. Thanks!
David
all three of those most recent tables you mention are the result of using bastats
You can try this..disable bastats and re-enable it – see if that recreates the table, (if in fact, its actually missing).
Thanks Whooami,
Trying that now.
Hey whooami, if you’re still out there–
Any chance of reposting that script? I am in the same boat with the errcode: 13…
Thanks!