Error at startup

Classic Servoy
1

After upgrading to Version R2 2.0 beta6-build 260 I have the following error message at startup:

Error/Warnings in relatiuon(s)

Switch to design mode to fix the problem in this relation(s):

Warning: Relation ‘navigation_to_userfileswg’ has mismatched keys
Key type from usergroupid does not match with type from usergroup_id

Warning: Relation ‘navigation_to_userfiles’ has mismatched keys
Key type from usergroupid does not match with type from usergroup_id

Warning: Relation ‘users_to_userfiles’ has mismatched keys
Key type from usersid does not match with type from user_id

Warning: Relation ‘invoices_out_to_invoices_out_line’ has mismatched keys
Key type from invoices_outid does not match with type from invoices_out_id

Warning: Relation ‘dossiers_s_to_contacts_notify’ has mismatched keys
Key type from notify_id does not match with type from contactsid

Warning: Relation ‘projects_to_project_modules’ has mismatched keys
Key type from projectsid does not match with type from project_id

Warning: Relation ‘project_modules_to_projects’ has mismatched keys
Key type from project_id does not match with type from projectsid

Warning: Relation ‘prestaties_to_project_modules’ has mismatched keys
Key type from projectmodule_id does not match with type from project_modulesid

Warning: Relation ‘usergroups_to_userfiles’ has mismatched keys
Key type from usergroupsid does not match with type from usergroup_id

Warning: Relation ‘navigation_to_files’ has mismatched keys
Key type from modulnumber does not match with type from filesid

Warning: Relation ‘userfiles_to_files’ has mismatched keys
Key type from file_id does not match with type from filesid

Warning: Relation ‘files_to_userfiles’ has mismatched keys
Key type from filesid does not match with type from file_id

Warning: Relation ‘userfiles_to_usergroups’ has mismatched keys
Key type from usergroup_id does not match with type from usergroupsid

Warning: Relation ‘usertabs_to_filetabs’ has mismatched keys
Key type from filetab_id does not match with type from filetabsid

Warning: Relation ‘navigation_to_usertabs’ has mismatched keys
Key type from usergroupid does not match with type from usergroup_id

Warning: Relation ‘navigation_to_globalvalues’ has mismatched keys
Key type from g_1 does not match with type from globalvaluesid

… but everything works fine!
I tried to import my solution again, but still have this message…

What’s wrong?

2

you seem to have a lot of relations that have different datatypes on the left and the rightside

can you check those out for example

Warning: Relation ‘navigation_to_userfileswg’ has mismatched keys
Key type from usergroupid does not match with type from usergroup_id

what datatype is usergroupid and what type is usergroup_id of that relation?

3

I had the same warnings when I upgraded from b4 to b5

In earlier releases it was allowed to use a global (TEXT) in a relation with on the other side a INTEGER. It is still allowed, because everything is working fine.
But now (with the newer release) the developer warns you that the types do not match

Check your globals and change them in the right one.
than everything should work fine again.

4

OK, I’ll check it out!

Thanks for your help.

Best regards,
Stef