0004478: database upgrade from 0.18.3 problem: upgrade-ID "filters-db1" does not work on mySQL4.1.3b-beta - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0004478	mantisbt	upgrade	public	2004-09-03 11:15	2004-09-12 08:27

Reporter	brody	Assigned To	jlatour
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Platform	x86	OS	Win2K
Product Version	0.19.0rc1
Fixed in Version	0.19.0

Summary	0004478: database upgrade from 0.18.3 problem: upgrade-ID "filters-db1" does not work on mySQL4.1.3b-beta
Description	the above id throws an ERROR: Invalid default value for 'id'
Tags	No tags attached.

brody 2004-09-03 11:24 reporter ~0007431	removing the errornous part from the sql make the statement working correctly. Only a workaround, I know - but it helps.

jlatour 2004-09-04 05:10 reporter ~0007436	I guess you can't specify a default for an auto_increment in that version. Since an auto_increment field defaults to 1, I don't think we need to specify that in the query, so I removed the default clause.