[Koha] Database error with 22.11 update

Mon Dec 19 20:31:37 NZDT 2022

Hi,

I believe this issue will be fixed in 22.11.01:

*Bug 32470*
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32470> - (Bug
14783 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14783>
follow-up) Fix mysql error in db_rev for 22.06.000.064

Hope this helps,

Katrin

On 16.12.22 00:07, kolvir73 wrote:
> MySQL 8.0.31-0ubuntu0.22.04.1
>
> On Dec 11, 2022, 9:44 PM, at 9:44 PM, kolvir73<kolvir73 at gmail.com>  wrote:
>> Sorry, I read that wrong and missed the 'version' after MySQL. I don't
>> have access to the server at the moment. I am running the latest
>> version of mint, however.
>>
>> On Dec 11, 2022, 7:38 PM, at 7:38 PM, Tomas Cohen Arazi
>> <tomascohen at gmail.com>  wrote:
>>> Can you tell us more about the database engine (MariaDB/MySQL)
>> version?
>>> Maybe the OS as well
>>>
>>> El dom, 11 dic 2022 21:39, kolvir73<kolvir73 at gmail.com>  escribió:
>>>
>>>> I'm getting the following while trying to upgrade, but typing this
>>> out I
>>>> just noticed the 'upgrade to 22.06.00.064' at the start. It that an
>>> issue
>>>> in itself?
>>>>
>>>>
>>>> Upgrade to 22.06.00.064 [13:41:05]: Bug 14783 - Allow patrons to
>>> change
>>>> pickup location for non-waiting holds
>>>> ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You can't
>>>> specify target table 'systempreferences' for update in FROM clause
>> at
>>>> /usr/share/koha/lib/C4/Installer.pm line 739
>>>> Added new system preference 'OPACAllowUserToChangeBranch'
>>>> ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You can't
>>>> specify target table 'systempreferences' for update in FROM clause
>> at
>>>> /usr/share/koha/lib/C4/Installer.pm line 739
>>>>
>>>>
>>>> On Dec 11, 2022, 5:01 PM, at 5:01 PM,
>> koha-request at lists.katipo.co.nz
>>>> wrote:
>>>>> Send Koha mailing list submissions to
>>>>>        koha at lists.katipo.co.nz
>>>>>
>>>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>>>        https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>> or, via email, send a message with subject or body 'help' to
>>>>>        koha-request at lists.katipo.co.nz
>>>>>
>>>>> You can reach the person managing the list at
>>>>>        koha-owner at lists.katipo.co.nz
>>>>>
>>>>> When replying, please edit your Subject line so it is more specific
>>>>> than "Re: Contents of Koha digest..."
>>>>>
>>>>>
>>>>> Today's Topics:
>>>>>
>>>>>    1. Re: Find and searching result (Katrin Fischer)
>>>>>    2. Re: Item display status text (Katrin Fischer)
>>>>>
>>>>>
>>>> ----------------------------------------------------------------------
>>>>> Message: 1
>>>>> Date: Sun, 11 Dec 2022 14:42:06 +0100
>>>>> From: Katrin Fischer<katrin.fischer.83 at web.de>
>>>>> To:koha at lists.katipo.co.nz
>>>>> Subject: Re: [Koha] Find and searching result
>>>>> Message-ID:<ef8c99d7-d155-1af4-6093-bbb7007f0a17 at web.de>
>>>>> Content-Type: text/plain; charset=UTF-8; format=flowed
>>>>>
>>>>> Hi Tony
>>>>>
>>>>> are you using Zebra?
>>>>>
>>>>> If you don't want Zebra to interpret and, or and not as boolean
>>>>> operators, you can use quotes around your query:
>>>>> "Philosophy and education George Knight"
>>>>>
>>>>> Hope this helps,
>>>>>
>>>>> Katrin
>>>>>
>>>>>
>>>>> On 09.12.22 08:46, Toni Afandi wrote:
>>>>>> Dear all,
>>>>>>
>>>>>> We have this book Philosophy and education : an introduction in
>>>>> Christian
>>>>>> perspective / George R. Knight in our
>>>>>>
>>>>>> If we input these keywords on our OPAC : *Philosophy and
>> education
>>>>> George
>>>>>> Knight*
>>>>>> we will get no result : No results found!
>>>>>>
>>>>>> But if we remove "and" word, we get the results.
>>>>>>
>>>>>> What do you think? Thank you.
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> *Toni Afandi*
>>>>>> *Librarian*
>>>>>> *STT SAAT*
>>>>>> *(Southeast Asia Bible Seminary)*
>>>>>> Jl. Bukit Hermon No 1, Tidar Atas
>>>>>> Malang, Jawa Timur 65151
>>>>>> Indonesia
>>>>>> www.seabs.ac.id
>>>>>> _______________________________________________
>>>>>>
>>>>>> Koha mailing listhttp://koha-community.org
>>>>>> Koha at lists.katipo.co.nz
>>>>>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>> ------------------------------
>>>>>
>>>>> Message: 2
>>>>> Date: Sun, 11 Dec 2022 15:11:20 +0100
>>>>> From: Katrin Fischer<katrin.fischer.83 at web.de>
>>>>> To:koha at lists.katipo.co.nz
>>>>> Subject: Re: [Koha] Item display status text
>>>>> Message-ID:<b2dd3c49-e248-97d9-378d-419ffa7dabd1 at web.de>
>>>>> Content-Type: text/plain; charset=UTF-8; format=flowed
>>>>>
>>>>> Hi Atron,
>>>>>
>>>>> which version of Koha are you using?
>>>>>
>>>>> I also checked translations for some versions, but couldn't see
>>>>> anything
>>>>> that would explain the extra ().
>>>>>
>>>>> Could you check if they are maybe added in the authorised value? Go
>>> to:
>>>>> administration > authorised values > NOT_LOAN and check the
>>>>> descriptions
>>>>> entered there.
>>>>>
>>>>> Hope this helps,
>>>>>
>>>>> Katrin
>>>>>
>>>>> On 08.12.22 10:58, 陳世強 wrote:
>>>>>> Dear All,
>>>>>>
>>>>>> After I changed the 952$7 subfield of the items to "Not For
>>>>> Loan"(Chicese
>>>>>> mean "不外借"),
>>>>>> The status text of the item is displayed as "不外借 ()(不外借)" in the
>>>>> Chinese
>>>>>> page(attached picture1),
>>>>>> But that "()" is extra and unnecessary, it should be displayed as
>>>>> "Not for
>>>>>> loan (不外借)" like the English page(attached picture2).
>>>>>> I went to Koha Translation website to check, but I didn't see any
>>>>>> translation with the extra "()", how can I make it display as
>> "不外借
>>>>> (不外借)" ?
>>>>>> Sincerely,
>>>>>>
>>>>>> Atron Chen
>>>>>> _______________________________________________
>>>>>>
>>>>>> Koha mailing listhttp://koha-community.org
>>>>>> Koha at lists.katipo.co.nz
>>>>>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>> ------------------------------
>>>>>
>>>>> Subject: Digest Footer
>>>>>
>>>>> _______________________________________________
>>>>> Koha mailing list
>>>>> Koha at lists.katipo.co.nz
>>>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>
>>>>>
>>>>> ------------------------------
>>>>>
>>>>> End of Koha Digest, Vol 206, Issue 11
>>>>> *************************************
>>>> _______________________________________________
>>>>
>>>> Koha mailing listhttp://koha-community.org
>>>> Koha at lists.katipo.co.nz
>>>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>
> _______________________________________________
>
> Koha mailing listhttp://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha