Ian Walls <koha.sek...@gmail.com> wrote:
>ceilingDueDate and globalDueDate shouldn't be in your 3.8 system; they >were >deleted as part of the database update that moved them to the >circulation >matrix (issuingrules table). > Yep but if for whatever reason this didn't run or failed the code still refers to at least one of them. That's a legit bug we need to tidy up. Chris >You should be able to re-enter your rules in the Circulation and Fines >rules area under the Administration. You'll have to do this for all >your >rules, which could be a pain. What might be easier is: > >UPDATE issuingrules SET hardduedate = 'XXXX-YY-ZZ' WHERE hardduedate = >'2012-05-17'; > >Where 'XXXX-YY-ZZ' is the new global due date you want to set for all >materials. If you want finer grain control (only applying a global due >date for certain item types, patrons or branches), you'll need to >either >use the Circulation and Fines editor in Admin, or add a series of >additional WHERE clauses to the query. > >Hope this helps, > > >-Ian > >On Thu, May 31, 2012 at 5:14 PM, Chris Cormack ><chr...@catalyst.net.nz>wrote: > >> * jrhsigler (jrhsig...@gmail.com) wrote: >> > Thanks, I looked in 'local use' but didn't see any options for >changing >> > global due dates. I'm at Koha 3.8 now, but set the global due date >when I >> > had 3.4 running. >> > >> > Do you have a sample sql statement that I can use to update the >database >> > directly? >> > >> > Thank you! >> >> Hi, >> >> Sorry about the slow reply, timezones are a pain. >> >> Ok the variable is called ceilingDueDate >> >> So >> >> DELETE FROM systempreferences WHERE variable ='ceilingDueDate'; >> >> Will kill that line completely. >> >> There is also globalDueDate >> >> DELETE FROM systempreferences WHERE variable ='globalDueDate'; >> >> To get rid of it >> >> However if you wanted to file a bug also, because there must be code >> still referencing the old dead syspref, that we need to purge. >> >> So bonus points if you go to bugs.koha-community.org and add a bug >> something like "Vestiges of code still refer to deprecated syspref >> globalDueDate" >> >> Its in C4/Circulation.pm that the bad code is so you could at that, >> and then someone can write a patch to clean it up, extra super mega >> bonus points if you write the patch too :) >> >> Chris >> >> >> >> > >> > >> > >> > -- >> > View this message in context: >> >http://koha.1045719.n5.nabble.com/how-to-undo-global-due-date-tp5714544p5714621.html >> > Sent from the Koha-general mailing list archive at Nabble.com. >> > _______________________________________________ >> > Koha mailing list http://koha-community.org >> > Koha@lists.katipo.co.nz >> > http://lists.katipo.co.nz/mailman/listinfo/koha >> >> -- >> Chris Cormack >> Catalyst IT Ltd. >> +64 4 803 2238 >> PO Box 11-053, Manners St, Wellington 6142, New Zealand >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha