MantisBT - ATutor
View Issue Details
0003922ATutorInstallationpublic2009-08-20 04:522009-11-07 12:19
cindy 
cindy 
normalminoralways
closedfixed 
1.6.3 
1.6.4 
SVN
0003922: Error occurs at creating table 'config'
http://www.atutor.ca/view/7/18376/1.html [^]

Error "BLOB/TEXT column 'value' can't have a default value" is reported at creating table 'config'. This happens when mysql sql_mode is set to "strict". The solution is to remove default '' from table creation statement. as below:

`value` TEXT NOT NULL default '',

to

`value` TEXT NOT NULL,
No tags attached.
Issue History
2009-08-20 04:52cindyNew Issue
2009-08-20 04:52cindyAffects version => SVN
2009-08-20 04:55cindyStatusnew => resolved
2009-08-20 04:55cindyFixed in Version => 1.6.3
2009-08-20 04:55cindyResolutionopen => fixed
2009-08-20 04:55cindyAssigned To => cindy
2009-08-20 04:55cindyNote Added: 0003759
2009-11-05 11:12gregStatusresolved => closed
2009-11-07 12:19gregStatusclosed => resolved
2009-11-07 12:19gregFixed in Version1.6.3 => 1.6.4
2009-11-07 12:19gregStatusresolved => closed

Notes
(0003759)
cindy   
2009-08-20 04:55   
SVN revision: 8769

Affected script: install/db/atutor_schema.sql

Solution: remove "default ''" from "creat table `config`" statement.