Add doc about TIMESTAMP modes in MySQL

diff --git a/docs/manuals/en/main/mysql.tex b/docs/manuals/en/main/mysql.tex
index 4da2bd37252a5f4b02d98cd8551a82005c99ca36..bc6ccb44c6faac7e033d8a4268bd2a962590962f 100644 (file)
--- a/docs/manuals/en/main/mysql.tex
+++ b/docs/manuals/en/main/mysql.tex
@@ -316,3 +316,11 @@ Bacula otherwise you are likely to get bizarre failures.  If you
 install from rpms and you upgrade MySQL, you must also rebuild Bacula.
 You can do so by rebuilding from the source rpm. To do so, you may need
 to modify the bacula.spec file to account for the new MySQL version.
+
+\section{MySQL Configuration Caution}
+\index[general]{MySQL Caution}
+Bacula requires that at least one of the TIMESTAMP fields in the
+database schema to have a valid value of zero.  If you turn on the 
+{\bf SQL\_MODE} {\bf STRICT\_ALL\_TABLES}, you must be sure that you
+turn off the {\bf NO\_ZERO\_DATA} and the {\bf NO\_ZERO\_IN\_DATE} 
+restrictions or Bacula will not function correctly.