After enabling multilingual site, DB error 'underlying table doesn't have a default value' prevents saving any future language settings or enable extensions

I have a brand new install, WordPress with CiviCRM 5.26.0 (originally tested with 5.24.6 with the same issue)

Once I enable multilingual and install an additional language I am no longer able to make any additional changes to the localization page, I can't even save the page with no changes, without getting the error "DB Error: unknown error", I am also unable to enable a new extension. Backtrace: backtrace.txt

[debug_info] => INSERT INTO civicrm_option_value_en_CA (option_group_id , label , value , is_default , weight , is_active ) VALUES ( 103 , 'CAD ($)' , 'CAD' , 1 , 1 , 1 ) [nativecode=1423 ** Field of view 'example_db.civicrm_option_value_en_CA' underlying table doesn't have a default value]

In addition, the 'Available Currency' field has been erased, attempting to re-add a currency gives error: "DB Error: already exists" Backtrace: backtrace_duplicate.txt

[debug_info] => INSERT INTO civicrm_option_group_en_CA (name , title , is_reserved , is_active ) VALUES ('currencies_enabled' , 'currencies_enabled' , 1 , 1 ) [nativecode=1062 ** Duplicate entry 'currencies_enabled' for key 'UI_name']

The view and table listed in the errors always correspond to the default language, whether it's set to en_CA or en_US.

(disabling SQL STRICT mode is not an option)

Thanks!