From: <bac...@li...> - 2005-06-23 13:24:27
|
The following bug has been SUBMITTED. ====================================================================== http://bugs.bacula.org/bug_view_advanced_page.php?bug_id=0000361 ====================================================================== Reported By: yjohanss Assigned To: Dan Langille ====================================================================== Project: bacula Bug ID: 361 Category: PostgreSQL Reproducibility: always Severity: major Priority: normal Status: assigned ====================================================================== Date Submitted: 06-23-2005 06:24 PDT Last Modified: 06-23-2005 06:24 PDT ====================================================================== Summary: Restore from bconsole fails with SQL-error. Description: I'm trying to run a restore from bconsole like this: ------------------------------------------------------ *restore To select the JobIds, you have the following choices: 1: List last 20 Jobs run 2: List Jobs where a given File is saved 3: Enter list of comma separated JobIds to select 4: Enter SQL list command 5: Select the most recent backup for a client 6: Select backup for a client before a specified time 7: Enter a list of files to restore 8: Enter a list of files to restore before a specified time 9: Find the JobIds of the most recent backup for a client 10: Find the JobIds for a backup for a client before a specified time 11: Enter a list of directories to restore for given JobIds 12: Cancel Select item: (1-12): 9 Automatically selected Client: localhost-fd The defined FileSet resources are: 1: Catalog 2: Full Set Select FileSet resource (1-2): 2 Query failed: ERROR: column "temp.level" must appear in the GROUP BY clause or be used in an aggregate function ------------------------------------------------------------ ====================================================================== Bug History Date Modified Username Field Change ====================================================================== 06-23-05 06:24 yjohanss New Bug ====================================================================== |