# 4.2.1 Installation Failed **URL:** \ **Category:** Product Support\ **Created:** [March 29, 2022, 2:48pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340 "2022-03-29T14:48:26Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![ricksimnett](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ricksimnett/32/1578_2.png) [@ricksimnett](https://forum.mautic.org/u/ricksimnett)\ **Post date:** [March 29, 2022, 2:48pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/1 "2022-03-29T14:48:26Z")
**Your software** My Mautic version is: 4.2.1 My PHP version is: 7.4 My Database type and version is: MySql 8 **Your problem** My problem is: Used the web updater to update to 4.2.1. UPgrade failed at cache clear (UI became unresponsive), after manual clear, Mautic offline completely. These errors are showing in the log: About 10 symfony errors stating that they cannot overwrite certain files (liek URLGenerator.php). My permissions are all OK just to be clear. Steps I have tried to fix the problem: None. Not sure how to fix my broken mautic install without wiping it out and starting it over. Is there a command line upgrade I can run somehow? ---
**Author:** ![ricksimnett](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ricksimnett/32/1578_2.png) [@ricksimnett](https://forum.mautic.org/u/ricksimnett)\ **Post date:** [March 29, 2022, 2:50pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/2 "2022-03-29T14:50:54Z")
And just to be more clear - I already tried all the mautic:update stuff from the command line that Im aware of. Im wondering if there is a way to force it to re-apply the update to hopefully fix whatever blew up. ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [March 29, 2022, 2:56pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/3 "2022-03-29T14:56:25Z")
Revert installation from backup and try to upgrade again from cli ---
**Author:** ![kixell](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/kixell/32/7238_2.png) [@kixell](https://forum.mautic.org/u/kixell)\ **Post date:** [March 30, 2022, 5:40pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/4 "2022-03-30T17:40:53Z")
Hi, from fresh install I have same problem, also in command line. Here the error log : `Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing 'ALTER TABLE `kix\_lead\_event\_log`RENAME INDEX`IDX\_SEARCH`TO`kix\_IDX\_SEARCH`': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INDEX `IDX\_SEARCH`TO`kix\_IDX\_SEARCH`' at line 1 (uncaught exception) at /mautic-features/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 98 while running console command `doctrine:migrations:migrate` [] []` Best regards ---
**Author:** ![deepti](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/deepti/32/411_2.png) [@deepti](https://forum.mautic.org/u/deepti)\ **Post date:** [March 30, 2022, 6:05pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/5 "2022-03-30T18:05:53Z")
mysql version issue ---
**Author:** ![ricksimnett](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ricksimnett/32/1578_2.png) [@ricksimnett](https://forum.mautic.org/u/ricksimnett)\ **Post date:** [March 30, 2022, 7:27pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/6 "2022-03-30T19:27:00Z")
@mzagmajster - Did what you recommended. Tried CLI update, seems to update perfectly this way. Files were copied over properly, Symfony didnt throw any errors that I could find about not being able to copy files so it seems to have worked fine for me as a CLI update. Im now wondering why it failed during the web update… seems like the process would be the same in terms of permissions and procedure as a cli update. From a usability standpoint, I personally think losing the web install in v5 is a mistake. Only technical users will be able to update the system, most typical SMB’s will have a problem with ssh and cli updates I think. Even composer would be a stretch I think - but if there is a technical issue that makes necessary, I understand the reasoning. Do you have any insight on this? ---
**Author:** ![ricksimnett](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ricksimnett/32/1578_2.png) [@ricksimnett](https://forum.mautic.org/u/ricksimnett)\ **Post date:** [March 30, 2022, 7:28pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/7 "2022-03-30T19:28:43Z")
@kixell, I have to agree with @deepti - that issue says to me its a mysql version issue. Make sure you have the latest version of MariaDB installed or consider switching to MySQL 5.7+. ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [March 30, 2022, 9:54pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/8 "2022-03-30T21:54:37Z")
As far as I know the preferred way to update is cli command, because it provides more consistent / reliable way to update the app. There was a google doc. a while back that answered exactly the question you posted above. As for not being friendly to non-tech users: - if I would to be in the position of non-tech users I would hire external help to take care of technical aspect of Mautic - which includes the upgrade of the application - Or simply try to follow the procedure to update from documentation (and if you encounter issues you still have the forum - just like before) ---
**Author:** ![kixell](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/kixell/32/7238_2.png) [@kixell](https://forum.mautic.org/u/kixell)\ **Post date:** [March 31, 2022, 5:35am UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/9 "2022-03-31T05:35:29Z")
Ok, I ll try to upgrade. The current version is 10.4.14 Thanks for reply ---
**Author:** ![kixell](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/kixell/32/7238_2.png) [@kixell](https://forum.mautic.org/u/kixell)\ **Post date:** [March 31, 2022, 6:06am UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/10 "2022-03-31T06:06:07Z")
If I check requirements, it should be ok : MariaDB **10.2**. > **[Requirements](https://www.mautic.org/download/requirements)** > > For an optimal Mautic experience, it is recommended your servers meet the following requirements. > > Supported PHP versions per Mautic version My version is : 10.4.14 ---
**Author:** ![kixell](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/kixell/32/7238_2.png) [@kixell](https://forum.mautic.org/u/kixell)\ **Post date:** [March 31, 2022, 6:52am UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/11 "2022-03-31T06:52:21Z")
Maybe update the requirement as RENAME INDEX start with MariaDB 10.5.2 > **[ALTER TABLE](https://mariadb.com/kb/en/alter-table/#rename-indexkey)** > > Modify a table's definition. ---
**Author:** ![ricksimnett](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ricksimnett/32/1578_2.png) [@ricksimnett](https://forum.mautic.org/u/ricksimnett)\ **Post date:** [March 31, 2022, 3:55pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/12 "2022-03-31T15:55:22Z")
@kixell - Keeping up with the documentation is definitely something that is a priority. Thank you for the additional info. @silavapi how would I go about updating the requirements to reflect this information? Is there someone to notify on slack? ---
**Author:** ![kixell](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/kixell/32/7238_2.png) [@kixell](https://forum.mautic.org/u/kixell)\ **Post date:** [April 1, 2022, 1:14pm UTC](https://forum.mautic.org/t/4-2-1-installation-failed/23340/13 "2022-04-01T13:14:17Z")
Hi all, I confirm that upgrading MariaDB solve the problem. I needed to upgrade my Debian 🙂 but now with MariaDB 10.5.15 the upgrade run successfully. Best regards, Nicolas