Good morning! Iâve been struggling for days to update Mautic, but all the methods fail. It seems like itâs trying to make a huge jump from 4.4.133 to 5.29.
Is there a way for me to update gradually between closer versions?
It throws an error because it canât find certain fields it wants to delete from the database, for example: An exception occurred while executing âALTER TABLE mautic_lead_event_log DROP INDEX IDX_SEARCHâ: SQLSTATE[42000]: Syntax error or access violation: 1091 Canât DROP INDEX IDX_SEARCH; check that it exists" {âexceptionâ:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0)
Does anyone have an idea?
Really, upgrading from Mautic 4.4.13 to 5 is not a simple task.
I simply couldnât upgrade one of my Mautic instances because it was an environment that had been updated since version 2.
In another instance, I encountered a similar error to yours, but in the campaign_lead_event_log table. In my case, the solution was to delete some records in the metadata column.
I recommend performing all these upgrade tests in a cloned environment and not in the production environment, to avoid your campaigns and everything else stopping from working.
This link - Getting json_array error after upgrade to v5 - #9 by viktor - has more information that may help you.
Best regards!
Sandro