blank products

[socomtactical]

HI guys finding it hard on presta shop and driving me mad now as cant find how to sort this even on another thread.

 

 

I keep getting these show on my home page all though do not show in admin.  how do i stop these getting produced?

 

Laurence

 

[musicmaster]

Sorry, but your question is unclear. Please try to provide all the relevant information in a clear way. 

This looks like a database error. You could check for that with the Integrity Check function of Prestools. If that is indeed the problem there is a tool to repair that.

 

[socomtactical]

Hi Sorry

 

When we add products it adds these blank products some times which show in customer end but not back end. 

 

 

[socomtactical]

on that tool you have made it lists the below most of the empty name ones i have checked and have a title/name?

 

 

Products

Products in ps_product that are not in ps_product_shop:

Products in ps_product that are not in ps_product_lang: 
Lang1-Shop1: 
Lang2-Shop1:

Products in ps_product_shop that are not in ps_product:

Products in ps_product_lang that are not in ps_product:

Products with an empty name: 93,94,96,99,102,109,114,126,131,135,136,137,138,139,140,141,143,144,146,147,148,149,150,151,152,153,154,154,155,156,156,157,159,161,163,165,167,169,171,173,175,177,183,186,193,

Products in ps_category_product that are not in ps_product:

Products in ps_product that are not in ps_category_product:

Images from which the product id is not in ps_product:

 

Categories

Categories in ps_category that are not in ps_category_shop:

Categories in ps_category that are not in ps_category_lang: 
Lang1-Shop1: 
Lang2-Shop1:

Categories in ps_category_shop that are not in ps_category:

Categories in ps_category_lang that are not in ps_category:

Categories with an empty name:

Categories without valid parent:

[socomtactical]

I have run PS cleaner this clears them but doesnt fix the issue they come back when we add more products