[Koha] web installer appears on upgrade

[Daniel Owens]

Okay, will do. Thanks.

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
>