WordPress Popular Posts
[Plugin: WordPress Popular Posts] Using with Windows Azure/MSSQL (2 posts)

  1. rainmanjam
    Posted 4 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?


  2. Hector Cabrera
    Plugin Author

    Posted 4 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

  • WordPress Popular Posts
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic