XF 2.1 Upgrade from 2.0.5 to 2.1.0 error

[Garrett Horne]

XF\Db\Exception: xf_user: MySQL query error [1264]: Out of range value for column 'reaction_score' at row 3 in src/XF/Db/AbstractStatement.php at line 217

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 78
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
4. XF\Db\AbstractAdapter->query() in src/XF/Db/Schema/AbstractDdl.php at line 151
5. XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 149
6. XF\Db\SchemaManager->alterTable() in src/XF/Install/InstallHelperTrait.php at line 594
7. XF\Install\Upgrade\AbstractUpgrade->alterTable() in src/XF/Install/Upgrade/2010010-210a.php at line 653
8. XF\Install\Upgrade\Version2010010->step43() in src/XF/Install/Controller/Upgrade.php at line 173
9. XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 321
10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 249
11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
14. XF\App->run() in src/XF.php at line 390
15. XF::runApp() in install/index.php at line 14

halp pls

 

[Mike]

Something tells me that you had a user with a bizarre like count value that I don't think it was intended. It would've been bigger than 2,147,483,647 (2.1 billion...).

If you run this query against the database and refresh the import, it should resolve it:

UPDATE xf_user SET like_count = 1000000 WHERE like_count > 1000000;

This will reset anyone with more than 1 million likes to 1 million. You can adjust those numbers bigger if you legitimately had users like that, but I'm guessing there was an underflow at some point which wrapped a user's like count unexpectedly.