Hi,
09.07.2008 15:02, Steve Campbell wrote:
> I have just upgraded my bacula from 2.0.3 to 2.4.0 using source
> installs. The DIR, SD, and FD are running on a Centos 3 box with MySQL
> version 3.23 running. I am getting the following error for each job that
> I am running:
>
> JobId 3526: Fatal error: Can't fill Path table Query failed: INSERT INTO
> Path (Path) SELECT a.Path FROM (SELECT DISTINCT Path FROM batch) AS a
> WHERE NOT EXISTS (SELECT Path FROM Path AS p WHERE p.Path = a.Path):
> ERR=You have an error in your SQL syntax near 'SELECT DISTINCT Path FROM
> batch) AS a WHERE NOT EXISTS (SELECT Path FROM Path AS' at line 1
>
> Does this sound like a mysql version error or did I miss something on
> the installation? I was under the impression that the db tables hadn't
> changed in the Version 2.X.X bacula releases, but maybe missed a parm in
> the configure or something related to MySQL.
You'll need a newer version of MySQL for a current Bacula. AFAIK, the
4.x versions should work.
Older versions than 4.0 will not receive any maintenance, bug fixes or
support since end of 2006.
Arno
> Thanks
>
> Steve Campbell
>
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|