Database error while trying to update filter panel settings

[techtr]

Good day, v3.4 PHP 8.1 trying to update some filter panel settings and receiving below error. Can you please assist?

Database Error: 1054 - Unknown column 'exclude_values_not_in_listing' in 'field list'
Query: insert into app_filters_panels_fields (panels_id, entities_id, fields_id, title, width, exclude_values, exclude_values_not_in_listing, display_type, search_type_match, height, sort_order) values ('26', '33', '5119', '', 'input-small', '', '0', 'dropdown', '', '', '8')
Page: /index.php?module=filters_panels/fields&action=save&panels_id=26&entities_id=33&token=bAqZhannnj
#0 includes/functions/database.php(87): mysqli_query(Object(mysqli), 'insert into app...')
#1 includes/functions/database.php(221): db_query('insert into app...', false)
#2 modules/filters_panels/actions/fields.php(34): db_perform('app_filters_pan...', Array)
#3 index.php(22): require('/home/smartf16/...')
#4 {main}

[support]

You did not update database for 3.4
Execute next query in phpmyadmin

Code: Select all

ALTER TABLE `app_records_visibility_rules` ADD `php_code` TEXT NOT NULL AFTER `mysql_query`;

ALTER TABLE `app_filters_panels_fields` ADD `exclude_values_not_in_listing` TINYINT(1) NOT NULL DEFAULT '0' AFTER `exclude_values`;

[techtr]

You did not update database for 3.4
Execute next query in phpmyadmin

Code: Select all

ALTER TABLE `app_records_visibility_rules` ADD `php_code` TEXT NOT NULL AFTER `mysql_query`;

ALTER TABLE `app_filters_panels_fields` ADD `exclude_values_not_in_listing` TINYINT(1) NOT NULL DEFAULT '0' AFTER `exclude_values`;

Solved, thank you.