[Koha-bugs] [Bug 17306] Update scripts fail with Mysql 5.7

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17306

--- Comment #8 from Rodrigo Santellan <rsantellan at gmail.com> ---
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.