| Author |
 Topic  |
|
corinaw
Starting Member
USA
22 Posts |
 Posted - 15 March 2006 : 20:11:52
|
Podge!
Thank you so much for your work on this. I'd been fussing with another asp db sitemap generator, and I should have known to come here first. . ;)
PROBLEMS WITH DUPLICATE CONTENT:
FYI to all my friends at snitz forums, you should not submit duplicate pages (all printer friendly + forum topics + hot topics)to google. Once they determine a page is duplicate, best case they will eventually deindex the pages THEY select as dup,. Worst case, the page/site will be penalized. Personally, I would much rather control which pages are included, or NOT on my site, rather than google making the decision which to throw out- I think it is much better to submit only the forum_topics, as all the navigation and forum info is displayed on these primary pages.
Perhaps some of you have both the printer friendly and forum topics in google now, but according to google quality guidelines the search engines themselves don't want to index 2 of the exact same thing, this makes sense, right? Why have 2 exact copies of the same thing?
Here's some info on dup pages just fyi
Google webmaster quality guidelines: http://www.google.com/webmasters/guidelines.html
Discussion on the Google duplicate content filter http://forums.digitalpoint.com/showthread.php?t=2213
And other good discussion http://www.webmasterworld.com/forum3/22494.htm
Because of this I have commented out the following sections of the code:
'xml = xml & "<url><loc>" & strForumURL & "pop_printer_friendly.asp?TOPIC_ID=" & Topic_ID & "</loc><lastmod>"& ISO8601Date(Topic_Last_Post) &"</lastmod><changefreq>daily</changefreq></url>"
'xml = xml & "<url><loc>" & strForumURL & "topic~TOPIC_ID~" & Topic_ID & ".asp</loc><lastmod>"& ISO8601Date(Topic_Last_Post) &"</lastmod><changefreq>daily</changefreq></url>"
The duplicate pages will honestly not help you and besides what I mention above, will totally suck bandwidth processing when it tries to pull every single iteration of your valuable forum content.
My 2 cents.
Snitz Rocks!
< |
 |
|
|
wildfiction
Junior Member
167 Posts |
Posted - 17 March 2006 : 17:45:22
|
corinaw has some good points there. I had already done that with sitemap code and should have posted it here with those same comments. But it's not to late to help others with another tip. Put a lot of the forum pages into the robots.txt file. For example, you don't want google indexing the post.asp page. This is what my robots.txt file looks like for the forum:
User-agent: *
Disallow: /*.mdb$
Disallow: /forum/policy.asp
Disallow: /forum/register.asp
Disallow: /forum/members.asp
Disallow: /forum/active.asp
Disallow: /forum/subscription_list.asp
Disallow: /forum/search.asp
Disallow: /forum/pop_profile.asp?mode=Edit
Disallow: /forum/pop_profile.asp
Disallow: /forum/faq.asp
Disallow: /forum/password.asp
Disallow: /forum/post.asp
That will also reduce the penalties that you receive from Google. Are there any others that people would recommend including in this list?< |
|
|
|
corinaw
Starting Member
USA
22 Posts |
Posted - 18 March 2006 : 00:35:01
|
Hi Wildfiction,
Yes you are right. There is much more to this than just sitemaps. I took the harder route and added nofollow to most of those links when I should have just nuked in robots.txt. This is why information sharing in a forum is so great. There is absoletely no reason why any se should try to index search.asp, password.asp, etc.
I considered not indexing policy.asp and faq.asp, but chose to leave it in. Why? Think in terms of trust.
Google supposedly has a list of factors they eval for "trustrank" or how trustworthy the site is. (This is NOT the same as page rank) Things like having a privacy policy, physical address, phone number and either an email name or contact us page have been discussed on the seo forums I basically live in. Of course I do not know exactly what they look at but having a faq and policy listed on a forum is a good thing (It's professional IMO), so if including this/allowing the se's to see I have these pages bumps up even one of my forum posts by 1 because my site "appears" more trustworth or professional I'm going to do it.
I don't know this for a fact, of course. But if you consider that se's look at 100's of factors in ranking your pages, this does make sense.
These are the other pages in the main sitemap code I disallowed. Active because it is dup. Members becasue you need to be logged in to view, (why index anyway) and then search as I mentioned before, no content on the page.
'xml = xml & "<url><loc>" & strForumURL & "active.asp</loc><lastmod>"& member8601Date(now(), 1) &"</lastmod><changefreq>daily</changefreq></url>"
'xml = xml & "<url><loc>" & strForumURL & "members.asp</loc><lastmod>"& member8601Date(now(), 1) &"</lastmod><changefreq>daily</changefreq></url>"
'xml = xml & "<url><loc>" & strForumURL & "search.asp</loc><lastmod>"& member8601Date(now(), 1) &"</lastmod><changefreq>daily</changefreq></url>"
Now I've got to run back to my site and do some disallowing!
< |
|
|
|
ispanyolcom
New Member
Mexico
78 Posts |
Posted - 27 March 2006 : 05:47:21
|
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '10 T.TOPIC_ID, T.T_LAST_POST FROM FORUM_TOPICS T, FORUM_FORUM
/evcilforum/sitemap.xml.asp, line 79
http://www.ispanyol.com/evcilforum/sitemap.xml.asp< |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
corinaw
Starting Member
USA
22 Posts |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 June 2006 : 11:52:00
|
Podge,
I have changed the file to work with MySQL. Would you want me to email it to you so that you can add it as an option?
Also, if I got this right, one needs to execute this regularly and resubmit to google once that update is done?
Thx.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
san_dady_cool
Starting Member
India
8 Posts |
Posted - 22 June 2006 : 15:10:18
|
quote:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'recActiveTopicsCount'
/sitemap.xml.asp, line 94
I had a huge list of topics on my forum, recently I deleted all the topic except important few, but now sitemap.xml.asp shows above error!
is this normal? please help thank you< |
http://www.downloadcandy.com |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
SnapperL
Starting Member
24 Posts |
Posted - 29 July 2006 : 20:52:23
|
hi, I tried to run this however I get the following error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.27-max-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '500 T.TOPIC_ID, T.T_LAST_POST FROM FORUM_TOPICS T, FORUM_FORUM
/forum/sitemap.xml.asp, line 79
could someone send me the mysql version?
< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - SnapperL on 29 July 2006 21:04:15 |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
SnapperL
Starting Member
24 Posts |
Posted - 01 August 2006 : 04:29:36
|
| Thanks Podge!< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Topic |
|
Google Sitemaps Mini-mod (Beta)
