5.4.5 -> 5.5.3 Call to undefined method getClobTypeLength

[dimyy]

Attempt to upgrade from 5.4.5 to 5.5.3 fail

Error log:
[2018-12-26 11:10:35] Espo.ERROR: Uncaught Exception Error: "Call to undefined method Espo\Core\Utils\Database\DBAL\Platforms\MySqlPlatf orm::getClobTypeLength()" at /home/espotest/public_html/application/Espo/Core/Utils/Database/DBAL/Schema/MySqlSchemaManager.php line 212 {"exception":"[object] (Error(code: 0): Call to undefined method Espo\\Core\\Utils\\Database\\DBAL\\Platforms\\MySq lPlatform::getClobTypeLength() at /home/espotest/public_html/application/Espo/Core/Utils/Database/DBAL/Schema/MySqlSchemaManager.php:212)"} []

[dimyy]

Steps to remediate:

All steps in console mode (interface is not working)

1. Clear cache (php clear_cache.php)
2. Replacing /application/Espo/Resources/metadata/entityDefs/ to original 5.4.5 files (otherwise errors like Column not found: 1054 Unknown column 'job.number' in 'field list')
3. Upload EspoCRM-upgrade-5.4.5-to-5.5.3.zip to the root directory
4. Manual upgrade (php upgrade.php EspoCRM-upgrade-5.4.5-to-5.5.3.zip)

[rinorway]

Confirmed behaviour :

Espo.ERROR: Uncaught Exception Error: "Call to undefined method Espo\Core\Utils\Database\DBAL\Platforms\MySqlPlatf orm::getClobTypeLength()" at /var/www/crm/application/Espo/Core/Utils/Database/DBAL/Schema/MySqlSchemaManager.php line 212 {"exception":"[object] (Error(code: 0): Call to undefined method Espo\\Core\\Utils\\Database\\DBAL\\Platforms\\MySq lPlatform::getClobTypeLength() at /var/www/crm/application/Espo/Core/Utils/Database/DBAL/Schema/MySqlSchemaManager.php:212)"} []

Resulting in :

Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.type' in 'field list'" at /var/www/crm/application/Espo/ORM/DB/Mapper.php line 73 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.type' in 'field list' at /var/www/crm/application/Espo/ORM/DB/Mapper.php:73)"} []

Will try your steps and provide update.

[rinorway]

Little bit different approach : the upgrade to 5.5.4 was excecuted, but failed in the AfterUpgrade script. The file updates were ok.

The issue appeared after 2 upgrades after each other 5.4.4 -> 5.4.5 -> 5.5.4

What I did :
- php rebuild
- set version to 5.4.4 in config (otherwise upgrade would be denied)
- php upgrade first to 5.4.5 once more
- php rebuild
- php upgrade to 5.5.4

I had to manually set the user.type to super-admin in the user table.

All working well now.

Thank you Dimmy for the pointers.