[Koha] web installer appears on upgrade

[Fridolin SOMERS]

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

-- 
Fridolin SOMERS <fridolin.somers at biblibre.com>
Software and system maintainer 🦄
BibLibre, France