This is an issue with MySQL running on Windows. I noticed no tables were being created in the database when the plugin was installed and checked the php files for the relevant SQL:
CREATE TABLE dbname.wp_websimon_tables (
id mediumint(9) NOT NULL AUTO_INCREMENT,
tablename VARCHAR(150) DEFAULT '' NOT NULL,
shortcode VARCHAR(500) DEFAULT '' NOT NULL,
rows VARCHAR(500) DEFAULT '' NOT NULL,
cols VARCHAR(500) DEFAULT '' NOT NULL,
style VARCHAR(500) DEFAULT '' NOT NULL,
design TEXT(5000) DEFAULT '' NOT NULL,
advanced TEXT(5000) DEFAULT '' NOT NULL,
headlines TEXT(5000) DEFAULT '' NOT NULL,
content TEXT(100000) DEFAULT '' NOT NULL,
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
This would not execute because you cannot have a default value on a text field. I fixed this by changing the relevant column types to varchar and reduced the size to 500 (I found out if you use varchar columns there is a limit to the row size) and was able to execute the script and could subsequently use the plugin.
However, please note on Linux installations when you execute the above SQL the user will receive a warning rather than an error and the SQL will still execute. There is more information on this here:
https://stackoverflow.com/questions/3466872/why-cant-a-text-column-have-a-default-value-in-mysql
This is an illustration of the problem when you develop on Linux and the code gets deployed on Windows. The thread above provides a fix but I think the SQL script needs amending – I’ve not tested yet but Microsoft runs its WordPress sites on Windows and any Azure customers are likely to hit this problem.
Matt
