Title: Rules removed
Last modified: March 10, 2022

---

# Rules removed

 *  [mildreypg](https://wordpress.org/support/users/mildreypg/)
 * (@mildreypg)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/rules-removed/)
 * Hello, I have the plugin Advanced Dynamic Pricing for WooCommerce actualized.
   And since 15 days ago we have a problem in which the price rules removed on their
   own withouth anyone else’s doing it, in the administration appers that we have
   20 rules created but we can’t see them.
 * We have already uninstalled and reconfigured everything from scratch and the 
   problem persists
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Frules-removed%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 13 replies - 1 through 13 (of 13 total)

 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/rules-removed/#post-15446926)
 * hi
 * could you check JS errors ?
 * short guide
    [https://wordpress.org/support/article/using-your-browser-to-diagnose-javascript-errors/#step-3-diagnosis](https://wordpress.org/support/article/using-your-browser-to-diagnose-javascript-errors/#step-3-diagnosis)
    -  This reply was modified 4 years, 2 months ago by [algol.plus](https://wordpress.org/support/users/algolplus/).
 *  Thread Starter [mildreypg](https://wordpress.org/support/users/mildreypg/)
 * (@mildreypg)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/rules-removed/#post-15446954)
 * Hi, there are not console errors in any browser, neither in the back nor in the
   front
 * [<image link> ](https://drive.google.com/file/d/1sHRZjOLqCw5qDLIHqD9qMj6r3KcajT5x/view)
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/rules-removed/#post-15446972)
 * please, visit tab Tools , Export Tools.
    Will you see the rules?
 *  Thread Starter [mildreypg](https://wordpress.org/support/users/mildreypg/)
 * (@mildreypg)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/rules-removed/#post-15447006)
 * In export all [the rules it is empty](https://drive.google.com/file/d/1zRfp-CdGDHcvyae4WwDKh15FLW7AdmvH/view),
   but in [export options](https://drive.google.com/file/d/1ukNZUP9CH1FA6rbW6wSXATMZttgW-KO_/view)
   only the configurations
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15448161)
 * please, run PHPMyAdmin, export table “wp_wdp_rules” and send SQL file to us
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15448171)
 * you should disable our plugin meanwhile
 *  Thread Starter [mildreypg](https://wordpress.org/support/users/mildreypg/)
 * (@mildreypg)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15450537)
 * Hi, [send the](https://drive.google.com/file/d/1984jVFYh_qPowjcWHq7Evi3_UtgIh6qc/view?usp=sharing)
   table
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15450731)
 * What plugin version do you use ? 4.0.4?
 * Please, visit >Plugins>Installed and deactivate/activate
 * and you should see the rules.
 *  Thread Starter [mildreypg](https://wordpress.org/support/users/mildreypg/)
 * (@mildreypg)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15450900)
 * Yes, i have [version](https://drive.google.com/file/d/1u7HUmjXK0ZF_YN7lmJ0jd6NxKfEZJmNp/view)
   4.0.4.
 * I have already done this step of deleting and installing the plugin several times
   but the [error persists](https://drive.google.com/file/d/1xkPl5D7Qr5lfo6PW1hoYggKxdA8RQ5Y_/view).
 * In the hosting it does not throw any error either
 * We have 3 other ecommerce with this plugin and they work well
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15450940)
 * hi
 * please, run PHPMyAdmin and compare table wp_wdp_rules on your websites.
    just
   add missed columns.
 * I don’t see column “rule_type” in your SQL dump.
 * we use this SQL to get rules from db
    `SELECT * FROM wp_wdp_rules WHERE 1 AND(
   rule_type IN('common', 'exclusive') OR rule_type is NULL) AND enabled = 1 AND
   deleted = 0 ORDER BY rule_type DESC, exclusive DESC, priority LIMIT 0, 25` thanks,
   Alex
    -  This reply was modified 4 years, 1 month ago by [algol.plus](https://wordpress.org/support/users/algolplus/).
 *  Thread Starter [mildreypg](https://wordpress.org/support/users/mildreypg/)
 * (@mildreypg)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15461819)
 * Hi, Help! >-<
    the error still persists, we have compared the tables and really
   found no error
 * On this [funat ](https://funat.co/)site it works fine, [here is the sql](https://drive.google.com/file/d/1fb2CPk7ALB82WA1HYt5PRMextKRDuG_8/view?usp=sharing)
 * The site that has problems [is from Natural Stores](https://naturalstores.com.co/).
   the table has been uninstalled, installed, deleted several times but the error
   persists, [here SQL](https://drive.google.com/file/d/1rPRcEJnEV8mHJR02IM1W9h10ag7Q_BEY/view?usp=sharing)
 * Thank’s
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15462072)
 * please, open wp-config.php and check if you see this line
 * define( ‘DB_CHARSET’, ‘utf8mb4’ );
 * probably, you set wrong charset in this file.
    it’s a reason why our plugin can’t
   modify table “wp_wdp_rules”.
    -  This reply was modified 4 years, 1 month ago by [algol.plus](https://wordpress.org/support/users/algolplus/).
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15462077)
 * Correct table definition is below.
    please, add missed fields.
 *     ```
                  CREATE TABLE wp_wdp_rules (
                   id INT NOT NULL AUTO_INCREMENT,
                   deleted TINYINT(1) DEFAULT 0,
                   enabled TINYINT(1) DEFAULT 1,
                   exclusive TINYINT(1) DEFAULT 0,
                   rule_type VARCHAR(50),
                   type VARCHAR(50),
                   title VARCHAR(255),
                   priority INT,
                   options TEXT,
                   additional TEXT,
                   advertising TEXT,
                   conditions TEXT,
                   filters TEXT,
                   limits TEXT,
                   product_adjustments TEXT,
                   sortable_blocks_priority TEXT,
                   bulk_adjustments TEXT,
                   role_discounts TEXT,
                   cart_adjustments TEXT,
                   get_products TEXT,
                   auto_add_products TEXT,
                   PRIMARY KEY  (id),
                   KEY deleted (deleted),
                   KEY enabled (enabled)
               ) 
       ```
   
    -  This reply was modified 4 years, 1 month ago by [algol.plus](https://wordpress.org/support/users/algolplus/).

Viewing 13 replies - 1 through 13 (of 13 total)

The topic ‘Rules removed’ is closed to new replies.

 * ![](https://ps.w.org/advanced-dynamic-pricing-for-woocommerce/assets/icon-256x256.
   png?rev=1984204)
 * [Advanced Dynamic Pricing and Discount Rules for WooCommerce](https://wordpress.org/plugins/advanced-dynamic-pricing-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/advanced-dynamic-pricing-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-dynamic-pricing-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-dynamic-pricing-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-dynamic-pricing-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-dynamic-pricing-for-woocommerce/reviews/)

## Tags

 * [rules](https://wordpress.org/support/topic-tag/rules/)

 * 13 replies
 * 2 participants
 * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/)
 * Last activity: [4 years, 1 month ago](https://wordpress.org/support/topic/rules-removed/#post-15462077)
 * Status: not resolved