[Koha] web installer appears on upgrade

[Katrin Fischer]

Hi Daniel,

I think this got lost when we had a bit of trouble with the mailing list.

Were you able to resolve your issue?

While we are working on the fix, the workaround suggested on the bug
might help you to finish the update:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34516#c2

Katrin

On 14.08.23 23:44, Daniel Owens wrote:
> I opened a bug report, but I imagine it will take awhile before this
> is fixed. Is there any documentation about how to downgrade on Linux
> (Ubuntu)? I do have a backup.
>
> Daniel
>
> On 8/10/23 4:09 PM, Fridolin SOMERS wrote:
>> On 22.11.x index on publishercode seems OK :
>>   KEY `publishercode` (`publishercode`(191)),
>>
>> The size on index has been added by :
>> Bug 18336: Convert schema from utf8 to utf8mb4
>>
>> I've look at old databases, the index is OK.
>>
>> Please open a bug report.
>>
>> Best regards
>>
>> Le 10/08/2023 à 04:43, Daniel Owens a écrit :
>>> This worked the last time I had the problem, but with the latest
>>> upgrade I got the web installer again. After running:
>>>
>>> $ sudo service memcached restart
>>> $ sudo koha-upgrade-schema hbc
>>>
>>> Upgrading database schema for hbc
>>> Upgrade to 22.11.07.003  [14:01:47]: Bug 34029 - Extend datatypes in
>>> biblioitems and deletedbiblioitems tables to avoid import errors
>>>      Updated biblioitems.place to text
>>>      Updated deletedbiblioitems.place to text
>>> ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed:
>>> BLOB/TEXT column 'publishercode' used in key specification without a
>>> key length at /usr/share/koha/lib/C4/Installer.pm line 741
>>>
>>> Can anyone give me a pointer about where to go from here?
>>>
>>> Daniel
>>>
>>> On 7/11/23 10:18 AM, Bruns, Anke wrote:
>>>> Hi,
>>>>
>>>> in our case, when this occurs, the solution is usually to restart
>>>> the memcached and then perform koha-upgrade-schema <instance>.
>>>>
>>>> Hope this helps.
>>>>
>>>> Best regards,
>>>> Anke
>>>>
>>>>
>>> _______________________________________________
>>>
>>> Koha mailing list http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha