Bug 29255: Built-in offline circulation broken with SQL error
authorOwen Leonard <oleonard@myacpl.org>
Fri, 15 Oct 2021 18:27:16 +0000 (18:27 +0000)
committerKyle Hall <kyle@bywatersolutions.com>
Fri, 19 Nov 2021 15:51:05 +0000 (10:51 -0500)
commit6501ff67ac1b7942f424bed458314efb0132bd68
tree85d8d43d7f421c2f979489a5b764923a40b22700
parent8e1f0cfc8dd71c507af83f9f8033ba9c84d0b293
Bug 29255: Built-in offline circulation broken with SQL error

This patch makes a minor correction to one of the queries used when
synchronizing transactions in the built-in offline circulation system.
This fixes the error:

DBD::mysql::st execute failed: Column 'branchcode' in field list is
ambiguous at /kohadevbox/koha/offline_circ/download.pl line 84

To test you must be using a browser which still supports
applicationCache (Firefox before version 81, Chrome before version 94).

- Apply the patch and restart services.
- Enable the AllowOfflineCirculation system preference.
- Go to Circulation -> Built-in offline circulation interface.
- Click "Synchronize."
- Click the "Download records" button.
- After the page refreshes you should see updated dates where it lists
  "last synced" information.

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Joonas Kylmälä <joonas.kylmala@iki.fi>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
offline_circ/download.pl