On 05/04/18 12:09, Ken Mandelberg wrote: > Phil, thanks! However, still two issues.
>> SQL_MODE = STRICT_ALL_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION >> >> (This goes in the [mysqld] section) > Had a problem with this. I added to /etc/mysql/mysql.conf/mysqld.conf. > Here is a few lines > > [mysqld] > # > # * Basic Settings > SQL_MODE = > ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO > _AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION > # > user = mysql > pid-file = /var/run/mysqld/mysqld.pid > socket = /var/run/mysqld/mysqld.sock > > With this mysqld always fails apparently with > 018-05-04T15:55:57.823432Z 0 [ERROR] unknown variable > 'SQL_MODE=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' That looks correct to me. Try making sql_mode lower case. And just out of constructive paranoia, don't copy and paste, retype the line by hand just to be certain there are no weird non-printing characters in there. > Aside from the startup problem, with sql_mode set dynamically to avoid > the zero date issue, I still have another > one. Bacula does a QUERY to Media with a large number of fields which > includes VolType, but gets > Unknown column 'VolType' in 'field list' You HAVE run the Bacula table upgrade script, right? -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
