[Bug 17258] New: [OMIBUS] MySQL 5.7

classic Classic list List threaded Threaded
83 messages Options
123
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] New: [OMIBUS] MySQL 5.7

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

            Bug ID: 17258
           Summary: [OMIBUS] MySQL 5.7
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: [hidden email]
          Reporter: [hidden email]
        QA Contact: [hidden email]

This is an omnibus report to group the different issues under MySQL 5.7

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |16402, 13669, 16573, 16554,
                   |                            |14637, 15819, 16094, 16583,
                   |                            |17234, 17257

--- Comment #1 from Jonathan Druart <[hidden email]> ---
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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> 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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Zeno Tajoli <[hidden email]> 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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Blou <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #2 from Blou <[hidden email]> ---
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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> 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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> 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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> 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 '0000-00-00'
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

--- Comment #3 from Jonathan Druart <[hidden email]> ---
Bug 17320 - MySQL 5.7 doesn't work well with SQL using '0000-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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> 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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Katrin Fischer <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #4 from Katrin Fischer <[hidden email]> ---
*** 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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

--- Comment #6 from Jonathan Druart <[hidden email]> ---
(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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> 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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Mason James <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
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
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMNIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Nick Clemens <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|[OMIBUS] MySQL 5.7          |[OMNIBUS] MySQL 5.7
                 CC|                            |[hidden email]

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMNIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |18836


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836
[Bug 18836] MySQL 5.7 - Table 'koha_library.club_enrollments' doesn't exist
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMNIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |19492


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19492
[Bug 19492] Field 'lowestPriority' doesn't have a default value (MariaDB)
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMNIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258
Bug 17258 depends on bug 17860, which changed state.

Bug 17860 Summary: MARC records will stage, but Manage for import shows 'no data in table'
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMNIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258
Bug 17258 depends on bug 17860, which changed state.

Bug 17860 Summary: [SQL strict mode] MARC records will stage, but Manage for import shows 'no data in table'
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|FIXED                       |---

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMNIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Marjorie Barry-Vila <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |marjorie.barry-vila@collect
                   |                            |o.ca

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMNIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

--- Comment #7 from Jonathan Druart <[hidden email]> ---
Since MySQL 5.7 and MariaDB 10.2.4, the default value for SQL modes is

MySQL:
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

MariaDB:
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

[Bug 17258] [OMNIBUS] MySQL 5.7

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

Jonathan Druart <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |19248


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19248
[Bug 19248] install.pl: DBD::mysql::st execute failed
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
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/
123