[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Bug 17258 depends on bug 17323, which changed state. Bug 17323 Summary: MySQL 5.7 - Column search_history.time cannot be null https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17323 What|Removed |Added Status|Pushed to Master|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Bug 17258 depends on bug 17324, which changed state. Bug 17324 Summary: branchcode is NULL in letter triggers red upgrade message https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17324 What|Removed |Added Status|Pushed to Stable|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Bug 17258 depends on bug 17260, which changed state. Bug 17260 Summary: updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17260 What|Removed |Added Status|Pushed to Stable|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Bug 17258 depends on bug 17234, which changed state. Bug 17234 Summary: ALTER IGNORE TABLE is invalid in mysql 5.7. This breaks updatedatabase.pl https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17234 What|Removed |Added Status|Pushed to Stable|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Bug 17258 depends on bug 16554, which changed state. Bug 16554 Summary: Web installer fails to load i18n sample data on MySQL 5.6+ https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16554 What|Removed |Added Status|Pushed to Stable|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Bug 17258 depends on bug 14637, which changed state. Bug 14637 Summary: Add patron category fails with MySQL 5.6.26 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637 What|Removed |Added Status|Pushed to Stable|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Mason James changed: What|Removed |Added CC||m...@kohaaloha.com -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Jonathan Druart changed: What|Removed |Added Depends on||17860 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 [Bug 17860] MARC records will stage, but Manage for import shows 'no data in table' -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 --- Comment #5 from Jonathan Druart --- See https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 --- Comment #6 from Jonathan Druart --- (In reply to Jonathan Druart from comment #5) > See > https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16. > 04_and_MySQL_5.7 On Ubuntu 16.04 (and others recent distro) now (Nov. 2016) is present MySQL 5.7. All version of Koha (3.x, 16.05, 16.11) are not compatible with default config of MySQL 5.7. To bypasss the problem you can: Install MariaDB instead of MySQL [ sudo apt-get install mariadb-server] OR Insert in your /etc/mysql/my.conf: [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION After save the changes and restart mysql. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Katrin Fischer changed: What|Removed |Added CC||ngson2...@yahoo.com --- Comment #4 from Katrin Fischer --- *** Bug 16584 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Jonathan Druart changed: What|Removed |Added Depends on||16858 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16858 [Bug 16858] import_borrowers.pl does not load because of mysql 5.7 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 --- Comment #3 from Jonathan Druart --- Bug 17320 - MySQL 5.7 doesn't work well with SQL using '-00-00' Bug 17324 - branchcode is NULL in letter triggers red upgrade message Bug 17260 - updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Jonathan Druart changed: What|Removed |Added Depends on||17320 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17320 [Bug 17320] MySQL 5.7 doesn't work well with SQL using '-00-00' -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Jonathan Druart changed: What|Removed |Added Depends on||17260 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17260 [Bug 17260] updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Jonathan Druart changed: What|Removed |Added Depends on||17324 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17324 [Bug 17324] branchcode is NULL in letter triggers red upgrade message -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Blou changed: What|Removed |Added CC||philippe.blo...@inlibro.com --- Comment #2 from Blou --- Bug 17328 - Koha fixes for Mysql 5.7 A mini omnibus as I go, with no other intent than report. Sorry, didn't know about this one. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Zeno Tajoli changed: What|Removed |Added Depends on||17328 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17328 [Bug 17328] Koha fixes for Mysql 5.7 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Jonathan Druart changed: What|Removed |Added Depends on||17323 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17323 [Bug 17323] MySQL 5.7 - Column search_history.time cannot be null -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Bug 17258 depends on bug 16094, which changed state. Bug 16094 Summary: error editing (borrowers, reports) with mysql enterprise https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16094 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |DUPLICATE -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 Jonathan Druart changed: What|Removed |Added Depends on||16402, 13669, 16573, 16554, ||14637, 15819, 16094, 16583, ||17234, 17257 --- Comment #1 from Jonathan Druart --- Bug 16402 - DB structure cannot be loaded in MySQL 5.7 Bug 13669 - Web installer fails to load sample data on MySQL 5.6+ Bug 16573 - Web installer fails to load structure and sample data on MySQL 5.7 Bug 16554 - Web installer fails to load i18n sample data on MySQL 5.6+ Bug 14637 - Add patron category fails with MySQL 5.6.26 Bug 15819 - Error when edit borrowers "There are no patron categories defined" but categories exists Bug 16094 - error editing (borrowers, reports) with mysql enterprise Bug 16583 - Strangeness in the staff client on ubuntu 16.04 and MySQL 5.7 Bug 17234 - ALTER IGNORE TABLE is invalid in mysql 5.7. This breaks updatedatabase.pl Bug 17257 - Cannot create a patron under MySQL 5.7 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 [Bug 13669] Web installer fails to load sample data on MySQL 5.6+ https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637 [Bug 14637] Add patron category fails with MySQL 5.6.26 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15819 [Bug 15819] Error when edit borrowers "There are no patron categories defined" but categories exists https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16094 [Bug 16094] error editing (borrowers, reports) with mysql enterprise https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 [Bug 16402] DB structure cannot be loaded in MySQL 5.7 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16554 [Bug 16554] Web installer fails to load i18n sample data on MySQL 5.6+ https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16573 [Bug 16573] Web installer fails to load structure and sample data on MySQL 5.7 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16583 [Bug 16583] Strangeness in the staff client on ubuntu 16.04 and MySQL 5.7 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17234 [Bug 17234] ALTER IGNORE TABLE is invalid in mysql 5.7. This breaks updatedatabase.pl https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17257 [Bug 17257] Cannot create a patron under MySQL 5.7 -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/