Failing to submit Forms with Images

good day guys

i seem to have a problem submitting forms with images to my local aggregate
server . I have a survey where there are questions asking you to take a
picture . If you you skip the picture the form sends successfully to the
server ,however when you have a picture the upload fails. I am using MY
SQL as my database but i can say previously when i was using PostgreSQL as
the database i did not have this problem i managed to send forms with
several images .

could this be related to MySQL or what i even tried to use ODK briefcase
to pull the completed form and sent it to the aggregate server but it still
fails .Below is the message i got when trying to use odk briefcase

Preparing for upload of form definition with 0 media attachments
Uploading form definition with no media attachments
UPLOAD FAILED: Form definition upload failed. Detailed error: Conflict
(409) while accessing: http://myservername:8080/him/formUpload
Please verify that the URL, your user credentials and your permissions are
all correct.
retrieving next chunk of instanceIds from server...
retrieving next chunk of instanceIds from server...
Preparing for upload of submission (1 of 1) with 2 media attachments
Uploading submission (1 of 1) and 2 media attachments
UPLOAD FAILED: Submission upload failed. Detailed error: Internal Server
Error (500) while accessing: http://myservername:8080/him/submission
Please verify that the URL, your user credentials and your permissions are
all correct.
Partially successful upload...

Sorry, forgot to add a big usage note about this to the release notes. See
http://code.google.com/p/opendatakit/wiki/AggregateReleaseNotes#MySQL_Usage_Note

This is an issue with MySQL configuration, and results from a coding change
made to ODK Aggregate in version 1.2 to use LONGBLOB.

I'll be changing this back to use BLOB in 1.2.1, to avoid having this
configuration problem with MySQL.

The immediate fix is to change the MySQL configuration per the usage note
above.

Mitch

ยทยทยท On Wed, Dec 5, 2012 at 5:10 AM, Mukanya wrote:

good day guys

i seem to have a problem submitting forms with images to my local
aggregate server . I have a survey where there are questions asking you to
take a picture . If you you skip the picture the form sends successfully to
the server ,however when you have a picture the upload fails. I am using
MY SQL as my database but i can say previously when i was using PostgreSQL
as the database i did not have this problem i managed to send forms with
several images .

could this be related to MySQL or what i even tried to use ODK briefcase
to pull the completed form and sent it to the aggregate server but it still
fails .Below is the message i got when trying to use odk briefcase

Preparing for upload of form definition with 0 media attachments
Uploading form definition with no media attachments
UPLOAD FAILED: Form definition upload failed. Detailed error: Conflict
(409) while accessing: http://myservername:8080/him/formUpload
Please verify that the URL, your user credentials and your permissions are
all correct.
retrieving next chunk of instanceIds from server...
retrieving next chunk of instanceIds from server...
Preparing for upload of submission (1 of 1) with 2 media attachments
Uploading submission (1 of 1) and 2 media attachments
UPLOAD FAILED: Submission upload failed. Detailed error: Internal Server
Error (500) while accessing: http://myservername:8080/him/submission
Please verify that the URL, your user credentials and your permissions are
all correct.
Partially successful upload...

--
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