Re: [Bacula-users] damaged database (was Re: possible bug found)

2007-03-17 Thread Mike Seda
Hi Kern, Thanks for these tips... I didn't see them until just now... I actually fixed the database already based on documented changes that I had stored in my Wiki and bacula emails (containing JobId and VolumeName)... I verified the changes by doing a few restores and the aforementioned

[Bacula-users] damaged database (was Re: possible bug found)

2007-03-15 Thread Mike Seda
Hi All, Kern is right... I should have never changed those MediaIds... I actually remember changing a few other things such as renaming the Default pool to Weekly and resetting the auto_increment value on Media and Pool tables. I also remember changing something about PoolId. In hind-sight, I

Re: [Bacula-users] damaged database (was Re: possible bug found)

2007-03-15 Thread Mike Seda
Ok.. I have found all references to MediaId... The following sql statements were executed: select MediaId, JobId from JobMedia; select MediaId from Media; select MediaId from CDImages; select MediaId from LocationLog; Since I also changed PoolId, I did: select PoolId from Pool; select PoolId