Can't Update UNA, Database errors due to Classes App
Help please! I cannot update my site, and there are constant database errors. As far as I can tell, this began in April 2024, when I tried to install UNA Classes from the Apps store. We were not able to fix the issue completely, there were still errors, but the site worked despite the errors so I decided to hold off trying to fix it further until 14.0.0 stable was released.
Now I am trying to update from 14.0.0-B2 to 14.0.0 through the beta channel. But when I try to update the site, the site does not update, and no new lines are created in updates.log. Instead, a new message appears in sys_modules.log:
Jan 18 03:02:01 [0] CRON :
[upgrade] Cannot get a list of modules which require to be updated.
Auto-update is enabled, so there are about 2,000 lines of this, as every auto-update since July of 2024 has failed!
I believe that this is occurring because of the database errors related to Classes. When I tried to install it from the App store the install failed, but parts of Classes were added. The constant database errors occur when UNA tries to find something classes-related, but can't, here is an example:
Jan 10 19:52:23 [4] /searchExtended.php?action=get_mention&symbol=%23&term=ir&i=text&f=bx_timeline_post&fi=&m=bx_timeline Database query error
Error: Table 'indiesel_una566.bx_classes_meta_keywords' doesn't exist
Query: SELECT `object_id`, `keyword` FROM `bx_classes_meta_keywords` WHERE `keyword` LIKE ? ORDER BY CHAR_LENGTH(`keyword`) DESC
Account ID: 3
This morning I thought, well, the update is failing because parts of Classes are installed and parts of Classes are not installed, so maybe I can just try to install Classes from the Apps module and see if it works now. I tried that, and I was able to download it, but at the install step I get a forever spinning icon. I checked and there is a new error in sys_db.log:
Jan 18 11:12:27 [1] /studio/store.php Database query error
Error: Duplicate entry 'bx_classes-added' for key 'alert'
Query: INSERT INTO
`bx_timeline_handlers`
SET
`group`=?,
`type`=?,
`alert_unit`=?,
`alert_action`=?,
`content`=?,
`privacy`=?
Account ID: 1
It's a catch 22! I can't update without having my list of active modules match what UNA thinks they should be, but I can't get Classes installed because the system thinks I have it already.
Before when we tried to fix this, we were going to be using the UNA site to host a virtual convention in a week, so I was in a huge hurry to just get it functional for the 200-ish people attending the convention. Now there is no rush. What do I need to do to get the site working and error free, ideally with the Classes app installed (love the functionality it adds to Groups)?