Page 2 of 2
Re: Search form stopped working
Posted: Thu Feb 18, 2021 4:18 pm
by icoso
If I look in my table zzzzsys_object. I see all of my field object that are associated with a sob_all_zzzzsys_object_form_id of 6025b539ee163dd. but that form ID no longer exists. That was my main form. It's gone.
Re: Search form stopped working
Posted: Thu Feb 18, 2021 4:22 pm
by kev1n
Can you restore the form from a backup?
Re: Search form stopped working
Posted: Thu Feb 18, 2021 5:17 pm
by icoso
No this just happened. I'd still lose a lot of changes from yesterday.
I was able to copy an existing form from the object table to this one and change the form ID to be the same as all the objects that were on the form. (those objects still exist int he Object table. form id = 6025b539ee163dd
In nuBuilder I can open this form from the nuBuilder Form screen, but there are no objects on it when I open the object browser page. why? What other table is used in the search of the database to find the objects on this form.
I've searched through an export of the entire dB to find where the form ID's are used in what tables. I cant find where I might be missing a record to this form id. There is a tab_id on the field objects but scanning through the export that only appears to sho up in the object table and is associated to just the fields on a particular form.
Re: Search form stopped working
Posted: Thu Feb 18, 2021 5:27 pm
by kev1n
Make sure that the Tab IDs are still correct in the column zzzzsys_object.sob_all_zzzzsys_tab_id or update it with the new one (see zzzzsys_tab.zzzzsys_tab_id)
Re: Search form stopped working
Posted: Thu Feb 18, 2021 5:37 pm
by icoso
I figured it it out!!! On the new form that I previously copied and then changed the form ID to 6025b539ee163dd. There were no objects showing up. So I created an HTML text object. That created an object in the _tab table and had a form ID of 602e8695c0535f6. I found that form ID in the zzzzsys_tab I changed it to the tab ID of all the fields that I previously had that still existed in the objects table of 6025b53a091b24f. Then they all magically appeared on my object list and my form re-appeared as it was...