Help w/ Database Error. How do I fix this…

It’s an error related to the temp file on the server, and you’d need to contact your provider to have them look into it.

Usually the “errcode” errors are from the server. I’d contact the host.

Edit. Kaf was faster and more accurate!

I’m getting something similar — it came up in the installation process too:

WordPress database error: [Can't find file: './royzem/wp2_linkcategories.frm' (errno: 13)]
SELECT DISTINCT link_category, cat_name, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, list_limit FROM wp2_links LEFT JOIN wp2_linkcategories ON (link_category = cat_id) WHERE link_visible = 'Y' AND list_limit <> 0 ORDER BY cat_name

You can see it at: https://www.royzemi.com

Is this also a host problem? I don’t know much about Mysql so could someone make it clear what I need to tell the host so they understand the problem?

zemble, it’s related to the mysql files for your db (in this case the data dictionary file for the link category table). If you have access to phpMyAdmin or some other MySQL admin tool, you could use it to attempt to repair the table. But if not (or a repair does not fix the problem), your host support will have to look into it.

I fixed it. How? I deleted ALL the tables and re-ran the install. No problems at all!! Yea!

For reference for others: I also reinstalled phpMyAdmin to the latest version. I also used the standard table prefix. (I’ve no idea if these steps helped.)

Also: confession. I screwed up my attempt to upgrade and only later realized why: I didn’t remember to delete the ‘index.php’ file!!!!!! My guess is others might make the same mistake (although possibly it’s just me).

“I deleted ALL the tables and re-ran the install. “

That is definitely *one* way to run a repair on the table. :)

WordPress database error: [Can’t create/write to file ‘/tmp/#sql_7efb_0.MYI’ (Errcode: 122)]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2006-01-18 03:06:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 5

i also have this error..please help. thanks

@jbnathan18,
Did you read the replies to the previous posts (especially the first one)? Please, try to read the given answers before posting the same thing. Both answers were saying: contact your host.