Andrea Conti wrote:
>> Are these subqueries something that's newly added when accurate backups 
>> were implemented?
> 
> Well, all I wanted to point out was that the error message you are
> getting is caused by MySQL choking on the subquery in the statement...
> 
> I am not really familiar with the SQL Bacula uses, but yes, if you were
> using MySQL 4.0 without problems, then I'd say that none of the stuff in
> 2.4.4 contains subqueries as you would get similar error messages
> otherwise. I cannot vouch for 3.0, as other things might have been
> rewritten.
> 
> I strongly suggest upgrading MySQL anyway, as 4.0 is *really* ancient...
> 
> andrea

I do have a newer version of MySQL (5.1.30) available on another host 
and I can confirm that everything works as expected using the newer version.

unfortunately this adds a layer of complexity to using bacula on solaris 
that i'm not looking forward to. Does anyone know if using bacula 
compiled against mysql 4.0 is going to cause any issues when connecting 
to a database running version 5.0 or newer?

Bob


------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users