Re: 9.11 testing

Looks like we'll need to change the schema somehow such that it's compatible... The ability to specify CURRENT_TIMESTAMP as the default value for a DATETIME column was apparently a new feature in MySQL 5.6.5, with such columns being much more restricted in previous versions:

RE: 9.11 testing

[root@guac ~]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 5.5.50-MariaDB MariaDB Server -Original Message- From: Mike Jumper [mailto:mike.jum...@guac-dev.org] Sent: Tue 1/17/2017 9:38 AM

RE: 9.11 testing

What version of MySQL / MariaDB are you using? On Jan 17, 2017 05:43, "Hawkins, Richard" wrote: > Looks like the same script to me.. > > When I run the sql to update... Her I ran as guacadmin and root.. > > [root@guac upgrade]# mysql -u guacadmin -p guac_db

RE: 9.11 testing

Looks like the same script to me.. When I run the sql to update... Her I ran as guacadmin and root.. [root@guac upgrade]# mysql -u guacadmin -p guac_db < upgrade-pre-0.9.11.sql Enter password: ERROR 1067 (42000) at line 24: Invalid default value for 'password_date' [root@guac upgrade]# mysql -u