I'm getting the following error:
PHP Fatal error: 126:Incorrect key file for table '/dev/shm/#sql_c40_0.MYI'; try to repair it :: SELECT (SELECT p.products_price FROM (products p, products_description pd, products_to_categories p2c ) ORDER BY p.products_price LIMIT 1) AS low, (SELECT p.products_price FROM (products p, products_description pd, products_to_categories p2c ) ORDER BY p.products_price DESC LIMIT 1) AS high in /hsphere/local/home/xxxxx/includes/classes/db/mysql/query_factory.php on line 101
I thought maybe the above SQL was incorrect but when developing on my localhost I wasn't getting any error of the sort. I've read on here and elsewhere that it could be a tmp table size problem on the server but by host says that it's unlikely to be a server error and want to charge me money to investigate
I'm using a zencart 1.5 if that makes any difference at all.
Does anyone have ideas on what I could try to do to fix this?
You'll need to attempt to repair your tables. You can do this by connecting to your database via your command line, phpMyAdmin or through some sort of GUI.
I'll assume your host possibly provide phpMyAdmin access, so try that first as it's relative simple to check your tables.