Hi José Before running the UPDATE query I´ll recommend you to do a validation of the update by converting it to a SELECT statement
So UPDATE issues SET date_due="2020-04-29 23:59:00", lastreneweddate="2020-04-15 15:01:00" WHERE date_due > '2020-03-17'; Will become: SELECT date_due, lastreneweddate FROM issues WHERE date_due > '2020-03-17'; This will find all the same reccods that will be updated in your initial query. BTW a table/DB backup before touching the database is a good idea. Regards Alvaro |----------------------------------------------------------------------------------------| *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mer. 15 avr. 2020 à 17:40, Alex Buckley <[email protected]> a écrit : > Hi Jose, > > Yes you're right at present in all versions of Koha 18.11 currently > available the only way to bulk extend due dates of existing issues is in > the database. > > A couple of suggestions I have for your query are: > > * Currently your query only changes the date_due of issues due on one > day 17 March 2020. If you're goal is to extend all issues that have > been due on 17 March till today's date (i.e. issues due on 17 March, > 18 March, 19 March and so on) then what you could do instead is: > > UPDATE issues SET date_due="2020-04-29 23:59:00", > lastreneweddate="2020-04-15 15:01:00" WHERE date_due > '2020-03-17'; > > This will extend the due date to 29 April 2020 for any item that has > been due between 17 March and today. > > * Also you will not need to specify the database name koha_biblio > because to get into the Koha database shell you'll be specifying the > database name, like so: > > /sudo koha-mysql koha_biblio/ > > > *How this would affect anything else:* > > Any overdue issues due before 17 March will *not* be extended with the > above amended query. Therefore you should consider doing the following: > > * * Stop overdue notices being generated* > > You can do this one of two ways: > > - If you want all notices (overdue, advance, hold and password reset > notices) to stop being sent during the lockdown you can run: > > sudo koha-email-disable <instancename> > > This stops notices being sent but they are still generated. Therefore > when the lockdown is over you will need to: > > - Delete notices in the message_queue database table which have a > time_queued value of during the lockdown, otherwise all overdue notices > generated during the lockdown will be sent > > - Re-enable email > > sudo koha-email-enable <instancename> > > > OR > > - Comment out overdue_notices.pl in the /etc/cron.daily/koha-common file > > This will stop overdue notices being generated at all during the lockdown. > > > * *Stop overdue fines accruing during the lockdown for those overdues > due before 17 March 2020* > > - Set finesMode system preference to /'Calculate (but only for mailing > to the administrator)'/ > > / > / > > * *Stop patrons being charged the replacement cost of items*/**/*(only > applies if you are using the ** > **DefaultLongOverdueChargeValue system preference)*/ > / > > Remove the value from the DefaultLongOverdueChargeValue system preference. > > > Just to let you know soon (probably around 24th April ) Koha 18.11.16 > will be available to upgrade to and that has the wonderful feature of > allowing you to bulk extend due dates in the Koha staff client as this > excellent blog post by my colleague Aleisha Amohia outlines: > https://www.catalyst.net.nz/blog/koha-let-people-read-longer > > Please let me know if you have any questions at all! > > Many thanks, > > Alex > > -- > Alex Buckley > Koha Developer > > Catalyst IT - Expert Open Source Solutions > DDI: +64 4 803 2378 | Mob: +64 22 429 6157 | www.catalyst.net.nz > > > CONFIDENTIALITY NOTICE: This email is intended for the named recipients > only. It may contain privileged, confidential or copyright information. If > you are not the named recipient, any use, reliance upon, disclosure or > copying of this email or its attachments is unauthorised. If you have > received this email in error, please reply via email or call +64 4 499 2267. > > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
