Hello Uwe I've made a patch to fix queries in "bacula/examples/sample-query.sql" Basically is necessary to remove the table Filename and replace "Filename.Name" by "File.FileName"
Best regards *Wanderlei Hüttel* Em ter., 15 de jun. de 2021 às 04:54, Uwe Schuerkamp < uwe.schuerk...@nionex.net> escreveu: > Hi folks, > > I just started upgrading a few instances from 9.6.x to 11.0.5 compiled > from source. Following the db upgrade and trying out a "list files for > a selected jobid" query, I noted an error about the query referencing > the no-longer-existing table "Filename". I'm pretty sure that's noted > in the release notes somewhere, but I didn't see any messages here so > I thought I'd better make sure that the upgrade process went smoothly. > > The backups & restores are running fine on the version, it's just that > both bweb / bacula web and my old query.sql files are borked (I > usually copy over the query.sql file from my previous version). > > Thanks in advance & all the best, > > Uwe > > -- > Uwe Schürkamp | email: <uwe.schuerk...@nionex.net> > > > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users >
sample-query.sql.patch
Description: Binary data
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
