Jump to content

Bug? Doubled products visualization after DB import


Recommended Posts

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:
  1. Article 1
  2. Article 2
  3. Article 3
Products Visualization in Front Office (!!!):
  1. Article 1
  2. Article 1
  3. Article 2
  4. Article 2
  5. Article 3
  6. 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.
 
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...