TAGs problem

today i checked Google webmaster pages and i noticed that it shows warning (URLs not accessibl) . i checked the links and all are Tags ( 4 links ) . when i clicked on links i got this error :

Invalid Tag specified. If you followed a valid link, please notify the admin...

i logged in and i could see !!! this is first problem

And second is that in 2 of those links (logged in or not) i got the same error . tried to add the tags and i get TAGS is already exists ! searched in tags page , couldnt find it too !!

Any idea ??

-------------

this is the Exact post that i posted in Vb.com (here) and a user replied that vbseo is the reason that he fixed it by ... ( Read more )

So i'm wondering is it the best available Solution ?

Thanks

Did you delete those tags? What are the URLs that are pointing the them?

No, i havent . today i goes to copy and paste the links here and i saw that links are changed !!!! when u are guest and u check those urls u can get the Error message but when u are logging into the website there is no error !!

here is NEW links > 1 - 2

Google Message :

URLs not accessible
When we tested a sample of the URLs from your Sitemap, we found that some URLs were not accessible to Googlebot due to an HTTP status error. All accessible URLs will still be submitted

HTTP Error: 404 (Not found)

The threads in which those tags are in, are they in a public accessible forum? Or are they a private forum? That might be the reason you are getting that error.

yea . those forums are private ! but why they are indexed in the Sitemaps ?!

and why google shows HTTP Error: 404 (Not found) ?

Hello,

try to modify vbseo_sitemap_functions.php file:
FIND:

PHP Code:

             $tcount = $db->query_first("
                 SELECT count(*)as cnt,max(dateline) as lastupdate
                 FROM " . TABLE_PREFIX . "tagthread
                 WHERE tagid='$rrow[tagid]'
             "); 


REPLACE WITH:

PHP Code:

             $tcount = $db->query_first("
                   SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
                   FROM " . TABLE_PREFIX . "thread AS thread
                   INNER JOIN " . TABLE_PREFIX . "tagthread AS tagthread ON
                       (tagthread.tagid = $rrow[tagid] AND tagthread.threadid = thread.threadid)
                   WHERE thread.forumid IN(" . implode(', ', $vbseo_vars['forumslist']) . ")
                       AND thread.visible = 1
                       AND thread.sticky IN (0, 1)
                       AND thread.open <> 10
                   GROUP BY tagthread.tagid
             ");
             if(!$tcount['cnt'])
                 continue; 


and regenerate sitemap.

i did that change , ran the sitemap and i got this database error :

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT COUNT(*) as cnt,max(dateline) as lastupdate
FROM thread AS thread
INNER JOIN tagthread AS tagthread ON
(tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)
WHERE thread.forumid IN(1, 3, 8, 9, 123, 72, 128, 124, 64, 65, 85, 86, 87, 88, 90, 91, 89, 92, 81, 52, 39, 69, 70, 137, 11, 12, 33, 28, 29, 31, 32, 27, 16, 76, 13, 14, 131, 105, 108, 107, 111, 109, 15, 110, 96, 37, 26, 35, 36, 122, 101, 77, 10, 18, 23, 24, 25, 68, 21, 136, 112, 71, 126, 78, 19, 38, 73, 53, 79, 20, 62, 63, 66, 42, 93, 43, 48, 49, 44, 50, 51, 47, 54, 55, 95, 102, 56, 57, 132, 80, 58, 115, 116, 117, 118, 119, 121, 125, 127, 129, 130, 133, 134, 135, 103, 113, 60, 22, 59, 104, 67)
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10;

MySQL Error : Column 'dateline' in field list is ambiguous
Error Number : 1052

Also i have problem with pinging the search engines too ! 20 days no PING !

Try to replace "dateline" with "lastpost" in the query.

now i get this :

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 36751806 bytes) in /home/public_html/forum/vbseo_sitemap/vbseo_sitemap_functions.php on line 1307

Please check this: High memory usage
Note: I've updated the post above with correct code replacement: TAGs problem

It seems that problem resolved .

i just resubmit my sitemaps in google . and i will update this thread about the Result .

thanks for great support .

Great! Let us know if you have any issues.

unfortunately Still googles shows the Same warning that i had before !

Are there *new* URLs reported? What is the date of request displayed in "Last Calculated" column in google webmaster account?

yeah they are new .

Last Downloaded : 11 hours ago

i have Resubmit them all Again after that i made those changes in the file and setting!