XML database import errors

[Omniferum]

I think i've identified what stuffed up my Ketamon .db before.

 

After checking some of my .xml backups (I keep a regular backup of both the .db and .xml) and for no reason I can see I have inconsistent formatting. The only thing i've done is just run ketarin with the backup to xml command, haven't edited any of it. All my apps are functioning perfectly fine whilst running Ketarin as far as I know right now.

 

I'm just posting bits, it seems to be square brackets being placed inconsistently. Whilst it may not really matter where the square brackets are if they pop up in random numbers in quasi-random locations in the xml it may cause an issue.

 

Examples

 

 <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Guid="f2662531-f64d-441a-921d-2c76258b0fc1">
   <SourceTemplate><![CDATA[<?xml version="1.0" encoding="utf-8"?>
<Jobs>
 <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <SourceTemplate><![CDATA[]]]]><![CDATA[></SourceTemplate>
   <WebsiteUrl><placeholder name="URL" value="http://www.psp-hacks.com/" /></WebsiteUrl>
   <LastFileDate xsi:nil="true" />
   <IgnoreFileInformation>true</IgnoreFileInformation>
   <DownloadBeta>Default</DownloadBeta>
   <DownloadDate xsi:nil="true" />
   <CheckForUpdatesOnly>false</CheckForUpdatesOnly>
   <VariableChangeIndicator>monitor</VariableChangeIndicator>
   <CanBeShared>true</CanBeShared>
   <ShareApplication>false</ShareApplication>
   <ExclusiveDownload>false</ExclusiveDownload>
   <HttpReferer />
   <SetupInstructions />
   <Variables>
     <item>
       <key>
         <string>monitor</string>
       </key>
       <value>
         <UrlVariable>
           <RegexRightToLeft>false</RegexRightToLeft>
           <VariableType>RegularExpression</VariableType>
           <Regex>.*</Regex>
           <Url><placeholder name="URL" value="http://www.psp-hacks.com/" /></Url>
           <Name>monitor</Name>
         </UrlVariable>
       </value>
     </item>
      <item>
       <key>
         <string>name</string>
       </key>
       <value>
         <UrlVariable>
           <RegexRightToLeft>false</RegexRightToLeft>
           <VariableType>RegularExpression</VariableType>
           <Regex><title>.*?(\S.*?)\s*</title></Regex>
           <Url><placeholder name="URL" value="http://www.psp-hacks.com/" /></Url>
           <Name>name</Name>
         </UrlVariable>
       </value>
     </item>
   </Variables>
   <ExecuteCommand />
   <ExecutePreCommand>start {property:WebsiteUrl} & exit 2</ExecutePreCommand>
   <ExecuteCommandType>Batch</ExecuteCommandType>
   <ExecutePreCommandType>Batch</ExecutePreCommandType>
   <Category>Web Page Monitoring</Category>
   <SourceType>FixedUrl</SourceType>
   <PreviousLocation />
   <DeletePreviousFile>true</DeletePreviousFile>
   <Enabled>true</Enabled>
   <FileHippoId />
   <LastUpdated xsi:nil="true" />
   <TargetPath>Web Page Monitoring\{appname:regexreplace:([^a-zA-Z0-9\_]+):-}</TargetPath>
   <FixedDownloadUrl>https://www.google.com/images/logos/mail_logo.png</FixedDownloadUrl>
   <Name><placeholder name="Name of application" variable="name" value="PSP Hacks · PSP Go Hacks · PSP Homebrew, PSP Downloads, PSP Custom Firmware" /></Name>
 </ApplicationJob>
</Jobs>]]>

 

   <SourceTemplate><![CDATA[<?xml version="1.0" encoding="utf-8"?>
<Jobs>
 <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <SourceTemplate><![CDATA[]]]]></SourceTemplate>

 

   <SourceTemplate><![CDATA[<?xml version="1.0" encoding="utf-8"?>

 

This may be what led to my apps becoming bogged down. My question then is there something wrong with my templates that could cause this odd formatting in the exported .xml?

[floele]

I don't see any problem with the brackets here, can you enlighten me?

[Omniferum]

Each of those snippets are from different applications, the start of them.

 

the first one starts square brackets at top with CDATA and apparently doesn't give appropriate closing brackets until the end of the job

 

The second one lists sourcetemplate twice

 

another example

 

 <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Guid="190a48eb-e1dd-4112-821d-f49a8d1e4b96">
   <SourceTemplate><![CDATA[<?xml version="1.0" encoding="utf-8"?>
<Jobs>
 <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <SourceTemplate><![CDATA[]]]]></SourceTemplate>
   <WebsiteUrl />

 

There just seems to be a random number of []][]][][] for each application and duplicates of source templates for some apps.

 

Another example, this is the top and bottom of the same app.

 

 <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Guid="bb5072e2-c81e-4820-9f65-36a5eeb8e71c">
   <SourceTemplate><![CDATA[<?xml version="1.0" encoding="utf-8"?>

 

 </ApplicationJob>
</Jobs>]]></SourceTemplate>

 

A 'healthy' looking xml for an app looks like this to me.

 

 <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Guid="7a4a32cf-2d8e-43a4-accb-b3c834b487f1">
   <SourceTemplate><![CDATA[]]></SourceTemplate>

[shawn]

It's definitely an XML issue. CDATA blocks cannot contain "]]>" (nesting is forbidden). That string should be entity encoded to ensure that it's properly exported.

[Tomorrow]

I think my issue has the same root cause: http://ketarin.canneverbe.com/forum/viewtopic.php?id=647

I just checked and i too have inconsistent formatting regarding the brackets.Also the XML declaration appears in the middle of and app job several times like shown in the picture.

 

+ the mentioned

<![CDATA[<

instead of

<![CDATA[][><

[floele]

I could not yet reproduce the issue though, I'd appreciate any hints

[floele]

I believe that I found a possible cause of that issue now, will fix it in the next beta.