<SOLVED> Categories keep disappearing

[Lizbit]

This continues to happen and I'm not sure what is going on.

I can be adding products to my categories, then sign out, then go to the store to check it out. The categories won't be there. I log back in (back end) to see what's going on, and there are no categories. Sometimes I have to wait 15 or so minutes then they'll show up again. Other times like right now, I'm waiting and waiting, and I can't figure out why my categories are not showing up, back end or front.

I did NOT delete them....

Edited: Sometimes I get a message that says "Link to database cannot be established."

Now the categories are showing up but I'm getting the "Link to database" error message. And if I wait long enough, it will work again.

What is going on here?

[Lizbit]

This was due to a permissions error. I contacted our host, and they changed permissions.

[xavriley]

I got the same thing because the /tmp folder was full, meaning that MySQL wouldn't work. It was after uploading a lot of images, which get converted in /tmp but then don't get deleted straight away.

To check, use cpanel or WHM and go to 'disk space usage'. You need space on the /tmp drive for MySQL to function properly on some servers.

To fix it you need root access - login via ssh and type

cd /tmp
ls

and you should see lots of ps_import*** files where *** is a random string. These are just temp files left over from the image conversion and can be deleted with

rm -f /tmp/ps_import*

Hope that helps someone