Hi David ,
I have a bit of a problem with google sitemap.
The sitemap all works fine apart from 3 retailers , all these retailers are the largest feeds and I think this is the problem, just not sure what to do to fix it.
any help would be great
thanks
Line:
2
Parsing error
We were unable to read your Sitemap. It may contain an entry we are unable to recognize. Please validate your Sitemap before resubmitting.
also warnings like below
Line:
2
Invalid XML tag
This tag was not recognized. Please fix it and resubmit.
cheers , all sorted now , no errors at all
great service as usual
Hi David,
I have a sitemap problem too - Google is rejecting a couple of merchants including 101cd.com and I know it has products - searches bring them up fine and the total shows in the Feeds Registration page.
I tried running the sitemap.php script for a single merchant and got the following :
<?xml version="1.0" encoding="UTF-8" ?>
- <urlset xmlns="http://www.google.com/schemas/sitemap/0.84" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd">
<br />
<b>Warning</b>
: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
<b>/home/xxxxxx/public_html/includes/database.php</b>
on line
<b>21</b>
<br />
<br />
<b>Warning</b>
: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
<b>/home/xxxxxx/public_html/includes/database.php</b>
on line
<b>26</b>
<br />
</urlset>As you can see it's giving a MySQL error instead of any products.
Can you suggest what might be causing this please?
While I'm here would it also be possible to email me my registration code again please as I lost it when my old laptop blew up and I can't download any new distributions.
Thanks
Jan
Hello Jan,
This is happening because of too many products in that merchant for the way the database query is performed. I will email you another version in a moment that solves this problem, along with your registration code...
Cheers,
David.
I've installed the new version but unfortunately I still get the same error for the 3 merchants with large feeds - 101cd.com, Woolworths and World Gallery. I've got a couple of other biggies like Argos which I haven't uploaded yet which I expect will fall over too. Is it an execution time type problem as it seems to stop almost as soon as it starts. Is there anything I can do to make it index all the products ?
Thanks.
Hello Jan,
I've sent you an email with some further debug code...
Cheers,
David.
Hi David
I am having a problem with one of my sites sitemaps. Googlehas this for errors
1 Parsing error
We were unable to read your Sitemap. It may contain an entry we are unable to recognize. Please validate your Sitemap before resubmitting. Found: Apr 26, 2008
- Leading whitespace
We've detected that your Sitemap file begins with whitespace. We've accepted the file, but you may want to remove the whitespace so that the file adheres to the XML standard. Found: Apr 26, 2008
Can you help me out?
Thanks Dean
Hi Dean,
Check for any white space in your config.php file outside of the PHP tags (make sure it starts with the "<" and ends with the ">" - that is the only place that might contain accidental new-lines or spaces that are being output before the XML begins.... That should be all it is...
Cheers,
David.
I don't see anything wrong with config.php I Resubmitted the site map and it still has the same errors
Thank You
Dean
Google will also find an error in the sitemap if you have a merchant with no products.
I found this out the hard way, couldn't figure out why there was a constant error - either unregister the feed, or import the products, and re-submit ...
Hi Dean,
Could you perhaps email me a link to your site so I can study the sitemap.php output and try to work out where the white space is coming from... (reply to your reg code or forum registration email is the easiest way to get me)
Note that the message implies that Google is still accepting your sitemap, so it is still working...
Cheers,
David.
Hi Jonny,
Can you email me a link to your main sitemap (sitemap.php), and let me know which merchant is generating the error - i'll take a look for you...
Cheers,
David.