Quote:
Originally Posted by suehamil
Hi
I've been trying to install this module but have hit a problem.
I am getting a warning
Please wait ...
popup_anywhere.sql [FAILED] BLOB/TEXT column 'content' can't have a default value
I am running this as a local test.
MySQL server 5.1
|
In case anyone else runs into the same issue I fixed it by following these instruction:
http://stackoverflow.com/questions/3466872/why-cant-a-text-column-have-a-default-value-in-mysql
How to disable strict mode in MySQL 5 (Windows):
Edit /my.ini and look for line
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION"
Replace it with
sql_mode='MYSQL40'
Restart the MySQL service (assuming that it is mysql5)
net stop mysql5
net start mysql5
If you have root/admin access you might be able to execute
mysql_query("SET @@global.sql_mode='MYSQL40'");
It seems this is a 'bug' with using MySQL on windows.
Sue