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 to get it by yourself).
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 ‘)’.”;}
Ah, your hosting is using SQL Server. I’m actually surprised that you were able to install WordPress there, because according to this 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).
According to the first article you linked and to this one as well, Windows Azure does supports MySQL. Here you’ll find instructions on creating MySQL databases.
If you’re unsure about it, you should contact your host and ask for assistance.
