Announcement

Collapse
No announcement yet.

5.4.5 -> 5.5.3 Call to undefined method getClobTypeLength

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 5.4.5 -> 5.5.3 Call to undefined method getClobTypeLength

    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)"} []

  • #2
    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)

    Comment


    • #3
      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.

      Comment


      • #4
        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.


        Comment

        Working...
        X