| • bzimport | |
| Mar 22 2007, 5:23 PM |
| F3796: sqlpatch.patch | |
| Nov 21 2014, 9:38 PM |
Author: thomas.dalton
Description:
The database patch "patch-rc_deleted.sql" has an incorrect data type which
causes update.php to fail. I have a patch to fix it, but no commit access, so
I'll just upload it here.
Version: unspecified
Severity: critical
OS: Windows XP
Platform: PC
robchur wrote:
"BLOB" is a valid column data type, although it can't have a default value in
MySQL strict mode.
thomas.dalton wrote:
Does it need to be a BLOB? If so, we can just remove the default.
robchur wrote:
(In reply to comment #4)
rc_params is defined exactly the same as log_params. Odd.
MySQL won't accept a default value for a BLOB column when operating in strict
mode; patches aren't split up to cope with the three schema variants we offer.