View Single Post
  #113  
Old 03-27-2014, 05:22 AM
 
suehamil suehamil is offline
 

Advanced Member
  
Join Date: Mar 2014
Posts: 96
 

Default Re: Pop-up Anywhere module released

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
__________________
X-Cart DB Version: 4.7 GOLD
3rd Party Addons:
XMenus Responsive
XBanners2
Skin: Fashion Walk
Reply With Quote