From: <bac...@li...> - 2007-04-30 08:21:06
|
A NOTE has been added to this issue. ====================================================================== http://bugs.bacula.org/view.php?id=836 ====================================================================== Reported By: litauer Assigned To: ebollengier ====================================================================== Project: bacula Issue ID: 836 Category: brestore Reproducibility: always Severity: major Priority: normal Status: assigned ====================================================================== Date Submitted: 04-25-2007 09:34 EDT Last Modified: 04-30-2007 04:20 EDT ====================================================================== Summary: SQL errors Description: When selecting a client from the client list, following errors are reported: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND brestore_pathvisibility1.jobid IN (126,106,86,66,46,4)) AS listpath1 JOI' at line 13 at ./brestore.pl line 2519. DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at ./brestore.pl line 2520. DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND File.JobId IN (126,106,86,66,46,4) GROUP BY Filename.Name ORDER BY' at line 7 at ./brestore.pl line 292. Use of uninitialized value in subroutine entry at ./brestore.pl line 1491. ====================================================================== ---------------------------------------------------------------------- ebollengier - 04-28-07 06:44 ---------------------------------------------------------------------- Can you run brestore with debug option and past the full sql statement ? ---------------------------------------------------------------------- ebollengier - 04-28-07 07:53 ---------------------------------------------------------------------- Witch version of mysql are you using ? ---------------------------------------------------------------------- litauer - 04-30-07 02:37 ---------------------------------------------------------------------- I am running mysql 5.0 Here ist the debug output (parts of it): Bvfs::ls_dirs:2518 SELECT PathId, Path, JobId, Lstat FROM ( SELECT Path1.PathId, Path1.Path, lower(Path1.Path), listfile1.JobId, listfile1.Lstat FROM ( SELECT DISTINCT brestore_pathhierarchy1.PathId FROM brestore_pathhierarchy AS brestore_pathhierarchy1 JOIN Path AS Path2 ON (brestore_pathhierarchy1.PathId = Path2.PathId) JOIN brestore_pathvisibility AS brestore_pathvisibility1 ON (brestore_pathhierarchy1.PathId = brestore_pathvisibility1.PathId) WHERE brestore_pathhierarchy1.PPathId = AND brestore_pathvisibility1.jobid IN (231,210,189,4)) AS listpath1 JOIN Path AS Path1 ON (listpath1.PathId = Path1.PathId) LEFT JOIN ( SELECT File1.PathId, File1.JobId, File1.Lstat FROM File AS File1 WHERE File1.FilenameId = 21 AND File1.JobId IN (231,210,189,4)) AS listfile1 ON (listpath1.PathId = listfile1.PathId) ) AS A ORDER BY 2,3 DESC DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND brestore_pathvisibility1.jobid IN (231,210,189,4)) AS listpath1 JOIN Pat' at line 13 at ./brestore.pl line 2519. DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at ./brestore.pl line 2520. ---------------------------------------------------------------------- ebollengier - 04-30-07 04:02 ---------------------------------------------------------------------- Can you try the last svn version ? You have to remove old tables drop table brestore_knownjobid; drop table brestore_pathhierarchy; drop table brestore_pathvisibility; drop table brestore_missing_path; ---------------------------------------------------------------------- litauer - 04-30-07 04:20 ---------------------------------------------------------------------- Works great, thanks a lot! Issue History Date Modified Username Field Change ====================================================================== 04-25-07 09:34 litauer New Issue 04-25-07 09:34 litauer Status new => assigned 04-25-07 09:34 litauer Assigned To => ebollengier 04-28-07 06:44 ebollengier Note Added: 0002405 04-28-07 07:53 ebollengier Note Added: 0002406 04-30-07 02:37 litauer Note Added: 0002416 04-30-07 04:02 ebollengier Note Added: 0002417 04-30-07 04:20 litauer Note Added: 0002418 ====================================================================== |