<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:DengXian;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"\@DengXian";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
h1
{mso-style-priority:9;
mso-style-link:"Heading 1 Char";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:24.0pt;
font-family:"Calibri",sans-serif;
font-weight:bold;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
font-size:10.0pt;
font-family:"Courier New";}
span.Heading1Char
{mso-style-name:"Heading 1 Char";
mso-style-priority:9;
mso-style-link:"Heading 1";
font-family:"Calibri Light",sans-serif;
color:#2F5496;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang="EN-AU" link="blue" vlink="purple" style="word-wrap:break-word">Yeah the first way is pretty much how I fixed it. I don't really like it though I think changing the table name is a better idea. So hopefully that will be the long term fix.<br><br>Good news about the release, we are on 5.0.6 plus koha customisations, I'll merge 5.2 in when it's released and we will go to that. <br><br><br><br>Chris <br><br><br><div class="gmail_quote">On 4 January 2023 11:41:28 am NZDT, David Cook <dcook@prosentient.com.au> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="WordSection1"><p class="MsoNormal">It looks like they might have a new version coming out in a few weeks: <a href="https://www.bugzilla.org/blog/2022/12/13/upcoming-releases-and-more-fun-stuff/">https://www.bugzilla.org/blog/2022/12/13/upcoming-releases-and-more-fun-stuff/</a><o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal">Looks like someone has a PR for the MySQL/MariaDB issue: <a href="https://github.com/bugzilla/bugzilla/pull/107/files">https://github.com/bugzilla/bugzilla/pull/107/files</a> <o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal">Also looks like Mozilla have gone a different route with their Bugzilla fork:<o:p></o:p></p><p class="MsoNormal"><a href="https://github.com/mozilla-bteam/bmo/commit/5dc1b8c85c4e90c3467fd82cab9fca05fe2be74a">https://github.com/mozilla-bteam/bmo/commit/5dc1b8c85c4e90c3467fd82cab9fca05fe2be74a</a><o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal"><o:p> </o:p></p><div><p class="MsoNormal">David Cook<o:p></o:p></p><p class="MsoNormal">Senior Software Engineer<o:p></o:p></p><p class="MsoNormal">Prosentient Systems<o:p></o:p></p><p class="MsoNormal">Suite 7.03<o:p></o:p></p><p class="MsoNormal">6a Glen St<o:p></o:p></p><p class="MsoNormal">Milsons Point NSW 2061<o:p></o:p></p><p class="MsoNormal">Australia<o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal">Office: 02 9212 0899<o:p></o:p></p><p class="MsoNormal">Online: 02 8005 0595<o:p></o:p></p></div><p class="MsoNormal"><o:p> </o:p></p><div><div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Koha-devel <koha-devel-bounces@lists.koha-community.org> <b>On Behalf Of </b>Chris Cormack<br><b>Sent:</b> Wednesday, 4 January 2023 4:54 AM<br><b>To:</b> koha-devel@lists.koha-community.org; Tomas Cohen Arazi <tomascohen@gmail.com>; David Nind <david@davidnind.com><br><b>Cc:</b> Koha-devel <koha-devel@lists.koha-community.org>; koha-user <koha@lists.katipo.co.nz><br><b>Subject:</b> Re: [Koha-devel] Upgrading bugs.koha-community.org (plus others)<o:p></o:p></span></p></div></div><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal" style="margin-bottom:12.0pt">The DB hasnt changed at all, mysql versions have. So they will have to be fixed manually.<br>There are some table names that are now reserved words in mysql so need to be back ticked. Please send the errors to me so I can fix.<br><br>Bugzilla isn't really being actively maintained anymore so I will have to fix these. There is no version to upgrade to.<br><br>Chris <o:p></o:p></p><div><p class="MsoNormal">On 4 January 2023 6:44:23 am NZDT, Tomas Cohen Arazi <<a href="mailto:tomascohen@gmail.com">tomascohen@gmail.com</a>> wrote:<o:p></o:p></p><blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm"><div><p class="MsoNormal">I've seen some errors on saved reports. But it looks like DB structure changes won't be easy to fix manually.<o:p></o:p></p></div><p class="MsoNormal"><o:p> </o:p></p><div><div><p class="MsoNormal">El mar, 3 ene 2023 a las 14:43, David Nind (<<a href="mailto:david@davidnind.com">david@davidnind.com</a>>) escribió:<o:p></o:p></p></div><blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm"><div><div><div><p class="MsoNormal">Hi Chris.<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">Thanks for all your work in supporting and maintaining these!<o:p></o:p></p></div><div><p class="MsoNormal"><o:p> </o:p></p></div><div><p class="MsoNormal">I get this message when trying to access the IRC logs at <a href="http://irc.koha-community.org/koha/today" target="_blank">http://irc.koha-community.org/koha/today</a><o:p></o:p></p></div><div><h1>Software error:<o:p></o:p></h1><pre>Can't locate Date/Simple.pm in @INC (you may need to install the Date::Simple module) (@INC contains: /home/chrisc/ilbot/lib/ /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.30.0 /usr/local/share/perl/5.30.0 /usr/lib/x86_64-linux-gnu/perl5/5.30 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.30 /usr/share/perl/5.30 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base) at /home/chrisc/ilbot/cgi/<a href="http://out.pl" target="_blank">out.pl</a> line 6.<o:p></o:p></pre><pre>BEGIN failed--compilation aborted at /home/chrisc/ilbot/cgi/<a href="http://out.pl" target="_blank">out.pl</a> line 6.<o:p></o:p></pre><p>For help, please send mail to the webmaster (<a href="mailto:chris@bigballofwax.co.nz" target="_blank">chris@bigballofwax.co.nz</a>), giving this error message and the time and date of the error. <o:p></o:p></p><p>There are also server errors when accessing some of the links from <a href="http://irc.koha-community.org/" target="_blank">http://irc.koha-community.org/</a><o:p></o:p></p><p>David<o:p></o:p></p></div></div><p class="MsoNormal"><o:p> </o:p></p></div><p class="MsoNormal">_______________________________________________<br>Koha-devel mailing list<br><a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br><a href="https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>website : <a href="https://www.koha-community.org/" target="_blank">https://www.koha-community.org/</a><br>git : <a href="https://git.koha-community.org/" target="_blank">https://git.koha-community.org/</a><br>bugs : <a href="https://bugs.koha-community.org/" target="_blank">https://bugs.koha-community.org/</a><o:p></o:p></p></blockquote></div><p class="MsoNormal"><br clear="all"><o:p></o:p></p><div><p class="MsoNormal"><o:p> </o:p></p></div></blockquote></div></div></blockquote></div></body></html>