Jump to content

data base error


RCTSH

Recommended Posts

I have all the categories crossed, I delete them, I import them again and it doesn't work.

I have given to a cleaning with the prestashop cleaner and I get this.

    DELETE FROM `ps_category_group` WHERE `id_category` NOT IN (SELECT `id_category` FROM `ps_category`)
    705 line(s)
    DELETE FROM `ps_category_product` WHERE `id_category` NOT IN (SELECT `id_category` FROM `ps_category`)
    9193 line(s)
    DELETE FROM `ps_category_product` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)
    3 line(s)
    DELETE FROM `ps_feature_product` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)
    18 line(s)
    DELETE FROM `ps_product_tag` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)
    3 line(s)
    DELETE FROM `ps_search_index` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)
    111 line(s)
1-.also when i enter categories i get all of them inactive,
https://shortest.link/30Lm

2.-but I give to edit to start I close it and without doing anything or touching anything appear all but 5 all https://shortest.link/39Vc
3.-I think I have some problem in the root but I don't know how to look for it and solve it in the database but I don't know how to look neither in the database nor in the log that I have downloaded.

 

 

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...