So I attempted to delete one of my forms from ODK Aggregate but unbeknownst to me, one of the form's tables had a view that was dependent on it. The delete was incomplete while some of the forms tables were deleted, others were not.
I removed the dependent view and tried to delete the form again through the web client, which still displayed the form. No luck. I then attempted to purge any reference I could find to the form in the Aggregate tables.
···
On Mon, Oct 24, 2016 at 8:27 PM, wrote:
> Hi,
>
> So I attempted to delete one of my forms from ODK Aggregate but unbeknownst to me, one of the form's tables had a view that was dependent on it. The delete was incomplete while some of the forms tables were deleted, others were not.
>
> I removed the dependent view and tried to delete the form again through the web client, which still displayed the form. No luck. I then attempted to purge any reference I could find to the form in the Aggregate tables.
>
> I deleted rows in these tables:
>
> public._form_info
> public._form_info_fileset
> public._form_info_submission_association
> public._form_info_xform_bin
> public._form_info_xform_blb
> public._form_info_xform_ref
> public._misc_tasks
> public._form_data_model
> public._backend_actions
>
> But that doesn't seem to have done the trick. To make matters worse, the web client won't stop refreshing when you login.
>
> Any suggestions?
>
> --
> --
> Post: opendatakit@googlegroups.com
> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
> Options: http://groups.google.com/group/opendatakit?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups "ODK Community" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit+unsubscribe@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
If you exported to csv or set up publishers for the form, you might have
some of those left over in their tables.
It is perhaps best to roll back to an earlier version of your database,
remove the dependent view, then use the UI to delete the form. That should
properly clean everything up.
···
On Wed, Oct 26, 2016 at 12:59 AM, Yaw Anokwa wrote:
So I attempted to delete one of my forms from ODK Aggregate but
unbeknownst to me, one of the form's tables had a view that was dependent
on it. The delete was incomplete while some of the forms tables were
deleted, others were not.
I removed the dependent view and tried to delete the form again through
the web client, which still displayed the form. No luck. I then attempted
to purge any reference I could find to the form in the Aggregate tables.