XF 2.3 2.3.4 > 2.3.5 - MySQL query error [1406]:

[Kleazy]

Getting errors on the test forum and production...

XF\Db\Exception: MySQL query error [1406]: Data too long for column 'provider_metadata' at row 1 in src/XF/Db/AbstractStatement.php at line 230

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 207
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 86
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 324
5. XF\Db\AbstractAdapter->update() in src/XF/Install/Upgrade/2030570-235.php at line 248
6. XF\Install\Upgrade\Version2030570->step8() in src/XF/Install/Controller/Upgrade.php at line 192
7. XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 362
8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
12. XF\App->run() in src/XF.php at line 806
13. XF::runApp() in install/index.php at line 16

 

[Chris D]

See:

Fixed Post in thread 'v2.3.5 Upgrade Error on Step 8 Data too long for column 'provider_metadata''

Jan 30, 2025

Cool You bumped into an issue we didn't hit during testing.

For now run this query:

ALTER TABLE `xf_purchase_request`MODIFY `provider_metadata` VARBINARY(500) DEFAULT NULL;

Then restart the upgrade and it should continue where it left off.

• Chris D

•