Corrupt framework tables

Classic Servoy
1

It seems several tables of the svy_framework db are corrupted, now we’ve updated to 6.0.7 these tables are causing errors in the Solution. I’ve manually fixed the nav_properties table. So I can log into the solution again. But there are more tables that are affected (nav_programs for example). I’m hoping there is a simpeler fix than manually change row by row.
This is how the form_object field in nav_program looks like:

"{"javaClass":"java.util.ArrayList","list":[{"_3":1,"javaClass":"org.mozilla.javascript.NativeArray","_0":1,"_1":"detail","_2":"call_dtl"},{"_3":1,"javaClass":"org.mozilla.javascript.NativeArray","_0":2,"_1":"table","_2":"call_tbl"}]}"

And this is another row that is correct (at least I think it is :? ):

"[[1,"detail","e_report_scheduler_dtl",1],[2,"table","e_report_scheduler_tbl",1]]"

Does anybody have a way to fix this for instance by a query, or with a simple function?

2

The problem seems to be that the old data can not be read. You can solve this by going to the configurator (ctrl+1). Delete the properties. Use the reload button to recreate them. The recreation will enter default values if you had something specific you will have to change it.

3

Unfortunately that did not work, because I could not logon and ctrl-1 did nothing. After manuallly changing the properties I could logon. So the nav_properties table is now fixed. But the nav_program table is where my next problem is, that is where the example from my original post is from.

4

Yeah, the nav_program table is a bit more work, if you change the baseformname, and change it back the objects will be restored. But you will have todo this for each record.