2 This patch should fix "update slots" with two different magazines
3 in different pools by checking the pool when zapping the InChanger.
7 patch -p0 <1.36.1-slots.patch
12 Index: src/cats/sql_update.c
13 ===================================================================
14 RCS file: /cvsroot/bacula/bacula/src/cats/sql_update.c,v
15 retrieving revision 1.52
16 diff -u -r1.52 sql_update.c
17 --- src/cats/sql_update.c 17 Nov 2004 22:48:21 -0000 1.52
18 +++ src/cats/sql_update.c 3 Dec 2004 21:11:09 -0000
21 if (mr->InChanger != 0 && mr->Slot != 0) {
22 Mmsg(mdb->cmd, "UPDATE Media SET InChanger=0 WHERE "
23 - "Slot=%d AND MediaId!=%u", mr->Slot, mr->MediaId);
24 + "Slot=%d AND PoolId=%u AND MediaId!=%u",
25 + mr->Slot, mr->PoolId, mr->MediaId);
26 Dmsg1(400, "%s\n", mdb->cmd);
27 UPDATE_DB(jcr, mdb, mdb->cmd);