Appolgoies to anyone having issues, I know what the problem is but the app should be fixing the issue but is not for some reason, essentially the new version needs a number of new fields in the database and the verify database function should fix these but is not for some reason.

Please send me any emails it is trying to send if you go on the maintenance screen.

So if you are having issues please try these steps first, close the app completely.

Open the app again, go to maintenance, press on "verify structure" then "verify database" this should fix the issue, but it seems like it is not for some reason, worst case is I need to get a copy of your database emailed to me, the only way currently is to use itunes to make a copy of the database to email to me.

The name of the file is listed at the top of the maintenance screen with the title of Db.

My guess is once I have 3-4 databases off of people having issues I will be able to work out all the issues and patch the app properly.

In the meantime the following scripts copy and pasted into the maintenance advanced screen might get a few of you up and running.

if you open this post on the iPad or iPhone and cut and paste the following into the box

alter table tblpoints add last_answer int,
alter table tblrevision_set add total_points_filtered int,
alter table tblrevision_set add total_pointed_filtered int,
alter table tblrevision_set total_sticky_filtered int,
alter table tblrevision_set total_plotted_filtered int,
alter table tblrevision_set add last_answer int,
alter table tblpoints add audio_notes varchar

then press execute.


 

Last edited by Alex (7/29/2015 10:51 am)