Your software
My PHP version is : 7.4.29
My MySQL/MariaDB version is : 10.3.34-MariaDB, pdo_mysql
Updating/Installing Errors
I am: Updating to 4.3.1 hoping it would fix a failed 4.2.2 upgrade)
Upgrading/installing via : Command Line
Same error reported several times before:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQ
L syntax; check the manual that corresponds to your MariaDB server version for the r
ight syntax to use near 'INDEX `IDX_SEARCH` TO `mtc_IDX_SEARCH`' at line 1
Installation still completely dead, 403 in the browser - business on hold for the last three weeks. Clearing cache does not solve the problem.
None of these instructions/suggestions to ‘recover failed update’ work in this case.
What is the error in the SQL syntax and how can I fix it?
Error from the log; not sure if there are more clues in there:
[2022-05-28 12:42:01] console.CRITICAL: Error thrown while running command
"'doctrine:migration:migrate'". Message: "An exception occurred while executing
'ALTER TABLE `mtc_lead_event_log` RENAME INDEX `IDX_SEARCH` TO
`mtc_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
`mtc_IDX_SEARCH`' at line 1" {"exception":"[object]
(Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred
while executing 'ALTER TABLE `mtc_lead_event_log` RENAME INDEX `IDX_SEARCH` TO
`mtc_IDX_SEARCH`':\n\nSQLSTATE[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
`mtc_IDX_SEARCH`' at line 1 at
/home/myuser/public_html/mrktng/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98,
Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42000): SQLSTATE[42000]: Syntax
error or access violation: 1064