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 '-1' at line 1]

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp on wp_posts.ID = yarpp.ID WHERE 1=1 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ ) ORDER BY wp_posts.post_date DESC limit -1

I just installed WordPress SEO Pager Enhanced Pagination plugin and few minutes later i got those errors at the top of every posts and also RSS feed. It causes the other plugin (YARP) experiencing technical problems.
Apparently, the developer of YARP plugin has notified about this incompatibility on FAQ.
Continue reading…

written by Ryan Isra \\ tags: plugin, SEO, SQL, wordpress

Sitemap is a list of links in your website which accessible to users or crawlers. It also could be a planning tool to build webpage or web design that lists all accessible links and pages on a website.

Benefits of Sitemap

- Sitemap helps visitor find page or link on the site easier.
- Sitemap helps search engine bots (i.e. Google Bot, Yahoo Bot, MSN Bot) find pages&links and crawl entire website.
- Sitemap improve Search Engine Optimization (SEO)

Sitemap will be very useful for flash, javascript, or AJAX based website without HTML link, because search engine bot just recognize text.

Sitemap generator for WordPress is available. You can install Google XML Sitemaps plugin for wordpress.
I just installed this plugin for this blog. You can see Sitemap of this blog by visiting http://www.ryan-isra.net/sitemap.xml

You can read more about Sitemap on
- Wikipedia
- Google Webmaster Tools

written by Ryan Isra \\ tags: plugin, search engine, SEO, website, wordpress, www.ryan-isra.net