Re: MySQL5.1 to 5.5

2016-09-29 Thread Robin Smith
I'll check for that one thanks! On 29 September 2016 at 13:46, Stéphan Mertz wrote: > Hi, > > We had a problem in a MySQL migration with a DEFAULT value in a not null > date time field. > It was set at -00-00 00:00:00 what was not working in recent MySQL. > > Stéphan > > Le 28 sept. 2016 à 1

Re: MySQL5.1 to 5.5

2016-09-29 Thread Stéphan Mertz
Hi, We had a problem in a MySQL migration with a DEFAULT value in a not null date time field. It was set at -00-00 00:00:00 what was not working in recent MySQL. Stéphan > Le 28 sept. 2016 à 11:13, Robin Smith a écrit : > > Hi All > > We have a legacy WO app running using MySQL 5.1 and i

MySQL5.1 to 5.5

2016-09-28 Thread Robin Smith
Hi All We have a legacy WO app running using MySQL 5.1 and its been happily chugging along for many years. However we are now in a situation where our provider is forcing us to move to MySQL 5.5. I wanted to know if anyone knows of any gotchas or clangers around this move, the mysql upgrade docs