WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Popular Posts
Using with Windows Azure/MSSQL (2 posts)

  1. rainmanjam
    Member
    Posted 2 years ago #

    I am getting a database error after using this implimentation of WordPress. http://azurephp.interoperabilitybridges.com/articles/how-to-deploy-wordpress-using-the-windows-azure-sdk-for-php-wordpress-scaffold

    `WordPress database error: [[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'wp_popularpostsdatacache'.]
    SELECT TOP 10 wp_posts.ID, wp_posts.post_title , (SUM(wp_popularpostsdatacache.pageviews)) AS 'pageviews' , wp_posts.comment_count AS 'comment_count' FROM wp_posts RIGHT JOIN wp_popularpostsdatacache ON wp_posts.ID = wp_popularpostsdatacache.id WHERE wp_posts.post_status LIKE 'publish' AND wp_posts.post_password LIKE '' AND wp_popularpostsdatacache.day = '2011-11-09' ORDER BY pageviews DESC

    Any siggestions?

    http://wordpress.org/extend/plugins/wordpress-popular-posts/

  2. Héctor Cabrera
    Member
    Plugin Author

    Posted 2 years ago #

    Hi rainmanjam,

    Can you please check that the tables wp_popularpostsdata and wp_popularpostsdatacache have been created in your database?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic