Can't save event when logging is activated because DB-row event_tz_bak is too large
CiviCRM 5.57.0, Drupal 7.92, PHP 8.1, MariaDB, logging activated.
Install of CiviMobileAPI 6.1.1 didn't finished completely, updating DB to revision 15 failed. Skipping this was no problem.
I wasn't able to save a new event after this. Error message mentioned row event_tz_bak, which in fact wasn't there. Timezones were changed in CiviCRM recently, maybe this is related? https://lab.civicrm.org/dev/core/-/wikis/CiviEvent-v5.47-Timezone-Notice
Disabling logging fixed this for me.
+++ Error message +++
`Jan 17 13:28:41 [error] $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler )
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => ALTER TABLE drupal_db
.log_civicrm_event ADD event_tz_bak
text DEFAULT NULL COMMENT 'For troubleshooting upgrades post 5.47. Can drop this column if no issues.' [nativecode=1118 ** Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
[type] => DB_Error
[user_info] => ALTER TABLE drupal_db
.log_civicrm_event ADD event_tz_bak
text DEFAULT NULL COMMENT 'For troubleshooting upgrades post 5.47. Can drop this column if no issues.' [nativecode=1118 ** Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="ALTER TABLE drupal_db
.log_civicrm_event ADD event_tz_bak
text DEFAULT NULL COMMENT 'For troubleshooting upgrades post 5.47. Can drop this column if no issues.' [nativecode=1118 ** Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]"]
)`