[Koha] MOVED KOHA FROM OLD TO NEW SERVER LOGIN ERROR

[Fadhili Ngalawa]

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 at 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 at 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 at 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 at 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.
>
>