[Koha] Follow up problem with bug number 30912

[Katrin Fischer]

Hi Keith,

have you been able to solve this problem yet?

It looks like the database update ran half-way before, as it's supposed
to add and remove the temp column:

https://git.koha-community.org/Koha-community/Koha/src/commit/5e5b642067bb108e4270aa8d5aab130ab3403be8/installer/data/mysql/db_revs/211200016.pl#L21

I think you might have to remove the temp column before rerunning the
database update, but it might be better to go back to a backup and rerun
with the corrected database update.

Someone else might be able to give more insight.

Hope that helps

Katrin


On 12.06.22 10:27, Keith Sorbo wrote:
> I was having problems updating that seemed, initially, to be resolved when
> I applied the changes made for bugfix 30912 (
> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=135958).
>
> I ran the web update and it timed out several times on the Updating
> Database Structure step.
>
> Now I am getting the following error message. My installation is out of
> service until I can resolve this issue.
>
> Thanks!
>
> Updating database structure
>
> Update errors :
>
>     - Upgrade to 21.12.00.016 [08:20:36]: Bug 30060 - Update
>     user_permissions to add primary key and remove null option from code column
>     ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate
>     column name 'temp' at /usr/share/koha/lib/C4/Installer.pm line 739
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha