When we click the add product after you click the edit we get this error.

1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
in:
[SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM hspproducts p LEFT JOIN hspproducts_description pd ON pd.products_id=p.products_id LEFT JOIN hspproducts_to_categories ptc ON ptc.products_id=p.products_id LEFT JOIN hspcategories_description cd ON cd.categories_id=ptc.categories_id ORDER BY categories_name]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any thoughts?