BUG - error when trying to add filter on entity

Post Reply
rmcdonald
Investor
Investor
Posts: 417
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud
Contact:

BUG - error when trying to add filter on entity

Post by rmcdonald »

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 ('242', '135', '366', '', 'input-medium', '', '0', 'dropdown_multiple', '', '', '1')
Page: /index.php?module=filters_panels/fields&action=save&panels_id=242&entities_id=135&token=6EcPc2UZ2i
#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(20): require('/home/xxxxxxx...')
#4 {main}
User avatar
support
Site Admin
Posts: 6222
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: BUG - error when trying to add filter on entity

Post by support »

Looks like update to 3.4 was not completed.
Please execute this query in phpmyadmin

Code: Select all

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