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 f
Author: Robert W Hartzell <bear AT rwhartzell DOT net>
Date: Sun, 14 Jun 2009 21:13:21 -0700
Since this is a test server i have tried many different size jobs from 20mb to 20gb all still with the same results :( I'm using MySQL 4.0.31. This error returns almost instantly after the job starts
Hi Robert, can you find this sql query in your debug output? If yes put it in your mySqlAdmin and try this sql statement alone, then you see if the sql syntax is really broken or what the error can b
Author: Robert W Hartzell <bear AT rwhartzell DOT net>
Date: Sun, 14 Jun 2009 23:54:33 -0700
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.LSt
Hi Robert, if this statement is correct copied then bacula makes this error, the statement has imho really syntactical failures: SELECT Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LSta
Author: Robert W Hartzell <bear AT rwhartzell DOT net>
Date: Mon, 15 Jun 2009 00:49:04 -0700
Ok I will file a bug and see if someone can take a look at it. Thanks for your help, Bob -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enab
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 royal
Author: Robert W Hartzell <bear AT rwhartzell DOT net>
Date: Mon, 15 Jun 2009 11:31:32 -0700
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 ships with Solaris and haven't had a
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,
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 usi
Author: "Fahrer, Julian" <julian AT fahrer DOT net>
Date: Mon, 15 Jun 2009 23:23:55 +0200
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ß Julia
Author: Robert W Hartzell <bear AT rwhartzell DOT net>
Date: Mon, 15 Jun 2009 14:43:13 -0700
Thanks for the suggestion and i have been looking into doing that. bob -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited roya