3.1.1_6.1.2

sanneke · September 11, 2012, 3:12pm

New 3.1.1_6.1.2 version is out. This release is compatible with Servoy 6.1.2.

Please read the notes of release 3.1.6.1 on how to update, and to find the documentation files.: viewtopic.php?f=57&t=18675

The sampleuse_navigation file includes all the modules and contains data and meta data, this is best for new installs. The svy_framework file includes all the modules, but no data or meta data, this one is for updating your existing installation.

Fixed from Jira, in Jira you can see more details (if you don’t have rights for this project, contact us):
SVYFRMWK-173 Possibility to change/update the server/table on a program
SVYFRMWK-184 Add sort parameter to globals.svy_nav_showLookupWindow()
SVYFRMWK-186 Make that is_denied field works for security_groups
SVYFRMWK-210 history does not work
SVYFRMWK-214 After cancel new record message ‘There are edited related records, do you want to save them?’
SVYFRMWK-218 error when opening employee program
SVYFRMWK-224 button does not work on products form
SVYFRMWK-225 button does not work on lookup window
SVYFRMWK-227 tab strip on top of framework get tangled up when to many programs are open
SVYFRMWK-231 wrong tooltip when in search mode
SVYFRMWK-232 Dropdown menu inconsistent look
SVYFRMWK-235 Inconsisted look info window
SVYFRMWK-238 error when pressing button
SVYFRMWK-240 tooltips missing
SVYFRMWK-241 inconsisted look dialogs
SVYFRMWK-242 bug with calculate Hash
SVYFRMWK-248 Conversion methods do not work on 6.1.1-6.1.2
SVYFRMWK-251 Employee detail form shows editable html areas in browse model in WC
SVYFRMWK-252 Main form new design should be default smaller to not get scrollbars

[attachment=2]sampleuse_navigation.servoy[/attachment]
[attachment=1]svy_framework.servoy[/attachment]

Patch 01
I have combined all the fixes that where posted on the forum, until today, into one patch file. Follow the instructions in the file.
[attachment=0]patch01.txt[/attachment]

patch01.txt (8.68 KB)

svy_framework.servoy (1.55 MB)

sampleuse_navigation.servoy (1.89 MB)

Hans_Nieuwenhuis · September 11, 2012, 3:24pm

Thanks Sanneke !

so to upgrade from 3.1_6.1 to 3.1.1_6.1.2, I only have to replace svy_framework solution and modules ( without data ) ?

Regards,

sanneke · September 12, 2012, 7:55am

If you are already upgraded to 3.1_6.1 you can just import.

briese-it · September 12, 2012, 8:37am

I’am testing the new version. It’s running but I have errors in the console when I log in to the solution:

Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'briese_nav_navigation_keys', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'briese_nav_program', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'doc_document', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'doc_document_binary', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'doc_document_thumbnail', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'doc_document_type', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'doc_folder', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'doc_revision', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'doc_security', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'i18n_messages', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'log', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_advanced_search', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_advanced_search_criteria', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_bookmarks', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_field_validation_rule', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_foundset_filter', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_foundset_filter_parameters', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_function', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_function_arguments', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_help', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_layout', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_mail', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_mail_attachments', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_mail_mailings', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_mail_queries', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_mail_query_args', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_mail_sendmail', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_mail_settings', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_mail_tags', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_mail_templates', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_menu', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_menu_items', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_menu_items_context_menu', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_navigation_keys', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_popmenu', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_print_list', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_print_list_details', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_program', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_program_fields', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_program_toolbar', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_program_toolbar_item', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_programtabs', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_programtabs_autofill', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_properties', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_shortcut', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_shortkey', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_tab', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_tab_autofill', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_toolbar', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_toolbar_item', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_user_required_field', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_user_table_view', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'search_criteria', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'sec_element', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'sec_module', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'sec_table', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'sec_user_in_group', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'sec_user_login_attempt', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'sec_user_org', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'sec_user_password', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'sec_user_right', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'sec_user_table_properties', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'solution_notifier', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'svy_mm_properties', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'table1', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'table2', dataprovider = 'owner_id', operator = 'IN'

These errors appear only for users without “super-administrator” permissions.

sanneke · September 12, 2012, 8:52am

briese-it:
I’am testing the new version. It’s running but I have errors in the console when I log in to the solution:
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'briese_nav_navigation_keys', dataprovider = 'owner_id', operator = 'IN'

Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘briese_nav_program’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘doc_document’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘doc_document_binary’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘doc_document_thumbnail’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘doc_document_type’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘doc_folder’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘doc_revision’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘doc_security’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘i18n_messages’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘log’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_advanced_search’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_advanced_search_criteria’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_bookmarks’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_field_validation_rule’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_foundset_filter’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_foundset_filter_parameters’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_function’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_function_arguments’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_help’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_layout’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_mail’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_mail_attachments’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_mail_mailings’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_mail_queries’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_mail_query_args’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_mail_sendmail’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_mail_settings’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_mail_tags’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_mail_templates’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_menu’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_menu_items’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_menu_items_context_menu’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_navigation_keys’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_popmenu’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_print_list’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_print_list_details’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_program’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_program_fields’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_program_toolbar’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_program_toolbar_item’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_programtabs’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_programtabs_autofill’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_properties’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_shortcut’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_shortkey’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_tab’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_tab_autofill’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_toolbar’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_toolbar_item’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_user_required_field’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘nav_user_table_view’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘search_criteria’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘sec_element’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘sec_module’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘sec_table’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘sec_user_in_group’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘sec_user_login_attempt’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘sec_user_org’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘sec_user_password’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘sec_user_right’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘sec_user_table_properties’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘solution_notifier’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘svy_mm_properties’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘table1’, dataprovider = ‘owner_id’, operator = ‘IN’
Table filter not created, column not found in table or operator invalid, filterName = ‘owner_filter’, serverName = ‘svy_framework’, table = ‘table2’, dataprovider = ‘owner_id’, operator = ‘IN’



These errors appear only for users without "super-administrator" permissions.

Could you look if this is because there is a “Table filter” record. See image were to check. Look in all your keys if there are table filters that you did not create yourself and you don’t want. Also check the “table” records. I think in a earlier export there were some test records in there that should not have been there.

[attachment=0]key_eng.jpg[/attachment]

briese-it · September 12, 2012, 9:10am

Thanks for your quick reply.
Hmm, there are no table or tablefilter records. Only Layout, Program and Program toolbar item records. I have a lot of empty records in the program tab but I can’t delete them. Maybe that’s the problem?
Error:

