Hi Jonathan, In version 17.11.05 there was no problem when I tried to import the base. Everthing was ok. The problem appeared in 17.11.06. The solution proposed by Jon Turner works very well: Execute two queries in mysql: CREATE TABLE IF NOT EXISTS club_enrollments ( id int(11) NOT NULL AUTO_INCREMENT, club_id int(11) NOT NULL, borrowernumber int(11) NOT NULL, date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, date_canceled timestamp NULL DEFAULT NULL, date_created timestamp NULL DEFAULT NULL, date_updated timestamp NULL DEFAULT NULL, branchcode varchar(10) NULL DEFAULT NULL, PRIMARY KEY (id), KEY club_id (club_id), KEY borrowernumber (borrowernumber), KEY branchcode (branchcode), CONSTRAINT club_enrollments_ibfk_1 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT club_enrollments_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT club_enrollments_ibfk_3 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE IF NOT EXISTS club_enrollment_fields ( id int(11) NOT NULL AUTO_INCREMENT, club_enrollment_id int(11) NOT NULL, club_template_enrollment_field_id int(11) NOT NULL, `value` text NOT NULL, PRIMARY KEY (id), KEY club_enrollment_id (club_enrollment_id), KEY club_template_enrollment_field_id (club_template_enrollment_field_id), CONSTRAINT club_enrollment_fields_ibfk_1 FOREIGN KEY (club_enrollment_id) REFERENCES club_enrollments (id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT club_enrollment_fields_ibfk_2 FOREIGN KEY (club_template_enrollment_field_id) REFERENCES club_template_enrollment_fields (id) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; With the koha schema update there were no problems or errors. I have'nt any tables with club* Migrate was very simple - on old server I dump with koha-dump data from database koha 3.20 -> on new server (Ubuntu 16.04) I cerated new instance koha and import from file database.sql to new base. Then I run koha-update-schema and run koha-rebulid-zebra. That's all. In koha 17.11.05 work without problems in 17.11.06 two trys and two failed. Redgards, Przemek W dniu 12.06.2018 o 14:52, Jonathan Druart pisze:
Hi,
The table club_enrollments has been added in 16.12.00.027 Do you have other tables with names starting with club_*?
How did you migrate? Are you sure there were no errors during the DB upgrade process?
Regards, Jonathan
On Tue, 12 Jun 2018 at 06:48 Przemek Kosiński <p.kosinski@biblioteka24.eu <mailto:p.kosinski@biblioteka24.eu>> wrote:
Hi everyone,
I tried to do a base migration from 3.20 to 17.11.06. The conversion of the database to the new schema and indexation has gone ok - everything works except the possibility of a full preview of the patron - after choosing one they receive such an error:
Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_biblio-main.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 269
I did two attempts and this problem appeared every time.
System: Ubuntu 16.04LTS DataBase: MariaDB 10.0.34 Plack not enabled - when enable plack I get an error: Internal Server Error
In the version of koha 17.11.05 there was no such error - the earlier attempt to migrate to this version was successful.
I have a question about what I can do about it. Alternatively, how to withdrawal to an earlier version 17.11.05 to check whether this error can be invoked.
Best regards Przemek Kosiński
-- ************************************************* Powiatowa i Miejska Biblioteka Publiczna w Skarżysku-Kamiennej www: www.biblioteka24.eu <http://www.biblioteka24.eu> mail: p.kosinski@biblioteka24.eu <mailto:p.kosinski@biblioteka24.eu> ************************************************* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
-- ************************************************* Powiatowa i Miejska Biblioteka Publiczna w Skarżysku-Kamiennej www: www.biblioteka24.eu mail: p.kosinski@biblioteka24.eu *************************************************