https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17306
--- Comment #8 from Rodrigo Santellan <[email protected]> --- I have run again the script using this variable on MySQL 5.7: sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' And the only thing to change was line 1210 and add the columns: $dbh->do("INSERT INTO old_issues (`borrowernumber`, `itemnumber`, `date_due`, `branchcode`, `issuingbranch`, `returndate`, `lastreneweddate`, `renewals`, `timestamp`, `issuedate`, `return`) SELECT `borrowernumber`, `itemnumber`, `date_due`, `branchcode`, `issuingbranch`, `returndate`, `lastreneweddate`, `renewals`, `timestamp`, `issuedate`, `return` FROM issues WHERE returndate IS NOT NULL;"); I add the new attachment of the updatedatabase.pl -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] 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/
