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

[skaman.tx at gmail.com]

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