I had to upgrade an Invision Power Board yesterday from 1.3.x to the newer version 2.0.2.

I read the documentation and ran the upgrade.php file as they said. It completed all of the steps successfully. But when I tried to enter the board, there was a problem something of the sort “incorrect value in column ‘1′” or relating to m.has_blog where m was ibf_members.

Inspecting the database and comparing a freshly installed 2.0.x database with the upgraded database, I saw that the upgraded database was missing a field has_blog in ibf_members. If you add the field “has_blog, tinyint(1), not null” to the end of the table, the upgrade works great.