Regarding DBMS Auto increment fix
Dear friends, *Is DBMS auto increment fix required for Koha 18.11.05 (Current version)? Yes/No* In Koha wiki site, it shows only for Koha 16.05, 16.11, and 17.05. There is nothing written for Koha 18.05 and Koha 18.11. Regards, Sambhunath Sahoo/सम्भुनाथ साहु Information Scientist, Central Library, Tezpur University, Tezpur-784028 Assam Mobile: 9085252152, 8895488636 Phone : 03712-27-3229 E-Mail : sambhumlis@gmail.com, sambhu@tezu.ernet.in *ORCID ID:* 0000-0001-9162-879X *Researcher ID:* K-4446-2018
Hi, you need to check the version of your DBMS here: Please check here: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Database_Versio... Any Koha version after 17.05.02 has all the fixes we could do, but the problem stems from the DBMS. Hope this helps, Katrin On 09.05.19 06:52, Sambhunath Sahoo wrote:
Dear friends,
*Is DBMS auto increment fix required for Koha 18.11.05 (Current version)? Yes/No* In Koha wiki site, it shows only for Koha 16.05, 16.11, and 17.05. There is nothing written for Koha 18.05 and Koha 18.11.
Regards, Sambhunath Sahoo/सम्भुनाथ साहु Information Scientist, Central Library, Tezpur University, Tezpur-784028 Assam Mobile: 9085252152, 8895488636 Phone : 03712-27-3229 E-Mail : sambhumlis@gmail.com, sambhu@tezu.ernet.in *ORCID ID:* 0000-0001-9162-879X *Researcher ID:* K-4446-2018 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
It's not a Koha thing it's a DB thing. So it depends on what version of mysql or mariadb you are running. If it is 5.7 or earlier then yes, you need it. If it is later then no it is fixed https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html#... Chris On 9 May 2019 4:52:01 PM NZST, Sambhunath Sahoo <sambhumlis@gmail.com> wrote:
Dear friends,
*Is DBMS auto increment fix required for Koha 18.11.05 (Current version)? Yes/No* In Koha wiki site, it shows only for Koha 16.05, 16.11, and 17.05. There is nothing written for Koha 18.05 and Koha 18.11.
Regards, Sambhunath Sahoo/सम्भुनाथ साहु Information Scientist, Central Library, Tezpur University, Tezpur-784028 Assam Mobile: 9085252152, 8895488636 Phone : 03712-27-3229 E-Mail : sambhumlis@gmail.com, sambhu@tezu.ernet.in *ORCID ID:* 0000-0001-9162-879X *Researcher ID:* K-4446-2018 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Hi Sambhunath, I asked the same question a couple of weeks ago. Here is the answer I received from Jonathan Druart: It does not depend on the Koha version, but the MySQL/MariaDB version, please double check the wiki page. https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix Hope this helps You can find the version you're using on the Server Information tab of the About Koha page. Chris Brown On Thu, May 9, 2019 at 5:52 AM Sambhunath Sahoo <sambhumlis@gmail.com> wrote:
Dear friends,
*Is DBMS auto increment fix required for Koha 18.11.05 (Current version)? Yes/No* In Koha wiki site, it shows only for Koha 16.05, 16.11, and 17.05. There is nothing written for Koha 18.05 and Koha 18.11.
Regards, Sambhunath Sahoo/सम्भुनाथ साहु Information Scientist, Central Library, Tezpur University, Tezpur-784028 Assam Mobile: 9085252152, 8895488636 Phone : 03712-27-3229 E-Mail : sambhumlis@gmail.com, sambhu@tezu.ernet.in *ORCID ID:* 0000-0001-9162-879X *Researcher ID:* K-4446-2018 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Chris Brown -
Chris Cormack -
Katrin Fischer -
Sambhunath Sahoo