Error after update

[akroii]

Bug description

After I updated: Contao (4.9.1 => 4.9.2) pdir/mobilede-bundle (2.5.5 => 2.6.0) pdir/mobilede-sync-bundle (1.1.6 => 1.2.0)

And do contao:migrate

This is what I got:

 * ALTER TABLE tl_mobile_ad ADD account INT UNSIGNED DEFAULT 0 NOT NULL
09:41:05 ERROR     [console] Error thrown while running command "contao:migrate". Message: "An exception occurred while executing 'ALTER TABLE tl_mobile_ad ADD account INT UNSIGNED DEFAULT 0 NOT NULL':

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs" ["exception" => Doctrine\DBAL\Exception\DriverException^ { …},"command" => "contao:migrate","message" => """  An exception occurred while executing 'ALTER TABLE tl_mobile_ad ADD account INT UNSIGNED DEFAULT 0 NOT NULL':\n  \n  SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs  """]

In AbstractMySQLDriver.php line 106:

  An exception occurred while executing 'ALTER TABLE tl_mobile_ad ADD account INT UNSIGNED DEFA
  ULT 0 NOT NULL':

  SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row s
  ize for the used table type, not counting BLOBs, is 8126. This includes storage overhead, che
  ck the manual. You have to change some columns to TEXT or BLOBs

In PDOConnection.php line 83:

  SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row s
  ize for the used table type, not counting BLOBs, is 8126. This includes storage overhead, che
  ck the manual. You have to change some columns to TEXT or BLOBs

In PDOConnection.php line 78:

  SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row s
  ize for the used table type, not counting BLOBs, is 8126. This includes storage overhead, che
  ck the manual. You have to change some columns to TEXT or BLOBs

contao:migrate [--with-deletes] [--schema-only] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--] <command>

Steps to reproduce

Do update: pdir/mobilede-bundle (2.5.5 => 2.6.0) pdir/mobilede-sync-bundle (1.1.6 => 1.2.0)

Expected behavior

Screenshots

Environment

Contao 4.9.2 PHP 7.4 Hosted on Hostingwerk 21% of total webspace is used

[akroii]

When I do manually sync, I got this message:

Error log:

[2020-05-06 09:54:23] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'DELETE FROM tl_mobile_ad WHERE type = 'sync' AND account = 0':  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account' in 'where clause'" at /srv/www/schmidt/public/contao4.9.x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'DELETE FROM tl_mobile_ad WHERE type = 'sync' AND account = 0':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'account' in 'where clause' at /srv/www/schmidt/public/contao4.9.x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account' in 'where clause' at /srv/www/schmidt/public/contao4.9.x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account' in 'where clause' at /srv/www/schmidt/public/contao4.9.x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []

[MDevster]

fixed