Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by David on Oct 31, 2008 04:45
open dhtmlx forum
Incorrect XML

Hi,
I'm showing some registers with a grid, not more than 30. But sudently It begins giving the message "Incorrect XML" when loading. The only way I found to solve it is to delete all registers. When I insert new registers it works fine untill one day It begins to fail again.
Does anybody know why is it happening or which tests I can do to find the problem.
Thanks in advance
Answer posted by Support on Oct 31, 2008 07:39
The problem may be caused by some special chars , which breaks XML syntax , or stored in different encoding than XML. 
The most simple way to check reason of the problem - point browser to the same URL, which used for loadXML command - it will show exact reason of XML parsing error. 
Answer posted by David on Oct 31, 2008 07:47
I also thought about this cause and I deleted the registers with "strange" characters and it did not work. Is there a list of "forbiden" characters that could cause it?.
It could be the reason because there is a field of comments in the reagisters.
Lots of thanks.
Answer posted by Support on Oct 31, 2008 08:37
Please check attached document
Attachments (1)
Answer posted by David on Oct 31, 2008 09:15
Thanks,
The characters that cause the error are the next ones:

',´,ñ,Ç,·,¿,¨


Answer posted by David on Oct 31, 2008 09:28
Hi,
Do you think that if I change the xml header I could solve the problem?.
My database is "latin1_spanish_ci".
How could I change this header?
Thanks
Answer posted by Support on Oct 31, 2008 09:53
Most probably, the next XML header must be correct
   <?xml version="1.0" encoding="iso-8859-1" ?>
If it still cause errors, please attach a sample of problematic xml as separate file to this post.