Error type: LoadXML Description: Incorrect XML

NatTack · **Joined:** Thu Jun 25, 2009 6:58 am **Posts:** 50

I receive the following error when adding a coupon.

Error type: LoadXML
Description: Incorrect XML

This happens when I try to either assign Valid Categories or Valid Products to that coupon. The pop-up window open which usually has products or categories to pick from.

aitsglobal · **Joined:** Thu Feb 28, 2008 9:09 pm **Posts:** 53

in admin/get_categories.php you will see a function

Code:

  function str_rep($row){
    $row = str_replace('&amp;', '&', $row);
    $row = str_replace('&', '&amp;', $row);
    $row = str_replace('>', '&gt;', $row);
    $row = str_replace('<', '&lt;', $row);
//ADD THIS FIX
    $row = str_replace('"', ' ', $row);
//ADD THIS FIX
    return $row;

You might be using " or ' in the title of the Categories or Products either remove them from the titles or clean them. Hope this will solve your problem.

NatTack · **Joined:** Thu Jun 25, 2009 6:58 am **Posts:** 50

Thanks
I checked my code and compared to the code you sent

//ADD THIS FIX
$row = str_replace('"', ' ', $row);
//ADD THIS FIX
return $row;

It was missing the two fixes so I added it and it fixed the problem.

Thanks again

aitsglobal · **Joined:** Thu Feb 28, 2008 9:09 pm **Posts:** 53

NatTack · **Joined:** Thu Jun 25, 2009 6:58 am **Posts:** 50

Darn I spoke too soon, it is still broken I was looking at the wrong page.

Any additional help?

aitsglobal · **Joined:** Thu Feb 28, 2008 9:09 pm **Posts:** 53

post the error you are getting.

NatTack · **Joined:** Thu Jun 25, 2009 6:58 am **Posts:** 50

Error type: LoadXML
Description: Incorrect XML

This happens when I try to either assign Valid Categories or Valid Products to a new coupon. The pop-up window open which usually has products or categories to pick from.

aitsglobal · **Joined:** Thu Feb 28, 2008 9:09 pm **Posts:** 53

Please check your categories and products titles there must be some special character causing problem. You can also call out the script directly which will provide with pure xml output you can zip and send it I might be able to help you.

http://yourdomain.com/admin/get_categories.php

NatTack · **Joined:** Thu Jun 25, 2009 6:58 am **Posts:** 50

I get the following error when I run /admin/get_categories.php

XML Parsing Error: not well-formed
Location: /admin/get_categories.php
Line Number 555, Column 26:<item text="4" Wakemaker (Natural Pearl Red Throat)" id="p_100235" im0="leaf.gif" im1="leaf.gif" im2="leaf.gif"></item>
-------------------------^

NatTack · **Joined:** Thu Jun 25, 2009 6:58 am **Posts:** 50

Well it seems there are hundreds if not thousands of products the have a quote " in them to show inch. I guess i need to edit them.

TheLango · **Joined:** Sun Nov 29, 2009 10:57 am **Posts:** 348

You can try this, rather than renaming all your products..

In get_categories.php, look for the function str_rep($row){
, rename it to function str_rep1($row){

Paste the following code just above this function.

Code:

function str_rep($row, $quote_style = ENT_QUOTES, $charset = 'UTF-8')
{
    if (is_array($row)) {
        foreach($row as $key => $value) {
            $row[$key] = htmlspecialchars_deep($value, $quote_style, $charset);
        }
    } elseif (is_string($row)) {
        $row = htmlspecialchars(htmlspecialchars_decode($row, $quote_style), $quote_style, $charset);
    }
    return $row;
}

so you end up with :

Code:

function str_rep($row, $quote_style = ENT_QUOTES, $charset = 'UTF-8')
{
    if (is_array($row)) {
        foreach($row as $key => $value) {
            $row[$key] = htmlspecialchars_deep($value, $quote_style, $charset);
        }
    } elseif (is_string($row)) {
        $row = htmlspecialchars(htmlspecialchars_decode($row, $quote_style), $quote_style, $charset);
    }
    return $row;
} 
  function str_rep1($row){
    $row = str_replace('&amp;', '&', $row);
    $row = str_replace('&', '&amp;', $row);
    $row = str_replace('>', '&gt;', $row);
    $row = str_replace('<', '&lt;', $row);
    return $row;
  }

This will allow the XML to complete, on removing the WHOLE product name where there is a special character it cant replace.

eg.. Product name = Penne á Candela Pasta from Naples 500g returns an empty product name because of the á
So, I ran the get_categories.php, with the replacement function str_rep, went through it, noting all products without a product name, just id.
eg..<item text="" id="p_6102" im0="leaf.gif" im1="leaf.gif" im2="leaf.gif"/>
then looked to find the offending character, replacing it using the following function, as I believe, the only replacement that takes place using the original function, is the last one in the order, so I ended up with the following.

Code:

function str_rep1($row, $quote_style = ENT_QUOTES, $charset = 'UTF-8')
{
    if (is_array($row)) {
        foreach($row as $key => $value) {
            $row[$key] = htmlspecialchars_deep($value, $quote_style, $charset);
        }
    } elseif (is_string($row)) {
        $row = htmlspecialchars(htmlspecialchars_decode($row, $quote_style), $quote_style, $charset);
    }
    return $row;
} 
  function str_rep($row){

$spec_cs = array('ú', 'î', 'á', 'é', '£'); // These are the only Special Characters I needed to replace!!
$specialarray=array('&#250;', '&#237;', '&#225;', '&#233;', '&#163;');
$row1 = str_replace($spec_cs, $specialarray, $row);

    $row = str_rep1($row1);
    return $row;

Hope this helps..

aitsglobal · **Joined:** Thu Feb 28, 2008 9:09 pm **Posts:** 53

This works most of the time try it

line no 10 replace the encoding to utf16

Code:

echo '<?xml version="1.0" encoding="UTF-16"?>' . "\n";

replace the function:

Code:

  function str_rep($row){
    $row = str_replace('&amp;', '&', $row);
    $row = str_replace('&', '&amp;', $row);
    $row = str_replace('>', '&gt;', $row);
    $row = str_replace('<', '&lt;', $row);
   $row = str_replace('"', '&quot;', $row);
   $row = str_replace("'", " ", $row);
   $row = str_replace("/", " ", $row);
   $row = str_replace("£", "&#0163", $row);
    return $row;
  }

NatTack · **Joined:** Thu Jun 25, 2009 6:58 am **Posts:** 50

TheLango wrote:

You can try this, rather than renaming all your products..

In get_categories.php, look for the function str_rep($row){
, rename it to function str_rep1($row){

Paste the following code just above this function.

Code:

function str_rep($row, $quote_style = ENT_QUOTES, $charset = 'UTF-8')
{
    if (is_array($row)) {
        foreach($row as $key => $value) {
            $row[$key] = htmlspecialchars_deep($value, $quote_style, $charset);
        }
    } elseif (is_string($row)) {
        $row = htmlspecialchars(htmlspecialchars_decode($row, $quote_style), $quote_style, $charset);
    }
    return $row;
}

so you end up with :

Code:

function str_rep($row, $quote_style = ENT_QUOTES, $charset = 'UTF-8')
{
    if (is_array($row)) {
        foreach($row as $key => $value) {
            $row[$key] = htmlspecialchars_deep($value, $quote_style, $charset);
        }
    } elseif (is_string($row)) {
        $row = htmlspecialchars(htmlspecialchars_decode($row, $quote_style), $quote_style, $charset);
    }
    return $row;
} 
  function str_rep1($row){
    $row = str_replace('&amp;', '&', $row);
    $row = str_replace('&', '&amp;', $row);
    $row = str_replace('>', '&gt;', $row);
    $row = str_replace('<', '&lt;', $row);
    return $row;
  }

This will allow the XML to complete, on removing the WHOLE product name where there is a special character it cant replace.

eg.. Product name = Penne á Candela Pasta from Naples 500g returns an empty product name because of the á
So, I ran the get_categories.php, with the replacement function str_rep, went through it, noting all products without a product name, just id.
eg..<item text="" id="p_6102" im0="leaf.gif" im1="leaf.gif" im2="leaf.gif"/>
then looked to find the offending character, replacing it using the following function, as I believe, the only replacement that takes place using the original function, is the last one in the order, so I ended up with the following.

Code:

function str_rep1($row, $quote_style = ENT_QUOTES, $charset = 'UTF-8')
{
    if (is_array($row)) {
        foreach($row as $key => $value) {
            $row[$key] = htmlspecialchars_deep($value, $quote_style, $charset);
        }
    } elseif (is_string($row)) {
        $row = htmlspecialchars(htmlspecialchars_decode($row, $quote_style), $quote_style, $charset);
    }
    return $row;
} 
  function str_rep($row){

$spec_cs = array('ú', 'î', 'á', 'é', '£'); // These are the only Special Characters I needed to replace!!
$specialarray=array('&#250;', '&#237;', '&#225;', '&#233;', '&#163;');
$row1 = str_replace($spec_cs, $specialarray, $row);

    $row = str_rep1($row1);
    return $row;

Hope this helps..

Thanks, I followed the above instructions and it works fine. I did try your last suggestion replacing the function, but all I get is a blank page. Thanks for the help.

TheLango · **Joined:** Sun Nov 29, 2009 10:57 am **Posts:** 348

NatTack wrote:

Thanks, I followed the above instructions and it works fine. I did try your last suggestion replacing the function, but all I get is a blank page. Thanks for the help.

Apologies, I missed the bottom of the code off.. should have read..

Code:

function str_rep1($row, $quote_style = ENT_QUOTES, $charset = 'UTF-8')
{
    if (is_array($row)) {
        foreach($row as $key => $value) {
            $row[$key] = htmlspecialchars_deep($value, $quote_style, $charset);
        }
    } elseif (is_string($row)) {
        $row = htmlspecialchars(htmlspecialchars_decode($row, $quote_style), $quote_style, $charset);
    }
    return $row;
} 
  function str_rep($row){

$vowels = array('ú', 'í', 'á', 'é', '£');
$myarray=array('&#250;', '&#237;', '&#225;', '&#233;', '&#163;');
$row1 = str_replace($vowels, $myarray, $row);


    $row = str_rep1($row1);


    return $row;
  }

soundzgood2 · **Posted:** Thu Mar 25, 2010 6:07 am

That's great - thanks TL (another error fixed!)
Simon

TheLango wrote:

NatTack wrote:

Thanks, I followed the above instructions and it works fine. I did try your last suggestion replacing the function, but all I get is a blank page. Thanks for the help.

Apologies, I missed the bottom of the code off.. should have read..

Code:

function str_rep1($row, $quote_style = ENT_QUOTES, $charset = 'UTF-8')
{
    if (is_array($row)) {
        foreach($row as $key => $value) {
            $row[$key] = htmlspecialchars_deep($value, $quote_style, $charset);
        }
    } elseif (is_string($row)) {
        $row = htmlspecialchars(htmlspecialchars_decode($row, $quote_style), $quote_style, $charset);
    }
    return $row;
} 
  function str_rep($row){

$vowels = array('ú', 'í', 'á', 'é', '£');
$myarray=array('&#250;', '&#237;', '&#225;', '&#233;', '&#163;');
$row1 = str_replace($vowels, $myarray, $row);


    $row = str_rep1($row1);


    return $row;
  }

CRE Loaded Community

Error type: LoadXML Description: Incorrect XML

Who is online

Main Menu

Login

Top Listing

Members Online

Follow Us on Twitter

CRE Loaded Community Chat hosted by CRE Loaded.