[Bug 21273] New: After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

classic Classic list List threaded Threaded
17 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] New: After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

            Bug ID: 21273
           Summary: After upgrade from 17.11.08 to 18.05.02 intra not
                    working, Software error: Template process failed
 Change sponsored?: ---
           Product: Koha
           Version: 18.05
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Installation and upgrade (command-line installer)
          Assignee: [hidden email]
          Reporter: [hidden email]
        QA Contact: [hidden email]

Created attachment 78177
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=78177&action=edit
Screenshot phpmyadmin

After upgrading from 17.11.08 to 18.05.02 we get the following software error
on the intra:

Software error:
Template process failed: undef error -
DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_koha.branches' doesn't
exist in engine at /usr/share/koha/lib/Koha/Objects.pm line 269

Users can't login on the OPAC and a search from the opac throws the following
error:
DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_koha.branches' doesn't
exist in engine at /usr/share/koha/lib/Koha/Objects.pm line 129

It seems like there went something wrong during the upgrade process.

With phpmyadmin we can see that the table 'koha_koha.branches' is still there
but the collation is shown as in-use. If we try to select this table we get the
following error:

#1932 - Table 'koha_koha.branches' doesn't exist in engine

The same error occurs on three other tables:
 borrower_attribute_types
 categories
 currency

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

Jonathan Druart <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]-c
                   |                            |ommunity.org

--- Comment #1 from Jonathan Druart <[hidden email]> ---
If it happens on your test system I would replay the upgrade.

You can also try
  REPAIR TABLE `table_name`

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

--- Comment #2 from Elias <[hidden email]> ---
Just tested it with the 18.05.03 update.
The upgrade went fine, but after a server restart the same issues occur.

REPAIR TABLE fails with message that the table doesn't exist in the engine

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

Michael Oehrlich <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]-
                   |                            |jena.de

--- Comment #3 from Michael Oehrlich <[hidden email]> ---
Updated the MariaDB Version to 10.2.17-MariaDB-10.2.17+maria~xenial
Than it works. Probably the update script should check this. See attachment.

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

--- Comment #4 from Michael Oehrlich <[hidden email]> ---
Created attachment 78330
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=78330&action=edit
Alter Table not working

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

Jonathan Druart <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |18336


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18336
[Bug 18336] Add support for Unicode supplementary characters
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

Jonathan Druart <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|enhancement                 |major
                 CC|                            |[hidden email]
            Version|18.05                       |master

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

--- Comment #5 from Jonathan Druart <[hidden email]> ---
(In reply to Michael Oehrlich from comment #3)
> Updated the MariaDB Version to 10.2.17-MariaDB-10.2.17+maria~xenial
> Than it works. Probably the update script should check this. See attachment.

Which version did you have before?

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

--- Comment #6 from Michael Oehrlich <[hidden email]> ---
(In reply to Jonathan Druart from comment #5)
> (In reply to Michael Oehrlich from comment #3)
> > Updated the MariaDB Version to 10.2.17-MariaDB-10.2.17+maria~xenial
> > Than it works. Probably the update script should check this. See attachment.
>
> Which version did you have before?

10.0.36

https://packages.ubuntu.com/de/xenial/mariadb-server

Last stable version from package manager. The update is only possible if we are
using an additional mirror.

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

Katrin Fischer <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #7 from Katrin Fischer <[hidden email]> ---
Hi Michael, were you able to solve the problem?
Is there a chance that you have additional indexes or similar or some other
changes to standard?

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

--- Comment #8 from Michael Oehrlich <[hidden email]> ---
(In reply to Katrin Fischer from comment #7)
> Hi Michael, were you able to solve the problem?
> Is there a chance that you have additional indexes or similar or some other
> changes to standard?

At the moment on Ubuntu 16.04.05 it is not possible to get an official release
upgrade from mariadb. On Ubuntu 18 it's "10.1.34-MariaDB-0ubuntu0.18.04.1". Out
of the box that doesn't work. You just need another release package from
another source. It would be okay to do that, but you just need a check or a
warning and a stop of the upgrade process from koha-common if you not have a
mariadb version that can handle this emojis in its index.

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

David Cook <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

--- Comment #9 from Jonathan Druart <[hidden email]> ---
(In reply to Michael Oehrlich from comment #4)
> Created attachment 78330 [details]
> Alter Table not working

On this screenshot: "Index column size too large. The maximum column size is
767 bytes. at /usr/share/perl5/DBIx/RunSQL.pm line 273."

(To help searching this issue)

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

Jonathan Druart <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           See Also|                            |https://bugs.koha-community
                   |                            |.org/bugzilla3/show_bug.cgi
                   |                            |?id=21496

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

Martin Renvoize <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |martin.renvoize@ptfs-europe
                   |                            |.com

--- Comment #10 from Martin Renvoize <[hidden email]> ---
I can confirm this is also the case with 10.1.26

martin@mr-dev$ sudo apt-cache show mariadb-common
Package: mariadb-common
Source: mariadb-10.1
Version: 10.1.26-0+deb9u1
Installed-Size: 70
Maintainer: Debian MySQL Maintainers <[hidden email]>
Architecture: all
Depends: mysql-common (>= 5.6.25)
Description-en: MariaDB common metapackage
 MariaDB is a fast, stable and true multi-user, multi-threaded SQL database
 server. SQL (Structured Query Language) is the most popular database query
 language in the world. The main goals of MariaDB are speed, robustness and
 ease of use.
Description-md5: a8bf2c1aebcb16934e54a7cb04adbfb4
Multi-Arch: foreign
Homepage: https://mariadb.org/
Tag: protocol::db:mysql, role::app-data, role::metapackage, works-with::db
Section: database
Priority: optional
Filename: pool/main/m/mariadb-10.1/mariadb-common_10.1.26-0+deb9u1_all.deb
Size: 27258
MD5sum: 0e84745e82042355606e8f0e3a2f3fba
SHA256: 284fd5170a4c84651f54f15211ac209022473e38ce978f77b9e1e2518d276154

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

--- Comment #11 from Martin Renvoize <[hidden email]> ---
A complete drop and restors of the database from a backup worked for me.. no
package update required.. I tihnk it may be to do with some file permissions
getting mis-set during mariadb server upgrade?

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21273] After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273

--- Comment #12 from Michael Oehrlich <[hidden email]> ---
(In reply to Martin Renvoize from comment #11)
> A complete drop and restors of the database from a backup worked for me.. no
> package update required.. I tihnk it may be to do with some file permissions
> getting mis-set during mariadb server upgrade?

No did not work for us. Only an instance up to 10.2 from MariaDB did work.

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/