sheepiedog Posted January 17, 2005 Posted January 17, 2005 My froogle feed contribution has been working for months - no problem. I ran a feed yesterday and manually uploaded it to froogle (like I always do) I wanted to send an additional feed to froogle today and all of a sudden I am getting the below error. Ihave added new products today, but have changed no settings, I have not worked in the database - I cant figure out what has gone wrong. Does anyone have any ideas ? : SQL error Got error 28 from table handler| sql = select concat( 'http://www.dogshoppe.net/product_info.php?products_id=' ,products.products_id) AS product_url, products_model , products_weight , manufacturers.manufacturers_name , products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, FORMAT(products.products_price,2) AS price, CONCAT( 'http://www.dogshoppe.net/images/' ,products.products_image) AS image_url, concat_ws( ' > ' , catdescparent.categories_name , catdesccurrent.categories_name ) AS category FROM categories , products, products_description, categories_description as catdesccurrent, products_to_categories left join categories_description as catdescparent on ( catdescparent.categories_id = categories.parent_id ) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) 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 catdesccurrent.categories_id = categories.categories_id AND products.products_status != 0 ORDER BY products.products_id ASC Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.