Hello everyone, My Institute was using Koha 16 installed on Ubuntu 14.04. With this setup it was not possible to upgrade to Koha 17.05 or the latest. Yesterday, I did the backup and upgrade the server to Ubuntu 16.04. Unfortunately, after the upgrade, Koha could not be accessed. I later installed Ubuntu 18.04 and install Koha 17.11 but after running the restore procedures as usual using the commands *1. mysql -u root -p koha_instance < backup07052018.sql * *2. sudo koha-upgrade-schema koha_instance3. sudo koha-rebuild-zebra -v -f koha_instance* I managed to access Koha, and logged in (using the users available) to the intranet side or staff client page. (8433 port or known 8080). But when I log in using the OPAC side, I got the below error that made me switch from Koha 17.11 to Koha 17.05 but got the same error. Software error: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_opac.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 269 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. After some online search, I found others were having this problem when using MYSQL but for my case, I am using MariaDB 10. I kindly ask for assistance on the above error. Regards, Fadhili
Hi I have suffered that problem.. it means that table doesn't exist... you just need to create search kohastructure.sql find the table and execute it... and try again, in my case we missed three tables Kindest Regards 2018-05-08 16:15 GMT+02:00 Fadhili Ngalawa <fngalawa@gmail.com>:
Hello everyone,
My Institute was using Koha 16 installed on Ubuntu 14.04. With this setup it was not possible to upgrade to Koha 17.05 or the latest.
Yesterday, I did the backup and upgrade the server to Ubuntu 16.04. Unfortunately, after the upgrade, Koha could not be accessed.
I later installed Ubuntu 18.04 and install Koha 17.11 but after running the restore procedures as usual using the commands *1. mysql -u root -p koha_instance < backup07052018.sql *
*2. sudo koha-upgrade-schema koha_instance3. sudo koha-rebuild-zebra -v -f koha_instance*
I managed to access Koha, and logged in (using the users available) to the intranet side or staff client page. (8433 port or known 8080). But when I log in using the OPAC side, I got the below error that made me switch from Koha 17.11 to Koha 17.05 but got the same error.
Software error:
Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_opac.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 269
For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. After some online search, I found others were having this problem when using MYSQL but for my case, I am using MariaDB 10.
I kindly ask for assistance on the above error.
Regards,
Fadhili
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind> Director Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 - Barcelona - Tel: 933 856 138 hagud@orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
Hello once again, Thank you so much Hugo, I managed to solve it, following your quick response. This is the power of Koha Community. Regards, Fadhili On Tue, May 8, 2018 at 5:18 PM, Hugo Agud <hagud@orex.es> wrote:
Hi
I have suffered that problem.. it means that table doesn't exist... you just need to create search kohastructure.sql find the table and execute it... and try again, in my case we missed three tables
Kindest Regards
2018-05-08 16:15 GMT+02:00 Fadhili Ngalawa <fngalawa@gmail.com>:
Hello everyone,
My Institute was using Koha 16 installed on Ubuntu 14.04. With this setup it was not possible to upgrade to Koha 17.05 or the latest.
Yesterday, I did the backup and upgrade the server to Ubuntu 16.04. Unfortunately, after the upgrade, Koha could not be accessed.
I later installed Ubuntu 18.04 and install Koha 17.11 but after running the restore procedures as usual using the commands *1. mysql -u root -p koha_instance < backup07052018.sql *
*2. sudo koha-upgrade-schema koha_instance3. sudo koha-rebuild-zebra -v -f koha_instance*
I managed to access Koha, and logged in (using the users available) to the intranet side or staff client page. (8433 port or known 8080). But when I log in using the OPAC side, I got the below error that made me switch from Koha 17.11 to Koha 17.05 but got the same error.
Software error:
Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_opac.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 269
For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. After some online search, I found others were having this problem when using MYSQL but for my case, I am using MariaDB 10.
I kindly ask for assistance on the above error.
Regards,
Fadhili
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
--
*Hugo Agud - Orex Digital *
*www.orex.es <http://www.orex.es>*
<http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind>
Director
Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 - Barcelona - Tel: 933 856 138 hagud@orex.es · http://www.orex.es/
No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
hha I suggest to check the upgrade logs to fix all potential issues El mar., 8 may. 2018 17:00, Fadhili Ngalawa <fngalawa@gmail.com> escribió:
Hello once again,
Thank you so much Hugo, I managed to solve it, following your quick response. This is the power of Koha Community.
Regards,
Fadhili
On Tue, May 8, 2018 at 5:18 PM, Hugo Agud <hagud@orex.es> wrote:
Hi
I have suffered that problem.. it means that table doesn't exist... you just need to create search kohastructure.sql find the table and execute it... and try again, in my case we missed three tables
Kindest Regards
2018-05-08 16:15 GMT+02:00 Fadhili Ngalawa <fngalawa@gmail.com>:
Hello everyone,
My Institute was using Koha 16 installed on Ubuntu 14.04. With this setup it was not possible to upgrade to Koha 17.05 or the latest.
Yesterday, I did the backup and upgrade the server to Ubuntu 16.04. Unfortunately, after the upgrade, Koha could not be accessed.
I later installed Ubuntu 18.04 and install Koha 17.11 but after running the restore procedures as usual using the commands *1. mysql -u root -p koha_instance < backup07052018.sql *
*2. sudo koha-upgrade-schema koha_instance3. sudo koha-rebuild-zebra -v -f koha_instance*
I managed to access Koha, and logged in (using the users available) to the intranet side or staff client page. (8433 port or known 8080). But when I log in using the OPAC side, I got the below error that made me switch from Koha 17.11 to Koha 17.05 but got the same error.
Software error:
Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_opac.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 269
For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. After some online search, I found others were having this problem when using MYSQL but for my case, I am using MariaDB 10.
I kindly ask for assistance on the above error.
Regards,
Fadhili
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
--
*Hugo Agud - Orex Digital *
*www.orex.es <http://www.orex.es>*
<http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind>
Director
Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 - Barcelona - Tel: 933 856 138 hagud@orex.es · http://www.orex.es/
No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
Hello, Did not you get an error when upgrading the schema (koha-upgrade-schema)? Regards, Jonathan On Tue, 8 May 2018 at 11:15 Fadhili Ngalawa <fngalawa@gmail.com> wrote:
Hello everyone,
My Institute was using Koha 16 installed on Ubuntu 14.04. With this setup it was not possible to upgrade to Koha 17.05 or the latest.
Yesterday, I did the backup and upgrade the server to Ubuntu 16.04. Unfortunately, after the upgrade, Koha could not be accessed.
I later installed Ubuntu 18.04 and install Koha 17.11 but after running the restore procedures as usual using the commands *1. mysql -u root -p koha_instance < backup07052018.sql *
*2. sudo koha-upgrade-schema koha_instance3. sudo koha-rebuild-zebra -v -f koha_instance*
I managed to access Koha, and logged in (using the users available) to the intranet side or staff client page. (8433 port or known 8080). But when I log in using the OPAC side, I got the below error that made me switch from Koha 17.11 to Koha 17.05 but got the same error.
Software error:
Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_opac.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 269
For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. After some online search, I found others were having this problem when using MYSQL but for my case, I am using MariaDB 10.
I kindly ask for assistance on the above error.
Regards,
Fadhili
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
I don't remember to encounter any error during the process. What I did was to find the file and imported into my database, which deleted the previous available data. Then I imported my backup as usual and run the koha upgrade schema which run without errors. On Tue, May 8, 2018 at 6:07 PM, Jonathan Druart < jonathan.druart@bugs.koha-community.org> wrote:
Hello,
Did not you get an error when upgrading the schema (koha-upgrade-schema)?
Regards, Jonathan
On Tue, 8 May 2018 at 11:15 Fadhili Ngalawa <fngalawa@gmail.com> wrote:
Hello everyone,
My Institute was using Koha 16 installed on Ubuntu 14.04. With this setup it was not possible to upgrade to Koha 17.05 or the latest.
Yesterday, I did the backup and upgrade the server to Ubuntu 16.04. Unfortunately, after the upgrade, Koha could not be accessed.
I later installed Ubuntu 18.04 and install Koha 17.11 but after running the restore procedures as usual using the commands *1. mysql -u root -p koha_instance < backup07052018.sql *
*2. sudo koha-upgrade-schema koha_instance3. sudo koha-rebuild-zebra -v -f koha_instance*
I managed to access Koha, and logged in (using the users available) to the intranet side or staff client page. (8433 port or known 8080). But when I log in using the OPAC side, I got the below error that made me switch from Koha 17.11 to Koha 17.05 but got the same error.
Software error:
Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_opac.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 269
For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. After some online search, I found others were having this problem when using MYSQL but for my case, I am using MariaDB 10.
I kindly ask for assistance on the above error.
Regards,
Fadhili
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Fadhili Ngalawa -
Hugo Agud -
Jonathan Druart