New server, new problem

Hello. We are building out a Debian Linux cluster to host our data and all
seems well. Tomcat runs the Aggregate website. I can load XML files and
they are created in the MySQL server. And I can see the files on the ODK
Collect phone app. But, when I download them I get:

Download Result

··· ---------------------------- - failed to insert row into content://org.odk.collect.android.provider.odk.forms/forms

I tried 2 separate phones - both of which work using the old server.

Thanks!

Are you using ODK Collect 1.1.7 or 1.2 ?
What version of ODK Aggregate are you using?
And does your form have a version attribute, or just a form id?

Mitch

··· On Thu, Jun 7, 2012 at 1:45 PM, Alex Pavluck wrote:

Hello. We are building out a Debian Linux cluster to host our data and
all seems well. Tomcat runs the Aggregate website. I can load XML files
and they are created in the MySQL server. And I can see the files on the
ODK Collect phone app. But, when I download them I get:

Download Result

- failed to insert row into
content://org.odk.collect.android.provider.odk.forms/forms

I tried 2 separate phones - both of which work using the old server.

Thanks!

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Either you omitted a form id in your form definition (
http://opendatakit.org/help/form-design/ ) or you are running 1.1.7 on an
Android 2.x phone and have large forms.

You can mount your phone then delete /odk/metadata/forms.db

And then go to Fill in Form, wait for the "...All forms loaded." to appear
(do not exit and re-enter this screen). And things should be working again.

ODK Collect 1.2 fixes this issue (but cannot correct it).

Mitch

··· On Mon, Jun 25, 2012 at 3:34 PM, wrote:

On Thursday, June 7, 2012 1:45:21 PM UTC-7, Alex Pavluck wrote:

Hello. We are building out a Debian Linux cluster to host our data and
all seems well. Tomcat runs the Aggregate website. I can load XML files
and they are created in the MySQL server. And I can see the files on the
ODK Collect phone app. But, when I download them I get:

Download Result ---------------------------- <survey name> - failed to insert row into

content://org.odk.collect.android.provider.odk.forms/forms

I tried 2 separate phones - both of which work using the old

server.

Thanks!

I'm coming up with the same issue myself today. Has there been any
resolution on how to fix this problem?

Thanks,

Mike

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

I have to take the file from the build site and fix the header info before posting the file or it won't work on the phone. If you need the syntax let me know.

Best,

··· On Monday, June 25, 2012 at 6:34 PM, michael.stevens.miis@gmail.com wrote:

On Thursday, June 7, 2012 1:45:21 PM UTC-7, Alex Pavluck wrote:

Hello. We are building out a Debian Linux cluster to host our data and all seems well. Tomcat runs the Aggregate website. I can load XML files and they are created in the MySQL server. And I can see the files on the ODK Collect phone app. But, when I download them I get:

Download Result ---------------------------- <survey name> - failed to insert row into content://org.odk.collect.android.provider.odk.forms/forms I tried 2 separate phones - both of which work using the old server. Thanks!

I'm coming up with the same issue myself today. Has there been any resolution on how to fix this problem?

Thanks,

Mike

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

Thanks Alex - that worked a treat....

ODK Collect 1.1.7 and ODK Aggregate v1.1.0 linux

Let me know if there is anything else that could make this easier to
troubleshoot.

··· On Thursday, June 7, 2012 5:47:44 PM UTC-4, Mitch wrote: > > Are you using ODK Collect 1.1.7 or 1.2 ? > What version of ODK Aggregate are you using? > And does your form have a version attribute, or just a form id? > > Mitch > > On Thu, Jun 7, 2012 at 1:45 PM, Alex Pavluck wrote: > >> Hello. We are building out a Debian Linux cluster to host our data and >> all seems well. Tomcat runs the Aggregate website. I can load XML files >> and they are created in the MySQL server. And I can see the files on the >> ODK Collect phone app. But, when I download them I get: >> >> Download Result >> ---------------------------- >> - failed to insert row into >> content://org.odk.collect.android.provider.odk.forms/forms >> >> I tried 2 separate phones - both of which work using the old server. >> >> Thanks! >> >> -- >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitchellsundt@gmail.com >

I am also experiencing the same issue. All my working forms are now not
able to be seen on the phone. Am using Aggregate 1.1.0 on Linux and Collect
1.1.7

Mitch - I deleted the forms.db file, but that didn't solve the problem.

Alex - what is the syntax you are using to solve this.

··· On Tuesday, 26 June 2012 03:02:21 UTC+2, Alex Pavluck wrote: > > I have to take the file from the build site and fix the header info > before posting the file or it won't work on the phone. If you need the > syntax let me know. > > Best, >

Could you send me the forms.db from the phone?
/sdcard/odk/metadata/forms.db

This is a SQLite database of the directory info about the forms on the
phone and it doesn't have any personal info.

Send it directly to me ( mitchellsundt@gmail.com ).

Mitch

··· On Thu, Jun 7, 2012 at 4:22 PM, Alex Pavluck wrote:

ODK Collect 1.1.7 and ODK Aggregate v1.1.0 linux

Let me know if there is anything else that could make this easier to
troubleshoot.

On Thursday, June 7, 2012 5:47:44 PM UTC-4, Mitch wrote:

Are you using ODK Collect 1.1.7 or 1.2 ?
What version of ODK Aggregate are you using?
And does your form have a version attribute, or just a form id?

Mitch

On Thu, Jun 7, 2012 at 1:45 PM, Alex Pavluck apavluck@taskforce.orgwrote:

Hello. We are building out a Debian Linux cluster to host our data and
all seems well. Tomcat runs the Aggregate website. I can load XML files
and they are created in the MySQL server. And I can see the files on the
ODK Collect phone app. But, when I download them I get:

Download Result

- failed to insert row into content://org.odk.collect.**
android.provider.odk.forms/**forms

I tried 2 separate phones - both of which work using the old server.

Thanks!

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@**googlegroups.comopendatakit%2Bunsubscribe@googlegroups.com
Options: http://groups.google.com/**group/opendatakit?hl=enhttp://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

In your form, before adding it to Aggregate, put this in the top of the
survey code.

<?xml version="1.0"?>

<h:html xmlns="http://www.w3.org/2002/xforms"

    xmlns:h="http://www.w3.org/1999/xhtml"

    xmlns:ev="http://www.w3.org/2001/xml-events"

    xmlns:xsd="http://www.w3.org/2001/XMLSchema"

    xmlns:jr="http://openrosa.org/javarosa">

<h:head>

There will already be the final head tag so just overwrite it with this.

··· On Tue, Jun 26, 2012 at 9:24 AM, dj_bridges wrote:

I am also experiencing the same issue. All my working forms are now not
able to be seen on the phone. Am using Aggregate 1.1.0 on Linux and Collect
1.1.7

Mitch - I deleted the forms.db file, but that didn't solve the problem.

Alex - what is the syntax you are using to solve this.

On Tuesday, 26 June 2012 03:02:21 UTC+2, Alex Pavluck wrote:

I have to take the file from the build site and fix the header info
before posting the file or it won't work on the phone. If you need the
syntax let me know.

Best,

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en