MantisBT - ATutor
View Issue Details
0003530ATutor- no cat -public2008-08-07 05:242008-08-21 09:33
cindy 
cindy 
normalminoralways
closedfixed 
 
1.6.1 
SVN
0003530: Patcher: cannot install patch when mysql is in strict mode
When mysql is in strict mode, installing patch gives error "Field 'remove_permission_files' doesn't have a default value".

Refer to http://www.atutor.ca/view/7/14603/1.html [^]
No tags attached.
Issue History
2008-08-07 05:24cindyNew Issue
2008-08-07 05:24cindyAffects version => SVN
2008-08-07 05:27cindyStatusnew => resolved
2008-08-07 05:27cindyFixed in Version => 1.6.1
2008-08-07 05:27cindyResolutionopen => fixed
2008-08-07 05:27cindyAssigned To => cindy
2008-08-07 05:27cindyNote Added: 0003117
2008-08-21 09:33gregStatusresolved => closed

Notes
(0003117)
cindy   
2008-08-07 05:27   
SVN revision: 7780

The problem is when mysql is set to strict mode. It seems you cannot set a default value on a text / blob. AND, since there is no default value, and the query isn't setting a value, mysql chokes up. To fix this issue, add fields "remove_permission_files", "backup_files", "patch_files" to the insert queries in the createPatchesRecord() function in mods/_standard/patcher/classes/Patch.class.php