Common Report Extension Error

[fahmisalim]

Hi Sergey,

When add common report theres an error as below:

Regards,
FS

[fahmisalim]

Error as below:

Database Error: 1054 - Unknown column 'dashboard_counter_hide_zero_count' in 'field list'
Query: update app_reports set name = 'Anggota Keluarga Belum Divalidasi', entities_id = '22', menu_icon = '', dashboard_sort_order = '0', in_dashboard_counter = '0', in_dashboard_icon = '0', in_dashboard_counter_color = '', in_dashboard_counter_fields = '', dashboard_counter_sum_by_field = '', dashboard_counter_hide_count = '0', dashboard_counter_hide_zero_count = '0', users_groups = '4', assigned_to = '9', reports_type = 'common', in_menu = '0', in_dashboard = '0', in_header = '0', in_header_autoupdate = '1', displays_assigned_only = '0', created_by = '1', notification_days = '', notification_time = '', fields_in_listing = '', listing_type = '', rows_per_page = '' where id='193'
Page: /fa/index.php?module=ext/common_reports/reports&action=save&id=193

Regards,
FS

[rmcdonald]

I tried to test this also but when I put the tick in hide if 0 it would not let me save the changes just hung on the field edit screen

[support]

To fix this issue run next query in phpmyadmin

Code: Select all

ALTER TABLE `app_reports` ADD `dashboard_counter_hide_zero_count` TINYINT(1) NOT NULL AFTER `dashboard_counter_hide_count`;

[rmcdonald]

On second attempt I got the same error - I found why it wasnt letting me save it - under access it is insisting that users field is a required field where it shouldnt be

[rmcdonald]

Also applied the fix above and that worked fine , just need to remove the required field from Users