Upgraded to 1.1.5.1 to no avail... this is killing me softly :-(

When Exported to XML

<error>
SELECT  UFrecordsXml.* from UFrecordsXml  where UFrecordsXml.form = '1c637294-c068-451f-a6aa-8fd09ef356b5' and UFrecordsXml.created &gt; @created order by UFrecordsXml.created DESC - System.Xml.XmlException: Name cannot begin with the '1' character, hexadecimal value 0x31. Line 1, position 9564.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
   at System.Xml.XmlTextReaderImpl.ParseQName(Boolean isQName, Int32 startOffset, Int32&amp; colonPos)
   at System.Xml.XmlTextReaderImpl.ParseElement()
   at System.Xml.XmlTextReaderImpl.ParseElementContent()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
   at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
   at System.Xml.XmlDocument.Load(XmlReader reader)
   at System.Xml.XmlDocument.LoadXml(String xml)
   at umbraco.xmlHelper.ImportXmlNodeFromText(String text, XmlDocument&amp; xmlDoc)
   at Umbraco.Forms.Data.Storage.RecordsViewer.XmlRecordReader(String sql, Form form, DateTime sinceDate, XmlDocument xd) in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Data\RecordStorage\RecordsViewer.cs:line 184
</error>

Hi Kevon,

Do you have a field that has the caption 1 ?

Would it be possible to export the form and provide me with the file that way I can try to reproduce your error and provide you with a fix/solution

Thanks,
Tim

Thanks for the reply Tim,

I'm not sure what you mean by "caption 1".  I exported the form and zipped it up, you should be able to find it here: http://www.rockfordil.gov/media/employment application.zip

Thanks again, and if you need my DB just say the word.

Ok thanks for the file, I'll try to reproduce the error and get back with more info

Hi Tim,

I have the exact same problem described above.

Please can ou help me out with Umbraco PRO urgently as I hav a client that needs the export for a show.

I've had a look at the DB rows and the setup of the form but I am unsure whether the reported error is due to the submitted data itself of the form (I think it is the latter as I belive the client was able to get some initial entries although I am not 100% on this).

The details of my error is included below.

Kind regards,
David

<error>SELECT  UFrecordsXml.* from UFrecordsXml  where UFrecordsXml.form = 'd58d3626-8d59-43d9-9d40-873adf38639a' and UFrecordsXml.created &gt; @created order by UFrecordsXml.created DESC - System.Xml.XmlException: Name cannot begin with the '9' character, hexadecimal value 0x39. Line 1, position 4571.

   at System.Xml.XmlTextReaderImpl.Throw(Exception e)

   at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)

   at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String[] args)

   at System.Xml.XmlTextReaderImpl.ParseQName(Boolean isQName, Int32 startOffset, Int32&amp; colonPos)

   at System.Xml.XmlTextReaderImpl.ParseElement()

   at System.Xml.XmlTextReaderImpl.ParseElementContent()

   at System.Xml.XmlTextReaderImpl.Read()

   at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)

   at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)

   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)

   at System.Xml.XmlDocument.Load(XmlReader reader)

   at System.Xml.XmlDocument.LoadXml(String xml)

   at umbraco.xmlHelper.ImportXmlNodeFromText(String text, XmlDocument&amp; xmlDoc)

   at Umbraco.Forms.Data.Storage.RecordsViewer.XmlRecordReader(String sql, Form form, DateTime sinceDate, XmlDocument xd) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.Core\Data\RecordStorage\RecordsViewer.cs:line 179</error>

Tim,

It's only been a year... just take another year to figure it out why don't you... I mean Contour is only a supported paid-for product, and how dare we attempt to use it for it's intended use.

;- )

Hey Kevon,

Did should have been fixed a couple of versions ago, did you try with the latest version of Contour (being 1.1.11 )? 

If you are still experiencing issues could you log it through your profile (contour support) that way it gets logged in our support system and it will make sure that it gets our attention.

Cheers,
Tim 

Ah okay - thanks Tim,

Can I safely upgrade over the top of the existing installation as the client has about 40 forms already in the system.

Thanks,
David :)

Tim,

Haven't tried new version but I will...  also thanks for being a good sport as I was just razzing you!  Glad to hear this was been addressed.

Hey David,

Well with an upgrade the xml has already been generated, and will only help new entries.

If you could send your db to tg at umbraco dot com I can take a look at recreating it (will be tomorrow if that's ok)

Hi Tim,

Thank you for coming backt o me again and sorry for the heat you've received from Kevon ;)

I am pretty proficient with SQL and XML and would ask if you are able to point me in the direction of manually identifying the offending data in forms table.  I have had a quick scan myself but without knowing what I'm lookign for (which I suspect may be a missing CDATA) it's like finding a needle in a haystack.

If not, then I can fire ou over the DB, no problem.

oh, also this particular site is only running version Umbraco 4.01 so I may not be able to upgrade to the latest version of Contour.  Can you please advise on compatability in this regard as this small error for a relatively old website may not justify the time/expence to perform a complete upgrade of all components.

Thanks again,
David :)

Hey David well I'll have to investigate it myself a bit so can't really point you in any direction at this point.

Indeed of you are running umbraco 4.0.1 you won't be able to upgrade to Contour 1.1.11 but 1.1.9 should also do the trick and should work with the older umbraco version

is working on a reply...