Exception Object: org.mozilla.javascript.EcmaError: TypeError: Cannot call method "deleteRecord" of  (H:\servoy6_workspace\svy_security\forms\svy_sec_main_key_program_tbl.js#93)
MSG: TypeError: Cannot call method "deleteRecord" of  (H:\servoy6_workspace\svy_security\forms\svy_sec_main_key_program_tbl.js#93)
<null>
TypeError: Cannot call method "deleteRecord" of  (H:\servoy6_workspace\svy_security\forms\svy_sec_main_key_program_tbl.js#93)
TypeError: Cannot call method "deleteRecord" of  (H:\servoy6_workspace\svy_security\forms\svy_sec_main_key_program_tbl.js#93)
	at H:\servoy6_workspace\svy_security\forms\svy_sec_main_key_program_tbl.js:93 (deleteRecord)
	at H:\servoy6_workspace\mod_dialog\globals.js:143 (showDialog)
	at H:\servoy6_workspace\mod_dialog\globals.js:361
	at H:\servoy6_workspace\svy_nav_navigation\globals.js:1130 (_4_svy_nav_openSecurityDialog)
	at H:\servoy6_workspace\svy_nav_navigation\globals.js#1817(eval):1
	at H:\servoy6_workspace\svy_nav_navigation\globals.js:1817 (svy_nav_callBackShortkeys)

briese-it · September 12, 2012, 9:44am

I checked the tables of svy_framework and in the tables which have errors, there is no column “owner_id”. Is that correct?

Hans_Nieuwenhuis · September 12, 2012, 11:26am

Hi Sanneke,

I noticed that there is a method that is called when the user is not superuser that tries to set these tablefilters :

in svy_nav_onOpen :

	if(! (_to_sec_user$loggedin.admin_level >= 2) )	
	{
		globals.svy_nav_filterOwner();
		globals.svy_nav_filterOrganization();
	}

in svy_nav_filterOwner :

	for (var i = 0; i < _tables.length; i++) {
		databaseManager.addTableFilterParam(globals.nav_db_framework, _tables[i], "owner_id", "IN", [_owner_id, globals.zero_uuid], "owner_filter");
	}

why is this ?
because the tables do not have a column called owner_id.

Regards,

pentamsi · September 12, 2012, 3:56pm

Don’t set automatically the organization_id in the record when save.

Hans_Nieuwenhuis · September 12, 2012, 4:15pm

This is owner_id not organization_id and the errors are displayed in the developer console immediately after login.

Regards,

pentamsi · September 12, 2012, 4:57pm

Hello, I don’t know why when i enter as administrador show me this errors.

Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_program', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_program_fields', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_program_toolbar', dataprovider = 'owner_id', operator = 'IN'
Table filter not created, column not found in table or operator invalid, filterName = 'owner_filter', serverName = 'svy_framework', table = 'nav_program_toolbar_item', dataprovider = 'owner_id', operator = 'IN'

in all of the tables, any idea? thanks for all.

pentamsi · September 13, 2012, 11:02am

Why some times i can’t see the owners, and the keys?

Joas · September 13, 2012, 11:06am

Table filter not created

6.1.2 is a little more strict when filtering tables and gives these kind of warnings when trying to filter on a column that doesn’t exist.
I changed the method svy_nav_filterOwner, so that doesn’t happen anymore.

The fix will be in the next release, but if you don’t want to wait for that, you can replace the method with the one pasted below:

function svy_nav_filterOwner() {
	var _owner_id = globals.svy_sec_lgn_owner_id;
	
	var _database;
	if (globals["svy_nav_getUserDBName"]) {
		_database = globals["svy_nav_getUserDBName"]();

		if (_database != globals.nav_db_framework) {
			databaseManager.addTableFilterParam(_database, null, "owner_id", "=", _owner_id, "owner_filter");
		}
	}
	
	//filter navigation tables
	var _tables = databaseManager.getTableNames(globals.nav_db_framework);
	_tables = _tables.filter(
		function (x) {
			var _ignoredTables = ["sec_owner", "sec_owner_in_module","sec_security_key", "vlt_valuelistvalues", "vlt_valuetranslations"];
			if (_ignoredTables.indexOf(x) > -1) {
				return false;
			}
			var _jsTable = databaseManager.getTable(globals.nav_db_framework, x);
			if (_jsTable && _jsTable.getColumn("owner_id") == null) {
				return false;
			}
			return true;
		}
	);
	
	for (var i = 0; i < _tables.length; i++) {
		databaseManager.addTableFilterParam(globals.nav_db_framework, _tables[i], "owner_id", "IN", [_owner_id, globals.zero_uuid], "owner_filter");
	}
}

briese-it · September 13, 2012, 11:30am

Many thanks Joas :-)

pentamsi · September 14, 2012, 9:29am

When the solution is imported can delete the svy_post_import and svy_pre_import?

Joas · September 14, 2012, 10:08am

pentamsi:
When the solution is imported can delete the svy_post_import and svy_pre_import?

You want to delete those solutions?
Why would you want to do that?

You will need them again when you make an export from your developer to put on an application server.

sanneke · September 14, 2012, 10:16am

pentamsi:
When the solution is imported can delete the svy_post_import and svy_pre_import?

Please keep in mind that these solutions are not only for developer but also to convert your server data. They are build so that if a conversion already happened they will not run again.

pentamsi · September 14, 2012, 11:00am

Okey, thanks Joas. But in the application server i think make a new install of the framework and all the data becomes from the developer servoy. But thanks for all.

sanneke · October 1, 2012, 10:38am

Created patch 01, see original post:
viewtopic.php?f=57&t=18750&p=100995#p100995

DEK4 · December 17, 2012, 1:21am

Hello!
What about the new release?

Topic		Replies	Views
3.0.1b_6.0.6 and 3.0.1b3_6.1.rc2 Classic Servoy	35	786	August 20, 2012
3.0.1b2_6.0.6 Classic Servoy	28	473	June 5, 2012
Framework 3.0.1b_6.0.6 Classic Servoy	11	416	April 13, 2012
Release Frameworks 6.0.1.86 Classic Servoy	21	491	November 29, 2011
Release Frameworks 6.884 Classic Servoy	7	388	September 9, 2011

3.1.1_6.1.2

Related topics