Google sitemap generator errors

by **atrhick** » Fri Oct 14, 2011 2:06 pm

I wen to www.yourdomain/videositemap.php to generate my sitemap and everything went perfectly as expected. but after I submitted the site map Google only index 13 of my 700+ URLs please see image. if there a reason for this?

by **dargre** » Sat Oct 15, 2011 2:08 pm

You could search little bit for this thread:
video-sitemap-t204.html

I can be responsible for generator code,
but not for video script that doesn't care about duplicated titles and descriptions.

Unfortunately Google is as it is.
Youtube have millions duplicates and this doesn't affect indexing their videos, but if you or me have only 1 (ONE) duplicate - your sitemap is not valid anymore.

by **atrhick** » Mon Oct 17, 2011 2:33 pm

dargre wrote:You could search little bit for this thread:
video-sitemap-t204.html

I can be responsible for generator code,
but not for video script that doesn't care about duplicated titles and descriptions.

Unfortunately Google is as it is.
Youtube have millions duplicates and this doesn't affect indexing their videos, but if you or me have only 1 (ONE) duplicate - your sitemap is not valid anymore.

thank you. I think i can going to mod your script darger so if will check for duplications in the title and description as well and make it auto append a string of like "amazing!" as for the urls I can just tell it to delete that <url> </url> block.

what do you think?

by **atrhick** » Mon Oct 17, 2011 2:49 pm

Please keep in mind that i am new to PHP and MYSQL... what do you think about this Query?

Code: Select all: $sql_vids = "select * COUNT(title) AS titlenew FROM video WHERE type='public' GROUP BY title HAVING ( COUNT(title) > 1 )".$active." LIMIT 3000";

by **atrhick** » Mon Oct 17, 2011 3:44 pm

Woooooooot!! I fixed it lol, i know its a basic ugly fix but it works for now.. until I can fix it better

all i did was to make these changes.

Code: Select all: $map.="\t\t\t<video:title>".$title. " ". mt_rand(1, 99)."</video:title>\n"; $map.="\t\t\t<video:description>".$desc. " ". mt_rand(1, 99)."</video:description>\n";

by **nuevolab** » Mon Oct 17, 2011 11:45 pm

YEs, this makes title/description unique, however this is not natural and I am afraid that sooner or later google will find it and you can have bigger trouble then, including website deindexing from entire Google.

by **atrhick** » Tue Oct 18, 2011 12:09 am

nuevolab wrote:YEs, this makes title/description unique, however this is not natural and I am afraid that sooner or later google will find it and you can have bigger trouble then, including website deindexing from entire Google.

thats a very good point... is there a way to tell the script not not include the dups?

by **dargre** » Tue Oct 18, 2011 2:03 pm

It should be checked at the moment when user uploads video and enter details like title/description.
Script should check if same title/desc already exists and if so - output error instead of proceeding with upload.
For already uploaded videos - there is no other way as only edit/correct dupilcated entries manually.
In webmaster tools and sitemap details you can see which videos are duplicated.

Google sitemap generator errors

Google sitemap generator errors

Re: Google sitemap generator errors

Re: Google sitemap generator errors

Re: Google sitemap generator errors

Re: Google sitemap generator errors

Re: Google sitemap generator errors

Re: Google sitemap generator errors

Re: Google sitemap generator errors

Who is online