When an item is made a special, it appears twice if the manufacturers link is clicked for that item, but not if the specials link is clicked. Once in awhile, I get this error message but when the page is refreshed there is no error. In the image below, if you click on the first item in "browse by product", the dupes appear as the image shows. Any thoughts? website is bubalina
1062 - Duplicate entry '0' for key 'PRIMARY'
insert into specials_retail_prices select s.products_id, s.specials_new_products_price, s.status, s.customers_group_id from specials s where s.customers_group_id = '0'