Re: [Bacula-users] Problem with accurate backups

2009-06-15 Thread Robert W Hartzell
Fahrer, Julian wrote: > Hi, > > Not what you asked, But you could also use postgres as database i you > don't want to install a newer mysql version in your box. It also ships > with solaris. > > Kind regards > Mit freundlichem Gruß > > Julian Fahrer > Thanks for the suggestion and i have be

Re: [Bacula-users] Problem with accurate backups

2009-06-15 Thread Fahrer, Julian
15 22:04:18 2009 Betreff: Re: [Bacula-users] Problem with accurate backups 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 > gettin

Re: [Bacula-users] Problem with accurate backups

2009-06-15 Thread Bob
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 th

Re: [Bacula-users] Problem with accurate backups

2009-06-15 Thread Andrea Conti
> 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 y

Re: [Bacula-users] Problem with accurate backups

2009-06-15 Thread Robert W Hartzell
Andrea Conti wrote: >> I'm using MySQL 4.0.31. > > MySQL 4.0 does not support subqueries, you need at least 4.1. > > andrea > Are these subqueries something that's newly added when accurate backups were implemented? The reason I ask is because I have always used the version of mysql that ship

Re: [Bacula-users] Problem with accurate backups

2009-06-15 Thread Andrea Conti
> I'm using MySQL 4.0.31. MySQL 4.0 does not support subqueries, you need at least 4.1. andrea -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited

Re: [Bacula-users] Problem with accurate backups

2009-06-15 Thread Robert W Hartzell
Falk Sauer wrote: > Hi Robert, > > On Montag 15 Juni 2009 08:54:33 wrote: >> Ok i can confirm that th query does fail when entered manualy into >> mysql >> >> building directory tree for JobId(s) 1 ... Query failed: SELECT >> Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LStat >> FRO

Re: [Bacula-users] Problem with accurate backups

2009-06-15 Thread Falk Sauer
Hi Robert, On Montag 15 Juni 2009 08:54:33 wrote: > Ok i can confirm that th query does fail when entered manualy into > mysql > > building directory tree for JobId(s) 1 ... Query failed: SELECT > Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LStat > FROM ( SELECT max(FileId) > as Fi

Re: [Bacula-users] Problem with accurate backups

2009-06-14 Thread Robert W Hartzell
Falk Sauer wrote: > Hi Robert, > > On Montag 15 Juni 2009 06:13:21 wrote: >> Falk Sauer wrote: >>> Hi Bob, >>> >>> On Sonntag 14 Juni 2009 23:35:43 wrote: I have installed both 3.0.0 & 3.0.1 on a test sever using the same configuration and hardware as my production serer. Everything

Re: [Bacula-users] Problem with accurate backups

2009-06-14 Thread Falk Sauer
Hi Robert, On Montag 15 Juni 2009 06:13:21 wrote: > Falk Sauer wrote: > > Hi Bob, > > > > On Sonntag 14 Juni 2009 23:35:43 wrote: > >> I have installed both 3.0.0 & 3.0.1 on a test sever using the > >> same configuration and hardware as my production serer. > >> Everything works as expected until

Re: [Bacula-users] Problem with accurate backups

2009-06-14 Thread Robert W Hartzell
Falk Sauer wrote: > Hi Bob, > > On Sonntag 14 Juni 2009 23:35:43 wrote: >> I have installed both 3.0.0 & 3.0.1 on a test sever using the same >> configuration and hardware as my production serer. Everything >> works as expected until I enable accurate backups. I can run a >> level full backup whic

[Bacula-users] Problem with accurate backups

2009-06-14 Thread Bob
I have installed both 3.0.0 & 3.0.1 on a test sever using the same configuration and hardware as my production serer. Everything works as expected until I enable accurate backups. I can run a level full backup which runs with no problem but when I try an incremental i get this error. JobId 2: