Can no longer edit products!

  • Using WooCommerce with WPML
    Installed Search & Replace. Replaced a single word recurring on multiple pages (products). It worked except I could no longer get to the product edit page. I used the plugin to create a backup of the db, so I restored the db through phpMyAdmin. The restoration through a bunch of errors but it returned the misspelled text and the site works fine, except I still cannot get to the edit product page. I disabled the plugin but still no go. Super frustrating and have no idea what to do.
    MySQL – 5.6.40
    Wordpress – 5.0.3
    WooCommerce – 3.5.3

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Frank Bueltge

    (@bueltge)

    If you deactivate the plugin Search/Replace it should work or it not an issue form the plugin. Have you a error notice? Like authorization topic. Also you can check the console of the browser, maybe a javascript error – F12 in your browser and tab Console.
    However I think it is not an issue of the plugin S/R.

    Thread Starter urban2019

    (@urban2019)

    The thing is that everything was working perfectly but I realized I had misspelled a single word (repeatedly in product descriptions), and so I installed S/R to fix it. I ran the S/R and even though it said there was an error it seemed to work and the word was changed site-wide. I then realized I could no longer get into the edit mode. It just looped back to the WooCommerce Multilingual screen.

    I had used S/R to make a db backup and so I tried to restore the db using that back up. Once again it threw an error although it did return the typing error to all the pages. I still was no able to log access the edit product page, however.

    I then disabled the plugin but that made no difference.

    I then turned off using the WooCommerce Multilingual edit option. It now allowed me to get to the product edit screen but many features are un-editable.

    Thread Starter urban2019

    (@urban2019)

    I just managed to get to the translation screen in WPLM and I got this error –

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
    SELECT count(object_id) FROM wp_term_relationships WHERE object_id = 458 AND term_taxonomy_id IN ()

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
    SELECT count(object_id) FROM wp_term_relationships WHERE object_id = 458 AND term_taxonomy_id IN ()

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
    SELECT count(object_id) FROM wp_term_relationships WHERE object_id = 458 AND term_taxonomy_id IN ()

    Thread Starter urban2019

    (@urban2019)

    I am able to view my site but I can not see any product info such as variable product options, pricing etc.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Can no longer edit products!’ is closed to new replies.