Rules removed

mildreypg
(@mildreypg)

4 years, 2 months ago

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 to see the link]

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

Plugin Author algol.plus
(@algolplus)

4 years, 2 months ago
hi

could you check JS errors ?

short guide
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.
Thread Starter mildreypg
(@mildreypg)

4 years, 2 months ago

Hi, there are not console errors in any browser, neither in the back nor in the front

<image link>

Plugin Author algol.plus
(@algolplus)

4 years, 2 months ago

please, visit tab Tools , Export Tools.
Will you see the rules?

Thread Starter mildreypg
(@mildreypg)

4 years, 2 months ago

In export all the rules it is empty, but in export options only the configurations

Plugin Author algol.plus
(@algolplus)

4 years, 1 month ago

please, run PHPMyAdmin, export table “wp_wdp_rules” and send SQL file to us

Plugin Author algol.plus
(@algolplus)

4 years, 1 month ago

you should disable our plugin meanwhile

Thread Starter mildreypg
(@mildreypg)

4 years, 1 month ago

Hi, send the table

Plugin Author algol.plus
(@algolplus)

4 years, 1 month ago

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
(@mildreypg)

4 years, 1 month ago

Yes, i have version 4.0.4.

I have already done this step of deleting and installing the plugin several times but the error persists.

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
(@algolplus)

4 years, 1 month ago
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.
Thread Starter mildreypg
(@mildreypg)

4 years, 1 month ago

Hi, Help! >-<
the error still persists, we have compared the tables and really found no error

On this funat site it works fine, here is the sql

The site that has problems is from Natural Stores. the table has been uninstalled, installed, deleted several times but the error persists, here SQL

Thank’s
Plugin Author algol.plus
(@algolplus)

4 years, 1 month ago
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.
Plugin Author algol.plus
(@algolplus)

4 years, 1 month ago
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.

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

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

Tags