Upgrade 2.5.9 to 3.5.5: Unknown column 'image_thumb_size' in 'field list'

[Majen]

I've successfully upgraded via the installer from 2.5.9 to 3.5.5. Once I opened the dashboard, I got the following error message:

Fatal error [400]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'image_thumb_size' in 'field list'
Triggered in /lib/G/classes/class.db.php at line 204

Stack trace:
#0 /app/routes/route.dashboard.php(114): G\DB::queryFetchSingle('SELECT (SUM(image_size) + SUM(image_thumb_size) + SUM(image_medium_size)) as count from chv_images')
#1 /lib/G/classes/class.handler.php(206): G\Handler->{closure}(G\Handler)
#2 /lib/G/classes/class.handler.php(110): G\Handler->processRequest()
#3 /app/loader.php(305): G\Handler->__construct(Array)
#4 /index.php(20): include_once('/app/loader.php')

I compared /app/install/sql/images.sql with the chv_images table and it mismatched in the following way:

• image_thumb_size and image_medium_size columns were missing

I've executed the following SQL queries to fix the DB schema:

ALTER TABLE `chv_images` ADD `image_thumb_size` int(11) NOT NULL;
ALTER TABLE `chv_images` ADD `image_medium_size` int(11) NOT NULL DEFAULT '0';

The dashboard page is now loading successfully. Any idea what went wrong here?

 

[Rodolfo]

Update from 2.X is not the same as update from 3.X, I often forget to add the cases for 2.X

 

[ashurge]

Majen
I have the same problem. Thanks for the solution.