Google Base Upload

[josh26]

Hello

 

Can anyone tell me how to fix this problem.My feed has been working fine for 3 years then all of a sudden I get this.I cant seem to find the issue.Thank You in advance

 

It happens when I hit run feed in admin

 

 

 

: SQL error Incorrect key file for table '/tmp/#sql_14ef_0.MYI'; try to repair it| sql = SELECT concat( 'http://www.wholesaledirectbiz.com/oscommerce/product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.wholesaledirectbiz.com/oscommerce/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM (categories, categories_description, products, products_description, products_to_categories) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id ORDER BY products.products_id ASC

[arietis]

Can anyone tell me how to fix this problem.My feed has been working fine for 3 years then all of a sudden I get this.I cant seem to find the issue.Thank You in advance

 

It happens when I hit run feed in admin

 

: SQL error Incorrect key file for table '/tmp/#sql_14ef_0.MYI'; try to repair it|

 

it looks like the mysql index file got corrupted, and it says to "try to repair it." but the file name appears to be a temporary one...probably because of the type of select you're doing. is the filename different each time you run this? if so, you should contact your host as this is likely an issue with their mysql installation that they will have to resolve.

 

if this is not a temporary file and is one of your tables, then use phpmyadmin and select that table and tell it to do a repair. that should resolve your issue.