[Bug 26112] New: Errors in marc21_authorities files for uk-UA

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

[Bug 26112] New: Errors in marc21_authorities files for uk-UA

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

            Bug ID: 26112
           Summary: Errors in marc21_authorities files for uk-UA
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Installation and upgrade (web-based installer)
          Assignee: [hidden email]
          Reporter: [hidden email]
        QA Contact: [hidden email]
                CC: [hidden email]

Created attachment 107630
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=107630&action=edit
uk-UA fixed queries for default authority

Upon fresh install when I choose to add authorities, the following error shows
near every authorities file

 install.pl: DBD::mysql::st execute failed: Incorrect integer value: '' for
column `koha_sql`.`auth_tag_structure`.`repeatable` at row 1

After completing install, I tried executing those SQL commands in phpmyadmin
and it seems that in mandatory and repeatable columns have values '' or 1. I
tried replacing those empty strings with zero and it worked.

Seems like each SQL query in those files should be checked and columns
mandatory, repeatable should only have values 0 or 1 as it is type tinyint(4).

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
https://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 26112] Errors in marc21_authorities files for uk-UA

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

Bohdan <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Assignee|[hidden email]-commun |[hidden email]
                   |ity.org                     |
             Status|NEW                         |ASSIGNED

--- Comment #1 from Bohdan <[hidden email]> ---
Created attachment 107637
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=107637&action=edit
Patch for uk-UA fix of authority SQL queries

Could not upload unzipped, got 413 nginx error for some reason

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
https://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 26112] Errors in marc21_authorities files for uk-UA

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

Bohdan <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #107637|0                           |1
        is obsolete|                            |

--- Comment #2 from Bohdan <[hidden email]> ---
Created attachment 107638
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=107638&action=edit
Patch for uk-UA fix of authority SQL queries

Could not upload as patch, got 413 error

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
https://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 26112] Errors in marc21_authorities files for uk-UA

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

Bohdan <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ASSIGNED                    |NEW

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
https://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 26112] Errors in marc21_authorities files for uk-UA

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

Bohdan <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |Needs Signoff

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
https://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 26112] Errors in marc21_authorities files for uk-UA

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

Martin Renvoize <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Signed Off
                URL|                            |https://github.com/mrenvoiz
                   |                            |e/Koha/tree/bug_26112
                 CC|                            |martin.renvoize@ptfs-europe
                   |                            |.com

--- Comment #3 from Martin Renvoize <[hidden email]> ---
I have uploaded a signed off patch to a branch here:
https://github.com/mrenvoize/Koha/tree/bug_26112

I'm afraid I don't speak the language, but the files apply and run so I'm happy
to signoff.

Thankyou for the contribution.

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
https://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 26112] Errors in marc21_authorities files for uk-UA

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

Martin Renvoize <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #107638|0                           |1
        is obsolete|                            |

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
https://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 26112] Errors in marc21_authorities files for uk-UA

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

Martin Renvoize <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #107630|0                           |1
        is obsolete|                            |

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
https://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 26112] Errors in marc21_authorities files for uk-UA

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

Katrin Fischer <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Passed QA
                URL|https://github.com/mrenvoiz |https://gitlab.com/kfischer
                   |e/Koha/tree/bug_26112       |1/Koha/-/tree/bug_26112

--- Comment #4 from Katrin Fischer <[hidden email]> ---
Replacing Martin's with my local branch - includes a tiny follow-up :)

https://gitlab.com/kfischer1/Koha/-/tree/bug_26112

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
https://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/