Bug: Database upgrade fails on shared hosting 5.7.0 to 5.8.0

[respencer]

Description

A clear and concise description of what the reported bug is:

• ChurchCRM version: 5.8.0
• PHP version the server running: PHP 8.2
• DB Server and Version the server is running: 10.3.39-MariaDB-cll-lve

Steps To Reproduce

Steps to reproduce the behavior:

Go through the upgrade process until you get to database update button. Click it and you are stuck there.

Expected behavior

Expected a smooth upgrade.

Screenshots and/or logs

If applicable, please include screenshots or share logs to assist in explaining your issue.

📋 Relevant screenshots:

📋 Logs:

[2024-05-20T11:27:05.736527+00:00] defaultLogger.ERROR: Failure executing upgrade script(s): SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP COLUMN `event_typename`; check that it exists {"exception":"[object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP COLUMN `event_typename`; check that it exists at /home/user/church.example.com/vendor/propel/propel/src/Propel/Runtime/Connection/PdoConnection.php:134)","scriptName":"/home/user/church.example.com/mysql/upgrade/5.8.0.sql","version":"5.8.0","numUpgradeScriptsExecuted":0} {"url":"/SystemDBUpdate.php?upgrade=true","remote_ip":"*","correlation_id":"664b3389abc68"}

Debugging Steps

ℹ️ If you need help debugging, please refer to the wiki for guidance: https://github.com/ChurchCRM/CRM/wiki/Logging-and-Diagnostics.

• What has been done to debug the issue so far?
• Have you looked at the browser's developer tools to see if an error is thrown / network request failed?
• Are there any associated error logs on the backend that get emitted when you attempt to do this action?

Desktop (please complete the following information):

• OS and Version: Rolling Arch Linux release 64bit
• Browser (and Version): Firefox 125.0.3 (64-bit)

[respencer]

Ignore. Looks like a self inflicted shot in the foot.

6957