Hi all,
I've a big problem with prestashop v. 1.5: I've exported then imported the full database (tables + data) of my prestashop e-commerce for some technical reasons. After the import everything works fine excepting the products visualization which appears doubled in every search and in the featured products (homefeatured) module.
I've checked the data into db and I didn't found any duplicated record. I mean: Data in PS_PRODUCT table:
ID: 51 - Article 1
ID: 54 - Article 2
ID: 55 - Article 3
Products Visualization in Back Office:
Article 1 Article 2 Article 3
Products Visualization in Front Office (!!!):
Article 1 Article 1 Article 2 Article 2 Article 3 Article 3
As you see, only the front-office is affected by the problem and only the products (category tree, users, orders, news, pages are all shown right).
I tried different type of import/export with same results: by HeidiSql; by PhpMyAdmin, by provider's specific tools. If I repeat the operation with an already imported DB (importing twice) prestashop will show the products tripled (but still no data duplication in the db)!!
What create this type of problem? Some DB o Prestashop index? A bug? I'm getting mad, pleas help me!! PS: I tried to reconstruc entirely the index using the "Preferences -> Search -> Refresh Index" option in the BO, without results.