• Hello,

    today I discovered, after a long debugging, that to sweep “Unused Terms” breaks my Database (WMPL tables)

    In detail, when I tried to translate a WooCommerce product, I received this message

    Errore sul database di WordPress: [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 = 195 AND term_taxonomy_id IN ()

    Errore sul database di WordPress: [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 = 195 AND term_taxonomy_id IN ()

    Errore sul database di WordPress: [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 = 195 AND term_taxonomy_id IN ()

    Of course, I restored my two days old backup and now it works great but…
    Luckily I discovered this problem in time and I was able to restore “Only” two days old backup. But… I cannot image people that discover this PHP error after one or two months…

    How can I solve this problem?

    Thank you

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Lester Chan

    (@gamerz)

    I can’t solve your problem and only can list the plugin you are using as incompatible.

    Do you have the specific plugin that is broken so I can list it as incompatible?

    The goal of this plugin is to clean up your database as much as possible to the original state of WordPress.

    Considering the flip side, another user is not using the plugin anymore and wishes to clean it and that is where WP-Sweep comes into the picture.

    • This reply was modified 4 years, 6 months ago by Lester Chan.
    Thread Starter scarpinoc

    (@scarpinoc)

    I know Lester,

    but WPML is one of the most popular plug-in for translation!!!
    I wasted one day of work to understand that your plug-in ruined the WPML database!
    WPML… not a simple plug-in… You must write a HUGE warning to this “Unused Terms” option

    ” DON’T USE it because it can break your DB easily… ”

    Luckily Siteground has good backup system…

    Right now I uninstalled your plug-in and I’m using WP-Optimize.
    Ok, it has a bit less option but, It doesn’t destroyed my website.
    I used in local (WAMP), I played 2 hours with my website and I didn’t see any problem now.

    Maybe you can improve your Plug-in and make it compatible with WPML… It’s a suggestion..

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WARNING! Sweep “Unused Terms” breaks WPML!!’ is closed to new replies.