Hi,
Was just checking our site so could plan some updates next week.
I noticed that "No" products are being displayed anywhere in the site (Categories, merchant links, or search), in fact there not being displayed anywhere
We added a custom widget banners from eBay in the right hand column but have now removed that just incase that was the issues. I have also tried importing all feeds using the slow import tool
Any suggestions as to what might have happened?
Thanks
Stuart
Thanks, changed config.advancaed.php to TRUE and got the below, so I guess what you said is correct, will try the repair.php file now
Thanks for replying on a Sunday evening :-)
[SELECT SQL_CALC_FOUND_ROWS * , MIN( price ) AS minPrice, MAX( price ) AS maxPrice, COUNT( id ) AS numMerchants FROM `pt_products` WHERE category = 'Dry Dog Food' GROUP BY name ORDER BY numMerchants DESC LIMIT 0,10][Can't create/write to file '/tmp/#sql_1987_0.MYD' (Errcode: 17)]
OK I added the repair.php file to the server and then went to our URL www.example.co.uk/example-shop/repair.php
This displayed a message in the browser saying DONE.
I have now changed the config.advanced.php back to FALSE and uploaded the file but still no luck, any suggestions?
Thanks
Stuart
Changed config.advanced.php back to TRUE and products are now showing, should I leave this as TRUE now?
Thanks again
Stuart
Hi Stuart,
Glad you're back up and running. This message "Can't create/write to file '/tmp/#sql_1987_0.MYD" indicates that MySQL was unable to create the temporary file required to perform the requested sort; and could indicate that your server's /tmp/ (temporary) folder is near to being full.
Keep an eye on your site regularly for a couple of days (as I'm sure you do anyway!) and if the problem recurs contact your host with the above message and they will be able to check the /tmp/ folder associated with your account.
Cheers,
David.
--
PriceTapestry.com
Once again, fantastic Thank you. I'll ask Jason to look at the server tomorrow anyway as he has access to most things, if not will ask the host to also look, just to be on the safe side...
have a good evening
Regards
Stuart
Hi Stuart,
That sounds like your `products` table may have crashed. To check this, temporarily enable database debug mode by changing $config_databaseDebugMode to TRUE at line 6 of config.advanced.php and then view the not-working pages again and you may see "Products table has been marked as crashed".
MySQL tables can, very occasionally crash for any number of reasons and are normally nothing to worry about unless they start to happen frequently; which could actually be a sign of pending hard disk failure on the server!
If this is the case, create a file containing the following code as something like repair.php and then upload and browse to the file on your server and this will run MySQL' check and repair process on the table.
<?phpset_time_limit(0);
require("includes/common.php");
$sql = "REPAIR TABLE `".$config_databaseTablePrefix."products`";
database_queryModify($sql,$result);
print "Done.";
?>
Cheers,
David.
--
PriceTapestry.com