Hi,
"Masopust, Christian" wrote:
> Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message
'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'WEEK
It seems that webacula has compatibility issues with different versions of
MySQL.
The same will with PostgreSQL, SQLite.
In the near future I will have to review all the SQL queries.
In the future, perhaps better write in webacula-bugtracker:
http://sourceforge.net/projects/webacula/
Try to connect to your MySQL server 4.1.14 (has bacula-database) and verify
the query:
SELECT CURRENT_DATE() - INTERVAL 1 WEEK;
if will be an error (although in the documentation for the version of MySQL
4.1.1 such syntax described), then try
SELECT NOW() - INTERVAL 7 DAY;
if this query is OK, download the new version of file Job.php from the
repository.
Note. Because SourceForge fixed 'SVN migrating', a recent revision files
will be different from past.
--
wbr
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
