Unable to save rules with 4.4.1

hi @luclearmedia

Could you visit >WooCommerce>Status>Logs and review “fatal-error-xxx” for today ?

Please, check webserver logs too .

Probably, you should deactivate and activate plugin in >Plugins>Installed ?

thanks, Alex

Sorry for the delay. I tried updating to the latest version but am still having the same issue today, so had to roll back to 4.3 again.

No Woocommerce Fatal Errors, but the server recorded these:

[Mon Jul 10 22:34:21.931825 2023] [proxy_fcgi:error] [pid 16911:tid 139696730519296] [client REDACTED] AH01071: Got error ‘PHP message: WordPress database error Unknown column ‘condition_message’ in ‘field list’ for query INSERT INTO `wp_wdp_rule…………;i:1;s:5:\\”18539\\”;i:2;s:5:\\”30075\\”;i:3;s:5:\\”30462\\”;i:4;s:5:\\”30104\\”;i:5;s:5:\\”30106\\”;i:6;s:5:\\”30102\\”;i:7;s:5:\\”30098\\”;i:8;s:5:\\”30100\\”;i:9;s:5:\\”3…’, referer: https://sitename.ca/wp-admin/admin.php?page=wdp_settings</p&gt; <p>[Mon Jul 10 22:34:26.138417 2023] [proxy_fcgi:error] [pid 16911:tid 139696134637312] [client REDACTED] AH01071: Got error ‘PHP message: WordPress database error Unknown column ‘condition_message’ in ‘field list’ for query INSERT INTO `wp_wdp_rule…………;i:1;s:5:\\”18539\\”;i:2;s:5:\\”30075\\”;i:3;s:5:\\”30462\\”;i:4;s:5:\\”30104\\”;i:5;s:5:\\”30106\\”;i:6;s:5:\\”30102\\”;i:7;s:5:\\”30098\\”;i:8;s:5:\\”30100\\”;i:9;s:5:\\”3…’, referer: https://sitename.ca/wp-admin/admin.php?page=wdp_settings

[Mon Jul 10 22:42:05.582604 2023] [proxy_fcgi:error] [pid 16911:tid 139696663377664] [client REDACTED AH01071: Got error ‘PHP message: WordPress database error Unknown column ‘condition_message’ in ‘field list’ for query INSERT INTO `wp_wdp_rule…………3\\”;}}}’, ‘a:0:{}’, ‘a:0:{}’, ‘a:5:{s:4:\\”type\\”;s:5:\\”total\\”;s:5:\\”total\\”;a:2:{s:4:\\”type\\”;s:20:\\”discount__percentage\\”;s:5:\\”value\\”;s:2:\\”10\\”;}s:5:\\”…’, referer: https://sitename.ca/wp-admin/admin.php?page=wdp_settings</p&gt; <p>[Mon Jul 10 22:42:15.409821 2023] [proxy_fcgi:error] [pid 16911:tid 139695866070784] [client REDACTED] AH01071: Got error ‘PHP message: WordPress database error Unknown column ‘condition_message’ in ‘field list’ for query INSERT INTO `wp_wdp_rule…………3\\”;}}}’, ‘a:0:{}’, ‘a:0:{}’, ‘a:5:{s:4:\\”type\\”;s:5:\\”total\\”;s:5:\\”total\\”;a:2:{s:4:\\”type\\”;s:20:\\”discount__percentage\\”;s:5:\\”value\\”;s:2:\\”10\\”;}s:5:\\”…’, referer: https://sitename.ca/wp-admin/admin.php?page=wdp_settings

No error is given in the dashboard when saving – so not sure if the new version fails to create the column “condition_message”, and only attempts to insert into the column?

Hopefully this is helpful in resolving the issue. Let me know if you need any other information.

Thanks,

Luke

hi Luke

We added new field in this version, and the plugin should create this field when you deactivate/activate plugin in >Plugins>Installed

Hello, @luclearmedia!

Please, try to delete the plugin with all the data, and install it again using these steps:

1) Export all the existing rules and the settings using Pricing rules>Tools>Export settings: https://docs.algolplus.com/algol_pricing/export-settings/

Note: to export/import all your settings, please, choose “Options” value of the drop-down above the export/import textbox:?https://snipboard.io/TihtEa.jpg

2) Enable the option Pricing rules>Settings>System>Remove all data on uninstall

3) Visit the Plugin tab, disable and delete all the Advanced dynamic pricing plugins (in case if you have some copies).

4) Install the plugin again: ?https://docs.algolplus.com/algol_pricing/getting-started/#installation

5) Try to create a new rule and save it. 

6) If it saves, then import your rules and options using Pricing rules>Tools>Import settings tool. https://docs.algolplus.com/algol_pricing/import-settings/

7) If it doesn’t help, please, submit a new ticket to our helpdesk.

Thank you both for your response – I’ll try both methods and will report back when I can. Thanks!

You’re welcome