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@gmail.com> Sent: Friday, December 15, 2023 7:29 PM To: Sebastian Krieg <sebastian.krieg@tuz-eisenach.de> Cc: skaman.tx@gmail.com; koha <koha@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@tuz-eisenach.de <mailto:sebastian.krieg@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@tuz-eisenach.de <mailto:sebastian.krieg@tuz-eisenach.de> 15. Dezember 2023 17:30, skaman.tx@gmail.com <mailto:skaman.tx@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@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

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@bugs.koha-community.org> Sent: Tuesday, December 19, 2023 2:45 AM To: skaman.tx@gmail.com Cc: koha <koha@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@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@gmail.com> Sent: Friday, December 15, 2023 7:29 PM To: Sebastian Krieg <sebastian.krieg@tuz-eisenach.de> Cc: skaman.tx@gmail.com; koha <koha@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@tuz-eisenach.de <mailto:sebastian.krieg@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@tuz-eisenach.de <mailto:sebastian.krieg@tuz-eisenach.de>

15. Dezember 2023 17:30, skaman.tx@gmail.com <mailto:skaman.tx@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@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

---

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Renaming the *_tmp tables appears to have done the trick. The upgrade to 23.11.00-1 completed successfully once I ran "apt -f install" to get past the original error message I posted about. Thank you, Jonathan and all who chimed in. Scott -----Original Message----- From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Sent: Tuesday, December 19, 2023 7:54 AM To: skaman.tx@gmail.com Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Debian Upgrade Error: 23.02.04-2 to 23.11.00-1 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@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@bugs.koha-community.org> Sent: Tuesday, December 19, 2023 2:45 AM To: skaman.tx@gmail.com Cc: koha <koha@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@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@gmail.com> Sent: Friday, December 15, 2023 7:29 PM To: Sebastian Krieg <sebastian.krieg@tuz-eisenach.de> Cc: skaman.tx@gmail.com; koha <koha@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@tuz-eisenach.de <mailto:sebastian.krieg@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@tuz-eisenach.de <mailto:sebastian.krieg@tuz-eisenach.de>

15. Dezember 2023 17:30, skaman.tx@gmail.com <mailto:skaman.tx@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@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

---

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha