hello again Yuri,
yes you were right, there seem to be some incompatibilities in MySQL-version.
the command you asked me to run works fine on mysql 5.0.22 and fail on 4.1.14.
so it's now time for updating MySQL (this is already on my tasklist for a long
time
but hasn't had the highest priority... :-))
thanks a lot,
christian
--
"I sense much NT in you, NT leads to Blue Screen.
Blue Screen leads to downtime, downtime leads to suffering. NT is the path to
the darkside."
- Unknown Unix Jedi
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Yuri
Timofeev
Sent: Wednesday, January 02, 2008 6:45 PM
To: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] Web-Client
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
