Update from 3.5.17 to 7.49 Upgrade with MySQL errors
How Do I?
The time has come to upgrade an old site.
EE: 3.5.17 MySQL 5.6 PHP 5.6
I upgraded PHP to 8.2
When I attempt to upgrade I get the following error showing in admin.php
Exception Caught
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20200813' at line 1:
SHOW COLUMNS FROM exp_channel_data-20200813
ee/legacy/database/drivers/mysqli/mysqli_connection.php:146
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('SHOW COLUMNS FR...')
#1 ee/legacy/database/DB_driver.php(262): CI_DB_mysqli_driver->_execute('SHOW COLUMNS FR...')
#2 ee/legacy/database/DB_driver.php(177): CI_DB_driver->simple_query('SHOW COLUMNS FR...')
#3 ee/ExpressionEngine/Library/Advisor/FieldtypeAdvisor.php(78): CI_DB_driver->query('SHOW COLUMNS FR...')
#4 ee/ExpressionEngine/Library/Advisor/FieldtypeAdvisor.php(18): ExpressionEngine\Library\Advisor\FieldtypeAdvisor->guessAllUsedFieldtypes()
#5 ee/ExpressionEngine/Library/Advisor/FieldtypeAdvisor.php(33): ExpressionEngine\Library\Advisor\FieldtypeAdvisor->getMissingFieldtypes()
#6 ee/ExpressionEngine/Library/Advisor/Advisor.php(41): ExpressionEngine\Library\Advisor\FieldtypeAdvisor->getMissingFieldtypeCount()
#7 ee/installer/controllers/wizard.php(534): ExpressionEngine\Library\Advisor\Advisor->postUpdateChecks()
#8 ee/installer/controllers/wizard.php(474): Wizard->postflight()
#9 ee/installer/controllers/wizard.php(278): Wizard->preflight()
#10 [internal function]: Wizard->_remap('do_update', Array)
#11 ee/ExpressionEngine/Core/Core.php(268): call_user_func_array(Array, Array)
#12 ee/ExpressionEngine/Core/Core.php(124): ExpressionEngine\Core\Core->runController(Array)
#13 ee/ExpressionEngine/Boot/boot.php(184): ExpressionEngine\Core\Core->run(Object(ExpressionEngine\Core\Request))
#14 admin.php(139): require_once('...')
#14 admin.php(139): require_once('...')My only options for MySQL upgrades are MySQL 5.7 or MariaDB 10.7
I need a wiser mind than mine to point me in the right direction and get this site back on its feet.
Thanks.
Someone made a backup of the exp_channel_data table in 2020 (around aug 13 I bet)
And they left the extra table in your database and now it’s breaking the upgrade.
The extra table is called exp_channel_data-20200813
Make a backup of the whole database, delete that table, run the upgrade again, see what happens. Good luck!
If that doesn’t work give us a call.
TTFN Travis
Hi Travis,
Thank you for seeing the obvious and helping out. The upgrade went well and I can now tidy things up.
I appreciate the help.
Forrest