Hello,
I'm running on a fedora host using latest Fedora packages:
bacula is version 11.0.5-1.fc34.x86_64; DB is postgresql-13.4-1.fc34.x86_64
The system has been installed _many_ years ago.
I thought I had succesfully run all DB upgrades during that time,
but apparently something is missing:
When trying to run query # 2 "List where the most recent copies of a
file are saved", I get the following error message:
...
Choose a query (1-17): 2
Enter path with trailing slash: XXXXXX
Enter filename: YYYYYY
Enter Client name: ZZZZZZ
Query failed: ERROR: relation "filename" does not exist
LINE 1: ...ame,Client.Name AS ClientName FROM Job,File,Path,Filename,M...
^
SELECT DISTINCT Job.JobId,StartTime AS JobStartTime,VolumeName,Client.Name AS
ClientName FROM Job,File,Path,Filename,Media,JobMedia,Client WHERE
File.JobId=Job.JobId AND Path.Path='XXXXXX' AND Filename.Name='YYYYYY' AND
Client.Name='ZZZZZZ' AND Path.PathId=File.PathId AND
Filename.FilenameId=File.FilenameId AND JobMedia.JobId=Job.JobId AND
JobMedia.MediaId=Media.MediaId AND Client.ClientId=Job.ClientId ORDER BY
Job.StartTime DESC LIMIT 20;
Does this ring a bell to somebody? Any ideas how to fix that?
Thanks in advance.
Best regards,
Wolfgang Denk
--
DENX Software Engineering GmbH, Managing Director: Wolfgang Denk
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: [email protected]
There is is no reason for any individual to have a computer in their
home. -- Ken Olsen (President of Digital Equipment Corporation),
Convention of the World Future Society, in Boston, 1977
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
