Hello Ken
Take a look
https://github.com/wanderleihuttel/bacula-utils/blob/master/dicas/mysql_sql-mode.md
Enviado de Motorola Moto Z2 Play
Wanderlei Hüttel
Em qui, 14 de mar de 2019 18:02, Ken Mandelberg <k...@mathcs.emory.edu>
escreveu:
> My problem with the label command comes down do this, the INSERT into
> the Media Record fails since FirstWritten doesn't have a default value.
> Details below.
>
> From very old posting this seems to be an incompatibility with newer
> Mysql that doesnt want NULL values. For the record, I'm running Bacula
> 9.0.6 and Mysql 5.7 both of which are the defaults on Ubuntu 18.04.
>
> Suggestions?
>
> The failing INSERT:
>
> 14-Mar 15:55 orac-dir JobId 3992: Error: sql_create.c:439 Create DB
> Media record INSERT INTO Media
> (VolumeName,MediaType,MediaTypeId,PoolId,MaxVolBytes,VolCapacityBytes,Recycle,VolRetention,VolUseDuration,M
>
>
> axVolJobs,MaxVolFiles,VolStatus,Slot,VolBytes,InChanger,VolReadTime,VolWriteTime,VolType,VolParts,VolCloudParts,LastPartBytes,EndFile,EndBlock,LabelType,StorageId,DeviceId,LocationId,ScratchPoolId,RecyclePo
>
> olId,Enabled,ActionOnPurge,CacheRetention)VALUES
> ('Vol0013','File',0,2,53687091200,0,1,7776000,0,0,0,'Append',0,0,0,0,0,0,0,0,'0',0,0,0,1,0,0,0,0,1,0,0)
>
> failed. ERR=Field 'FirstWritten' doesn't have a default value
>
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
