Max Depth:

Bug 17258 depends on 86 bugs:

view as bug list

•    17258: [OMNIBUS] MySQL 5.7 [NEW; assigned to jonathan.druart]
  •    17306: Update scripts fail with Mysql 5.7 [NEW; assigned to gmcharlt]
  •    17354: Group By/Order By SQL mismatch in issues_stats.pl [NEW; assigned to gmcharlt]
  •    21941: Incorrect GROUP BY in circ/reserveratios.pl [NEW; assigned to koha-bugs]
  •    23360: Move reserveratios to a module and refactor to avoid problems with strict mode [NEW; assigned to koha-bugs]
    •    15422: Number of items to order on holds ratio report will not fulfill the holds ratio [CLOSED FIXED; assigned to nick]
  •    28012: Error on saving new numbering pattern [Pushed to oldstable; assigned to joonas.kylmala]
    •    31297: Cannot add new subscription patterns from edit subscription page [Pushed to oldstable; assigned to nick]
  •    29818: Cannot save subscription frequency without display order [Pushed to main; assigned to phil]
  •    31297: Cannot add new subscription patterns from edit subscription page [Pushed to oldstable; assigned to nick] (*)
  •    31578: "Patrons who haven't checked out" report broken with SQL strict mode enabled [NEW; assigned to koha-bugs]
  •    32116: "Patrons with the most checkouts" report (bor_issues_top.pl) broken with SQL strict mode enabled [NEW; assigned to koha-bugs]
  •    32117: "Items with no checkouts" report (catalogue_out.pl) broken with SQL strict mode enabled [NEW; assigned to koha-bugs]
  •    6993: Incorrect data type in auth_subfield_structure [RESOLVED DUPLICATE; assigned to gmcharlt]
  •    13669: Web installer fails to load sample data on MySQL 5.6+ [CLOSED FIXED; assigned to tomascohen]
  •    14637: Add patron category fails with MySQL 5.6.26 [CLOSED FIXED; assigned to jonathan.druart]
  •    15819: Error when edit borrowers "There are no patron categories defined" but categories exists [CLOSED FIXED; assigned to koha-bugs]
  •    16094: error editing (borrowers, reports) with mysql enterprise [RESOLVED DUPLICATE; assigned to koha-bugs]
  •    16402: DB structure cannot be loaded in MySQL 5.7 [CLOSED FIXED; assigned to jonathan.druart]
  •    16554: Web installer fails to load i18n sample data on MySQL 5.6+ [CLOSED FIXED; assigned to bgkriegel]
    •    16573: Web installer fails to load structure and sample data on MySQL 5.7 [CLOSED FIXED; assigned to bgkriegel]
  •    16573: Web installer fails to load structure and sample data on MySQL 5.7 [CLOSED FIXED; assigned to bgkriegel] (*)
  •    16583: Strangeness in the staff client on ubuntu 16.04 and MySQL 5.7 [CLOSED FIXED; assigned to koha-bugs]
  •    16858: import_borrowers.pl does not load because of mysql 5.7 [RESOLVED DUPLICATE; assigned to gmcharlt]
  •    17234: ALTER IGNORE TABLE is invalid in mysql 5.7. This breaks updatedatabase.pl [CLOSED FIXED; assigned to philippe.blouin]
  •    17257: Cannot create a patron under MySQL 5.7 [CLOSED FIXED; assigned to jonathan.druart]
  •    17260: updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns [CLOSED FIXED; assigned to philippe.blouin]
  •    17320: MySQL 5.7 doesn't work well with SQL using '0000-00-00' [CLOSED FIXED; assigned to mtompset]
  •    17323: MySQL 5.7 - Column search_history.time cannot be null [CLOSED FIXED; assigned to jonathan.druart]
  •    17324: branchcode is NULL in letter triggers red upgrade message [CLOSED FIXED; assigned to mtompset]
  •    17328: Koha fixes for Mysql 5.7 [RESOLVED DUPLICATE; assigned to philippe.blouin]
  •    17860: [SQL strict mode] MARC records will stage, but Manage for import shows 'no data in table' [RESOLVED DUPLICATE; assigned to gmcharlt]
  •    18836: MySQL 5.7 - Table 'koha_library.club_enrollments' doesn't exist [RESOLVED DUPLICATE; assigned to koha-bugs]
    •    12461: Add patron clubs feature [CLOSED FIXED; assigned to kyle]
      •    18171: Patron Clubs feature breaks logging in/display of logged in users [CLOSED INVALID; assigned to oleonard]
  •    19248: install.pl: DBD::mysql::st execute failed [CLOSED INVALID; assigned to koha-bugs]
  •    19492: Field 'lowestPriority' doesn't have a default value (MariaDB) [RESOLVED DUPLICATE; assigned to koha-bugs]
  •    20144: Test suite is failing with new default SQL modes [CLOSED FIXED; assigned to jonathan.druart]
  •    20175: Set a correct default value for club_enrollments.date_created [CLOSED FIXED; assigned to jonathan.druart]
  •    20176: Set biblio.datecreated to NOW if not defined [CLOSED FIXED; assigned to jonathan.druart]
  •    20177: Remove GROUP BY clause in GetCourses [CLOSED FIXED; assigned to jonathan.druart]
  •    20179: Remove GROUP BY in get_shelves_containing_record [CLOSED FIXED; assigned to jonathan.druart]
  •    20180: Remove GROUP BY clause in manage-marc-import.pl [CLOSED FIXED; assigned to jonathan.druart]
  •    20182: Remove group by clause in search_patrons_to_anonymise [CLOSED FIXED; assigned to jonathan.druart]
  •    20229: Remove problematic SQL modes [CLOSED FIXED; assigned to jonathan.druart]
  •    21601: Cannot create lists [RESOLVED DUPLICATE; assigned to jonathan.druart]
  •    21603: Incorrect GROUP BY clause in SearchCourses [CLOSED FIXED; assigned to jonathan.druart]
  •    21604: Cannot add/edit funds, cannot add budgets [CLOSED FIXED; assigned to jonathan.druart]
  •    21605: Cannot create EDI account [CLOSED FIXED; assigned to colin.campbell]
  •    21606: Issues with matching rules [CLOSED FIXED; assigned to jonathan.druart]
  •    21610: Koha::Object->store needs to handle incorrect values [CLOSED FIXED; assigned to jonathan.druart]
  •    21612: Incorrect GROUP BY in Koha::Virtualshelves [CLOSED FIXED; assigned to jonathan.druart]
  •    21621: Incorrect GROUP BY in tools/letter.pl [CLOSED FIXED; assigned to jonathan.druart]
  •    21622: Incorrect GROUP BY clause in acqui/ scripts [CLOSED FIXED; assigned to jonathan.druart]
  •    21635: Incorrect GROUP BY clause in batchMod.pl [CLOSED FIXED; assigned to jonathan.druart]
  •    21714: Unable to view vendor with strict_sql_modes enabled [RESOLVED DUPLICATE; assigned to martin.renvoize]
    •    21385: Vendor search: Item count is incorrectly updated on partial receive [CLOSED FIXED; assigned to martin.renvoize]
  •    21718: Lists of pending/received orders for a fund explodes with strict modes active [RESOLVED DUPLICATE; assigned to koha-bugs]
  •    21725: Incorrect HAVING in group by in Acquisitions.pm [CLOSED FIXED; assigned to nick]
  •    22431: Holds to pull report is broken in sql strict mode [RESOLVED DUPLICATE; assigned to koha-bugs]
    •    13640: Holds To Pull List includes items unreserveable items [CLOSED FIXED; assigned to jonathan.druart]
  •    22812: Cannot add new subscription with strict SQL modes turned on [CLOSED FIXED; assigned to jonathan.druart]
  •    22878: Cannot add a patron card layout with mysql strict mode on [CLOSED FIXED; assigned to jonathan.druart]
  •    22907: Cannot add new suggestion with strict SQL modes turned on [CLOSED FIXED; assigned to jonathan.druart]
    •    12627: SQLHelper replacement - C4::Suggestions [CLOSED FIXED; assigned to jonathan.druart]
      •    12445: C4::Suggestions.pm needs more unit tests [CLOSED FIXED; assigned to yohann.dufour]
    •    22908: Modsuggestion will generate a notice even if the modification failed [CLOSED FIXED; assigned to jonathan.druart]
      •    21241: Set suggestion notices message_transport_type to sms if syspref is enabled and patron has an smsalertnumber but no email address [CLOSED FIXED; assigned to alexbuckley]
  •    22919: Authorities MARC Structure not inserted with SQL strict modes [CLOSED FIXED; assigned to jonathan.druart]
  •    23064: Cannot edit subscription with strict SQL modes turned on [CLOSED FIXED; assigned to jonathan.druart]
  •    23242: Error when adding new Z39.50/SRU server in DB strict mode [CLOSED FIXED; assigned to jonathan.druart]
  •    23309: Can't add new subfields to bibliographic frameworks in strict mode [CLOSED FIXED; assigned to jonathan.druart]
  •    23430: News not inserted with SQL strict modes [RESOLVED DUPLICATE; assigned to koha-bugs]
  •    23709: Can't add new subfields to bibliographic frameworks [CLOSED INVALID; assigned to koha-bugs]
    •    23309: Can't add new subfields to bibliographic frameworks in strict mode [CLOSED FIXED; assigned to jonathan.druart] (*)
  •    24001: Cannot edit card template [CLOSED FIXED; assigned to alexis.ripetti]
  •    24137: Marc21 bibliographic fails to install for ru-Ru and uk-UA [CLOSED FIXED; assigned to jonathan.druart]
  •    24328: Bibliographic frameworks fail to install [CLOSED FIXED; assigned to jonathan.druart]
    •    24312: Update MARC21 frameworks to Updates 28+29 (May and November 2019) [CLOSED FIXED; assigned to bgkriegel]
    •    24314: Update de-DE MARC21 frameworks for updates 28+29 (May and November 2019) [CLOSED FIXED; assigned to katrin.fischer]
      •    24312: Update MARC21 frameworks to Updates 28+29 (May and November 2019) [CLOSED FIXED; assigned to bgkriegel] (*)
  •    24742: Can't save news item in strict mode without value in number field [RESOLVED DUPLICATE; assigned to koha-bugs]
  •    24940: Serials statistics wizard: order vendor list alphabetically [CLOSED FIXED; assigned to david.roberts]
  •    25335: Use of an authorised value in a marc subfield causes strict mode SQL error [CLOSED FIXED; assigned to andrew]
  •    26090: Catalog by itemtype report fails if SQL strict mode is on [CLOSED FIXED; assigned to jonathan.druart]
  •    27276: borrowers-force-messaging-defaults throws Incorrect DATE value: '0000-00-00' even though sql strict mode is dissabled [CLOSED FIXED; assigned to jonathan.druart]
  •    27498: Add a link for the hold ratios to acquisitions home page [CLOSED FIXED; assigned to oleonard]
  •    27968: MARC framework CSV and ODS import incomplete or corrupted [CLOSED FIXED; assigned to jonathan.druart]
  •    28152: Hidden error when importing an item with an existing itemnumber [CLOSED FIXED; assigned to jonathan.druart]
  •    28207: Crash when seeing MARC structure of a new framework [CLOSED FIXED; assigned to jonathan.druart]
  •    30369: Downloading records for inbuilt offline circulation fails with strict SQL setting [RESOLVED DUPLICATE; assigned to koha-bugs]

Bug 17258 does not block any bugs.

Max Depth:

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    [x]
  • | Forgot Password
    Login: [x]