[Koha] Debian Upgrade Error: 23.02.04-2 to 23.11.00-1

Wed Dec 20 02:53:50 NZDT 2023

Those _tmp tables should not exist, no idea where they are coming from.
If their structures are the same as the ones in kohastructure.sql I
guess you could simply rename them.

Le mar. 19 déc. 2023 à 14:32, <skaman.tx at gmail.com> a écrit :
>
> So, my database is "library." Thus, my command line and results for all "creator_*" tables are:
>
> ---- Screen snip --------
>
> koha-mysql library
> ..
> MariaDB [koha_library]> show tables;
> ....
> | creator_batches_tmp                    |
> | creator_images                               |
> | creator_layouts_tmp                     |
> | creator_templates_tmp                |
> ....
>
> ----- End Screen Snip ---------
>
> As shown, creator_layouts_tmp exists, but not creator_layouts.
>
> I have not missed any upgrades as far as I can tell, so I'm not sure why a table would suddenly be missing. Anyway, thanks for any further helps here.
>
> Scott
>
> -----Original Message-----
> From: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
> Sent: Tuesday, December 19, 2023 2:45 AM
> To: skaman.tx at gmail.com
> Cc: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Debian Upgrade Error: 23.02.04-2 to 23.11.00-1
>
> > ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table
> > 'koha_library.creator_layouts' doesn't exist at
> > /usr/share/koha/lib/C4/Installer.pm line 741
>
> Do you have an instance 'koha_library'? Is the DB correctly created?
> Try: `koha-mysql koha_library` then run "SHOW TABLES". Do you see "creator_layouts"?
>
> Le lun. 18 déc. 2023 à 17:48, <skaman.tx at gmail.com> a écrit :
> >
> > Hi Thomas,
> >
> >
> >
> > So, I got a new koha-common install error when using “apt -f install.” See below.
> >
> >
> >
> > --- Screen Snip ----------
> >
> > …..
> >
> > Upgrade to 23.06.00.051  [10:44:04]: Bug 10762 - Make it possible to
> > adjust the barcode height and width on labels
> >
> > ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table
> > 'koha_library.creator_layouts' doesn't exist at
> > /usr/share/koha/lib/C4/Installer.pm line 741
> >
> > dpkg: error processing package koha-common (--configure):
> >
> > installed koha-common package post-installation script subprocess
> > returned error exit status 1
> >
> > Processing triggers for man-db (2.9.4-2) ...
> >
> > Errors were encountered while processing:
> >
> > koha-common
> >
> > E: Sub-process /usr/bin/dpkg returned an error code (1)
> >
> >
> >
> > --- End Screen Snip -------------------
> >
> >
> >
> > Any ideas?
> >
> >
> >
> > Thank you ,
> >
> >
> >
> > Scott
> >
> >
> >
> > From: Tomas Cohen Arazi <tomascohen at gmail.com>
> > Sent: Friday, December 15, 2023 7:29 PM
> > To: Sebastian Krieg <sebastian.krieg at tuz-eisenach.de>
> > Cc: skaman.tx at gmail.com; koha <koha at lists.katipo.co.nz>
> > Subject: Re: [Koha] Debian Upgrade Error: 23.02.04-2 to 23.11.00-1
> >
> >
> >
> > This should do the trick too:
> >
> >
> >
> > ```
> >
> > apt -f install
> >
> > ```
> >
> >
> >
> > El vie, 15 dic 2023 20:44, Sebastian Krieg <sebastian.krieg at tuz-eisenach.de <mailto:sebastian.krieg at tuz-eisenach.de> > escribió:
> >
> > Hello,
> >
> > I got the same error. The reason is that you installed your language in former versions by hand. Now there is the news package koha-l10n.
> >
> > Please empty '/usr/share/koha/misc/translator/po/' (before make a backup!) and try the installation again.
> >
> > This should work.
> >
> > Greetings
> >
> > Sebastian
> >
> >
> > ---
> > mailto: sebastian.krieg at tuz-eisenach.de
> > <mailto:sebastian.krieg at tuz-eisenach.de>
> >
> >
> >
> > 15. Dezember 2023 17:30, skaman.tx at gmail.com <mailto:skaman.tx at gmail.com>  schrieb:
> >
> > > Attempting to update Koha installation on Debian Bullseye host from
> > > 23.02.04-2 to 23.11.00-1. The following is the output and error
> > > message. Any ideas on how to resolve?
> > >
> > > # apt upgrade
> > >
> > > Reading package lists... Done
> > >
> > > Building dependency tree... Done
> > >
> > > Reading state information... Done
> > >
> > > Calculating upgrade... Done
> > >
> > > The following NEW packages will be installed:
> > >
> > > koha-l10n
> > >
> > > The following packages will be upgraded:
> > >
> > > koha-common
> > >
> > > 1 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
> > >
> > > Need to get 49.9 MB of archives.
> > >
> > > After this operation, 31.0 MB of additional disk space will be used.
> > >
> > > Do you want to continue? [Y/n] y
> > >
> > > Get:1 http://debian.koha-community.org/koha stable/main amd64
> > > koha-l10n all
> > > 23.11.00-1 [32.4 MB]
> > >
> > > Get:2 http://debian.koha-community.org/koha stable/main amd64
> > > koha-common all 23.11.00-1 [17.5 MB]
> > >
> > > Fetched 49.9 MB in 14s (3,540 kB/s)
> > >
> > > Reading changelogs... Done
> > >
> > > Preconfiguring packages ...
> > >
> > > /tmp/koha-common.config.bbiGxu: 49: koha-list: not found
> > >
> > > Selecting previously unselected package koha-l10n.
> > >
> > > (Reading database ... 182866 files and directories currently
> > > installed.)
> > >
> > > Preparing to unpack .../koha-l10n_23.11.00-1_all.deb ...
> > >
> > > Unpacking koha-l10n (23.11.00-1) ...
> > >
> > > dpkg: error processing archive
> > > /var/cache/apt/archives/koha-l10n_23.11.00-1_all.deb (--unpack):
> > >
> > > trying to overwrite
> > > '/usr/share/koha/misc/translator/po/am-Ethi-installer-MARC21.po',
> > > which is also in package koha-common 23.05.04-2
> > >
> > > dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
> > >
> > > Preparing to unpack .../koha-common_23.11.00-1_all.deb ...
> > >
> > > Unpacking koha-common (23.11.00-1) over (23.05.04-2) ...
> > >
> > > Errors were encountered while processing:
> > >
> > > /var/cache/apt/archives/koha-l10n_23.11.00-1_all.deb
> > >
> > > E: Sub-process /usr/bin/dpkg returned an error code (1)
> > >
> > > _______________________________________________
> > >
> > > Koha mailing list http://koha-community.org Koha at lists.katipo.co.nz
> > > <mailto:Koha at lists.katipo.co.nz>
> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > _______________________________________________
> >
> > Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
> > <mailto:Koha at lists.katipo.co.nz>
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> > _______________________________________________
> >
> > Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>