Bug 28471

Summary: koha-dump --schema-only does not work with mysqldump 8
Product: Koha Reporter: Jonathan Druart <jonathan.druart>
Component: Architecture, internals, and plumbingAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 26947    
Bug Blocks:    

Description Jonathan Druart 2021-05-27 10:13:00 UTC
With focal

  mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'koha_kohadev' AND TABLE_NAME = 'account_credit_types';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

But adding --column-statistics=0 (like suggested over the web) will break the command when run with a lower version

  mysqldump: unknown variable 'column-statistics=0'
Comment 1 Katrin Fischer 2023-07-01 09:47:02 UTC
Hm, the versions here are quite old now - can we tell if this is still a problem?