Error with Yellow's Single format for All/New/Specials etc product listings

Hi,

Ive recently installed Yellow's Single format for All/New/Specials etc product listings

I'm getting a really strange error in All Products. Some products appear twice! :blink:

I really can't think what has caused this, I searched the threads but haven't found this topic discussed anywhere.

Could someone Kindly take a look at my page and let me know where they think the problem root might be?

https://www.majesticsilver.co.uk/store/index.php?main_page=products_all

Cheers! :bigups:

Iv'e looked into this some more and the problem of items appearing twice is all over my website including the normal products listing.

I have total of 30 products set up. All the listings do total 30 products but it seems some products overwrote and duplicated themselves onto other products.. huh?:shocking:

So my total number of products is correct but just some appear twice instead of others that dont appear at all now.

I checked my categories in admin and in the first page where it lists all the top level categories the total is correct, 30 items in all categories.

But when looking into the sub categories where the products are the products that are missing have also disappeared from there! And all the products that now show duplicates on my website are also gone except just one product that is listed correctly but shows a duplicate on my website.

Im totally confused here, has my database become corrupted? how can I confirm this? Is this a permanent problem that will need reinstalling everything?!?! God I hope not!

I have no problem deleting all my test items and starting from scratch but how can I know this wont happen again?

Please could someone more experienced give some input here thanks.:unsure:

Ive now used the Check and Repair database options in my Cpanel and everything seems perfect in the databases - all say OK no errors.

I really cant think this is some regular problem in the code/PHP issue with one of the templates since this strange behaviour is also displayed in Admin....

I feel like its all crashing and burning... HELP :cry:

I have renamed one of the duplicated items just to see and when the page in admin refreshed I could see all the products that had disappeared plus the duplicates listed next to those.

I just deleted the duplicates....

I hope this wont happen again, quite scary to think that Zen Cart could do that, I know its software and can have bugs but this is really freaky! :shocking:

Anyway I cant begin to think why this happened, If someone still thinks they know how this could have happened I would appreciate any tips as this could potentially ruin everything.

Thanks a lot :D