Thread Starter
dylanj
(@dylanj)
Okay, I did some digging around and found the query that it was calling to get a list of all the categories:
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘location’) ORDER BY t.name ASC
Copy/pasted into phpmyadmin and got an error like this:
Can’t create/write to file ‘/var/lib/mysql/#sql_5af9_0.MYI’ (Errcode: 13)
Turns out, the permissions on the /tmp directory had been changed for some reason (external to WordPress, obviously), which was causing MySQL to behave strangely!
Hope anyone else having this issue will find this useful.
Thread Starter
dylanj
(@dylanj)
An update: I have just found this exact same issue on another site which is hosted on the same Debian server. That site was coded by a different developer years ago, so it must be something to do with either the server or WordPress.
Either way, I’d like to track it down and figure out what’s doing it. Anyone got any ideas?
