WordPress database error: [Table 'wp_bas_refer' is marked as crashed and should be repaired]
SELECT referer_id FROM wp_bas_refer WHERE referer_string = '';

WordPress database error: [Duplicate entry '187469' for key 1]
INSERT INTO wp_bas_refer (referer_string) VALUES ('');

WordPress database error: [Table 'wp_bas_ua' is marked as crashed and should be repaired]
SELECT ua_id FROM wp_bas_ua WHERE ua_string = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)';

WordPress database error: [Duplicate entry '189021' for key 1]
INSERT INTO wp_bas_ua (ua_string) VALUES ('CCBot/1.0 (+http://www.commoncrawl.org/bot.html)');

WordPress database error: [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 ' 1568, , '2010-09-03 21:35:09')' at line 1]
INSERT INTO wp_bas_visitors (visit_ip, referer, osystem, useragent, lasthere) VALUES (644595568, , 1568, , '2010-09-03 21:35:09');

WordPress database error: [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 'AND referer = referer_id AND osystem = os_id AND useragent = ua_id' at line 1]
SELECT * FROM wp_bas_visitors, wp_bas_refer, wp_bas_ua, wp_bas_os WHERE visit_id = AND referer = referer_id AND osystem = os_id AND useragent = ua_id

WordPress database error: [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 ' '2010-09-03 21:35:09', 0, 10)' at line 1]
INSERT INTO wp_bas_log (visit, stamp, outbound, page) VALUES (, '2010-09-03 21:35:09', 0, 10);

The Importance of Google Sitemap: Quite an Eye Opener » SEO Bomb Blog

The Importance of Google Sitemap: Quite an Eye Opener

Filed Under: Articles, SEO

One of my clients, GettingLean.com, a fitness and health oriented website didn’t have a Google Sitemap, so we decided to implement this. I used SOFTplus GSiteCrawler to spider and automatically generate the sitemap.

For starters, upon spidering the site, we discovered problems with his 404 page. What happened was that the 404 page returned a 200 — a ok. This is not good, so before we could do anything else, this problem had to be adressed. We used some PHP magic and edited the 404 to actually return a 404 so that the search engines understands what to do.

With that problem out of the way, we continued uploading the sitemap.xml file to Google, validated it — and waited for the spiders to go amok on his site. Before we added the sitemap, he had about 2500 pages in the Google index. The day after submitting the sitemap, he had 12 500 pages indexed! I checked today, one week after we did this, and the indexed pages has now increased to 12 800. Now that’s what I call impressive.

I think many sites have the same problems, so I’m thinking about writing a tutorial on this. It’s really easy to make your own Google sitemap, and as you can see, it may have a huge impact on how many pages on your site gets indexed as well as your SERPs in general.

Sverre Sjøthun


Digg this entry! Delicious this!

1 Comment so far
Leave a comment

[…] Google […]

By SEO Tools and Resources Page » SEO Bomb Blog on 02.03.08 11:51 pm | Permalink


RSS feed for comments on this post.

TrackBack URI

Leave a comment
Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

(required)

(required)





Syndicate this site
Syndicate this site using RSS   Add this Feed to My Yahoo! Add this Feed to Bloglines!   Add this Feed to My MSN!    Add this Feed to Google Reader! Add this site to Delicious   Add this to Furl
Search SEO Bomb Blog


Recent SEO Bomb Blog posts

SEO Bomb på norsk - Søkemotoroptimalisering