[osCmax V2.0.25] specials appear twice

[bluezdaze]

Hi,

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'

[TEP STOP]

Capture.JPG

[SMurphy]

I am getting a similar error when I click the link in the title of my Specials box.

1062 - Duplicate entry '531' for key 1

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'

[TEP STOP]

Have you had any success fixing this error?

[SMurphy]

After searching through the specials table in my database I found I have a duplicate entry.

No idea how it happened but fixed now.

If you get this problem just run this query changing the 531 for the number that shows in the error message;
SELECT * FROM specials WHERE products_id=531
Then delete one of the duplicate rows.

Don't know if the duplicate shows up in Specials on the admin panel, if it does then you should be able to delete it from there if you are not comfortable using SQL