Title: Using in SQL/WINDOWS AZURE Last modified: August 21, 2016 --- # Using in SQL/WINDOWS AZURE * Resolved [Zied Ellouze](https://wordpress.org/support/users/zied86/) * (@zied86) * [12 years ago](https://wordpress.org/support/topic/wordpress-popular-posts-using-in-sqlwindows-azure/) * Hi, I Have a site hosted in windows azure when in activate the plugin, I have this error * The plugin generated 1116 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin. * and the tables wp_popularpostsdata and wp_popularpostsdatacache don’t have create * Any siggestions? * [https://wordpress.org/plugins/wordpress-popular-posts/](https://wordpress.org/plugins/wordpress-popular-posts/) Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Author [Hector Cabrera](https://wordpress.org/support/users/hcabrera/) * (@hcabrera) * [12 years ago](https://wordpress.org/support/topic/wordpress-popular-posts-using-in-sqlwindows-azure/#post-4940276) * Hi Ellouze, * I’m not familiar with Windows Azure, unfortunately. If the plugin was unable to create the tables, there are a few things that could have gone wrong: - Your hosting account doesn’t have enough permissions to create/edit tables on the database. Check with your host. - One or more required PHP modules are not enabled on the server, which might be causing the issues. Check with your host. - An unknown error. * In any case, I would need to see the error log to determine what the problem is. Maybe your host can provide it to you (or you can [follow these instructions](http://codex.wordpress.org/Debugging_in_WordPress#Example_wp-config.php_for_Debugging) to get it by yourself). * Thread Starter [Zied Ellouze](https://wordpress.org/support/users/zied86/) * (@zied86) * [12 years ago](https://wordpress.org/support/topic/wordpress-popular-posts-using-in-sqlwindows-azure/#post-4940278) * Hi Héctor Thank you here is the log of serveur: CREATE TABLE wp_popularpostsdata( CONSTRAINT [wp_popularpostsdata_postid] UNIQUE NONCLUSTERED (postid) );|~|a:0:{} |~|a:3:{i:0;s:5:”42000″;i:1;i:102;i:2;s:80:”[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ‘)’.”;} CREATE TABLE wp_popularpostsdatacache( CONSTRAINT [wp_popularpostsdatacache_id_ day_no_time] UNIQUE NONCLUSTERED (id, day_no_time) );|~|a:0:{}|~|a:3:{i:0;s:5:”42000″;i:1;i:102;i:2;s:80:”[Microsoft][ SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ‘)’.”;} * Plugin Author [Hector Cabrera](https://wordpress.org/support/users/hcabrera/) * (@hcabrera) * [12 years ago](https://wordpress.org/support/topic/wordpress-popular-posts-using-in-sqlwindows-azure/#post-4940280) * Ah, your hosting is using SQL Server. I’m actually surprised that you were able to install WordPress there, because according to [this](http://wordpress.org/about/requirements/) it requires mySQL. Until now, I had no idea that there were unofficial distributions of WordPress that could run on other database engines. * There’s not much I can do, I’m afraid. The plugin is not designed to run under SQL Server since WordPress itself doesn’t support it either, hence WPP crashes while trying to execute queries. * I’d love to help you, honestly, but perhaps you should ask your hosting to switch to mySQL (or move your site to another server). * Thread Starter [Zied Ellouze](https://wordpress.org/support/users/zied86/) * (@zied86) * [12 years ago](https://wordpress.org/support/topic/wordpress-popular-posts-using-in-sqlwindows-azure/#post-4940281) * Hi Héctor the problem that Windows Azure only works with SQL Server word press 3.5.1 it’s compatible SQL [http://blogs.technet.com/b/blainbar/archive/2013/08/07/article-create-a-wordpress-site-using-windows-azure-read-on.aspx](http://blogs.technet.com/b/blainbar/archive/2013/08/07/article-create-a-wordpress-site-using-windows-azure-read-on.aspx) + [http://fr.openclassrooms.com/informatique/cours/hebergez-vos-projets-web-dans-le-cloud-avec-windows-azure/deployer-wordpress-sur-windows-azure](http://fr.openclassrooms.com/informatique/cours/hebergez-vos-projets-web-dans-le-cloud-avec-windows-azure/deployer-wordpress-sur-windows-azure) hank you for your follow * Plugin Author [Hector Cabrera](https://wordpress.org/support/users/hcabrera/) * (@hcabrera) * [12 years ago](https://wordpress.org/support/topic/wordpress-popular-posts-using-in-sqlwindows-azure/#post-4940384) * According to the first article you linked and to [this one](http://azure.microsoft.com/en-us/documentation/articles/store-php-create-mysql-database/) as well, Windows Azure _does_ supports MySQL. [Here](http://azure.microsoft.com/en-us/documentation/articles/store-php-create-mysql-database/) you’ll find instructions on creating MySQL databases. * If you’re unsure about it, you should contact your host and ask for assistance. Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Using in SQL/WINDOWS AZURE’ is closed to new replies. * ![](https://ps.w.org/wordpress-popular-posts/assets/icon-256x256.png?rev=1232659) * [WP Popular Posts](https://wordpress.org/plugins/wordpress-popular-posts/) * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-popular-posts/#faq) * [Support Threads](https://wordpress.org/support/plugin/wordpress-popular-posts/) * [Active Topics](https://wordpress.org/support/plugin/wordpress-popular-posts/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-popular-posts/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wordpress-popular-posts/reviews/) ## Tags * [sql](https://wordpress.org/support/topic-tag/sql/) * [windows](https://wordpress.org/support/topic-tag/windows/) * 5 replies * 2 participants * Last reply from: [Hector Cabrera](https://wordpress.org/support/users/hcabrera/) * Last activity: [12 years ago](https://wordpress.org/support/topic/wordpress-popular-posts-using-in-sqlwindows-azure/#post-4940384) * Status: resolved