Re: [Koha-devel] Synchronizing a Koha database with kohastructure.sql (Bug 34064)

2023-06-20 Thread David Cook
I thought about using the DBIx::Class files, but that gets messy on a server with many Koha databases, which all have their own upgrade histories. The DBIx::Class files also don't include all database information. I wanted a solution that could analyse and compare for me in a production

Re: [Koha-devel] Synchronizing a Koha database with kohastructure.sql (Bug 34064)

2023-06-20 Thread Marcel de Rooy
We already have misc/devel/update_dbix_class_files.pl. Copy your Koha/Schema/Result before running. Or run it on a gitified install. Compare changes. Van: David Cook Verzonden: dinsdag 20 juni 2023 06:36 Aan: 'koha-devel' CC: Marcel de Rooy ; 'Tomas Cohen Arazi'

[Koha-devel] Synchronizing a Koha database with kohastructure.sql (Bug 34064)

2023-06-19 Thread David Cook
Hi all, I think we've all encountered issues with a Koha database being out of sync with kohastructure.sql, and it's not a fun experience to have. Today, I ran into items.paidfor columns that have survived long past a 20.11.00 upgrade. While looking to resolve that across all my instances, I