Update von 4.4.55 auf 4.9.11: Testlauf erzeugt Warnmeldungen
Ahoi zusammen,
ich bin gerade dabei eine Contao Installation 4.4.29 auf einen neuen Server umzuziehen. Der Umzug lief super und die Aktualisierung auf 4.4.55 hat einwandfrei funktioniert.
Der Testlauf für 4.9.11 hat folgendes als Warnung ausgegeben:
Code:
$ /opt/RZphp73/bin/php-cli -q -dmax_execution_time=0 -dmemory_limit=-1 -dallow_url_fopen=1 -ddisable_functions= -ddate.timezone=CET /mnt/web507/d3/83/59762583/htdocs/xyz-zyx-de/web/contao-manager.phar.php composer require contao/manager-bundle=4.9.11 contao/news-bundle=4.9.11 contao/calendar-bundle=4.9.11 contao/faq-bundle=4.9.11 contao/comments-bundle=4.9.11 contao/newsletter-bundle=4.9.11 contao/listing-bundle=4.9.11 --no-update --no-scripts --prefer-stable --sort-packages --no-ansi --no-interaction
/mnt/web507/d3/83/59762583/htdocs/xyz-zyx-de/composer.json has been updated
# Process terminated with exit code 0
# Result: OK
> Resolving dependencies using Composer Cloud v3.0.0
!!! Current server is sponsored by: Contao Association !!!
[5.9MiB/0.25s] Loading composer repositories with package information
[55.3MiB/1.49s] Updating dependencies
[1113.8MiB/8.15s] Your requirements could not be resolved to an installable set of packages.
[1113.8MiB/8.15s]
Problem 1
- contao/managed-edition is present at version 1.0.0+no-version-set and cannot be modified by Composer
- ausi/contao-slug-backport is locked to version v1.0.6 and an update of this package was not requested.
- ausi/contao-slug-backport v1.0.6 requires contao/core-bundle 4.4.* -> satisfiable by contao/core-bundle[4.4.0, ..., 4.4.55].
- You can only install one version of a package, so only one of these can be installed: contao/core-bundle[4.3.0, ..., 4.10.6].
- contao/calendar-bundle 4.9.11 requires contao/core-bundle 4.9.11 -> satisfiable by contao/core-bundle[4.9.11].
- contao/managed-edition 1.0.0+no-version-set conflicts with contao/core-bundle 4.4.7.
- contao/managed-edition 1.0.0+no-version-set conflicts with contao/core-bundle 4.4.6.
- contao/managed-edition 1.0.0+no-version-set conflicts with contao/core-bundle 4.4.5.
- contao/managed-edition 1.0.0+no-version-set conflicts with contao/core-bundle 4.4.4.
- contao/managed-edition 1.0.0+no-version-set conflicts with contao/core-bundle 4.4.3.
- contao/managed-edition 1.0.0+no-version-set conflicts with contao/core-bundle 4.4.2.
- contao/managed-edition 1.0.0+no-version-set conflicts with contao/core-bundle 4.4.1.
- contao/managed-edition 1.0.0+no-version-set conflicts with contao/core-bundle 4.4.0.
- Root composer.json requires contao/calendar-bundle 4.9.11 -> satisfiable by contao/calendar-bundle[4.9.11].
Use the option --with-all-dependencies (-W) to allow upgrades, downgrades and removals for packages currently locked to specific versions.
[1113.8MiB/8.15s] Running update with --no-dev does not mean require-dev is ignored, it just means the packages will not be installed. If dev requirements are blocking the update you have to resolve those problems.
[43.5MiB/8.96s] Memory usage: 43.46MB (peak: 1114.38MB), time: 8.97s.
[43.5MiB/8.96s] Finished Composer Cloud resolving.
# Cloud Job ID w1lEuCDlMUCtNxGDz9PB2dsKR9J4jjGdGvv8KOUmf46FkA6gcMonx0Vuc3dKsYUbiMkgvqg3tqn9i failed
Wie ist das zu deuten? Wird das Update komplett in die Hose gehen oder was muss ich tun, damit der Testlauf erfolgreich wird?
Liste der Anhänge anzeigen (Anzahl: 1)
Testlauf erfolgreich, aber Installation mit Fehlern
Danke ihr zwei für die Hilfe. Gerade habe ich den contao-slug-backport entfernt, einen erfolgreichen Testlauf durchgeführt und dann die Installation angeschubst.
Diese ergab dann beim letzten Punkt „composer install“ aber mehrere Fehler:
Code:
$ /opt/RZphp73/bin/php-cli -q -dmax_execution_time=0 -dmemory_limit=-1 -dallow_url_fopen=1 -ddisable_functions= -ddate.timezone=CET /mnt/web507/d3/83/59762583/htdocs/xyz-zyx/web/contao-manager.phar.php composer install --prefer-dist --no-dev --no-progress --no-ansi --no-interaction --optimize-autoloader
Installing dependencies from lock file
Verifying lock file contents can be installed on current platform.
Package operations: 81 installs, 32 updates, 27 removals
- Downloading composer/package-versions-deprecated (1.11.99.1)
- Downloading dasprid/enum (1.0.3)
- Downloading bacon/bacon-qr-code (2.0.3)
- Downloading contao-components/contao (9.1.1)
- Downloading contao-components/dropzone (5.7.2)
- Downloading contao-components/highlight (9.18.1)
- Downloading contao-components/jquery (3.5.1)
- Downloading contao-components/tinymce4 (4.9.12)
- Downloading symfony/yaml (v4.4.19)
- Downloading symfony/http-foundation (v4.4.19)
- Downloading symfony/event-dispatcher-contracts (v1.1.9)
- Downloading symfony/event-dispatcher (v4.4.19)
- Downloading symfony/var-dumper (v4.4.19)
- Downloading symfony/debug (v4.4.19)
- Downloading symfony/error-handler (v4.4.19)
- Downloading symfony/http-kernel (v4.4.19)
- Downloading symfony/dependency-injection (v4.4.19)
- Downloading symfony/filesystem (v4.4.19)
- Downloading symfony/config (v4.4.19)
- Downloading symfony/options-resolver (v5.2.3)
- Downloading symfony/http-client (v4.4.19)
- Downloading psr/http-factory (1.0.1)
- Downloading psr/http-client (1.0.1)
- Downloading php-http/httplug (2.2.0)
- Downloading php-http/client-common (2.3.0)
- Downloading wikimedia/less.php (1.8.2)
- Downloading webignition/disallowed-character-terminated-string (2.0)
- Downloading webignition/robots-txt-file (3.0)
- Downloading twig/twig (v2.14.3)
- Downloading terminal42/service-annotation-bundle (1.1.3)
- Downloading symfony/dom-crawler (v4.4.19)
- Downloading nyholm/psr7 (1.3.2)
- Downloading terminal42/escargot (1.0.1)
- Downloading symfony/translation-contracts (v2.3.0)
- Downloading symfony/twig-bridge (v4.4.19)
- Downloading symfony/twig-bundle (v4.4.19)
- Downloading symfony/translation (v4.4.19)
- Downloading symfony/polyfill-iconv (v1.22.0)
- Downloading egulias/email-validator (2.1.25)
- Downloading swiftmailer/swiftmailer (v6.2.5)
- Downloading symfony/swiftmailer-bundle (v3.5.2)
- Downloading symfony/security-core (v4.4.19)
- Downloading symfony/polyfill-intl-grapheme (v1.22.0)
- Downloading symfony/string (v5.2.3)
- Downloading symfony/property-info (v5.2.3)
- Downloading symfony/property-access (v5.2.3)
- Downloading symfony/security-http (v4.4.19)
- Downloading symfony/security-guard (v4.4.19)
- Downloading symfony/security-csrf (v5.2.3)
- Downloading symfony/security-bundle (v4.4.19)
- Downloading symfony/routing (v4.4.19)
- Downloading symfony/process (v4.4.19)
- Downloading symfony/monolog-bridge (v4.4.19)
- Downloading symfony/lock (v4.4.19)
- Downloading symfony/finder (v4.4.19)
- Downloading symfony/var-exporter (v5.2.3)
- Downloading symfony/cache-contracts (v2.2.0)
- Downloading symfony/cache (v4.4.19)
- Downloading symfony/framework-bundle (v4.4.19)
- Downloading symfony/expression-language (v4.4.19)
- Downloading symfony/console (v4.4.19)
- Downloading symfony/asset (v4.4.19)
- Downloading symfony-cmf/routing (2.3.3)
- Downloading symfony-cmf/routing-bundle (2.4.2)
- Downloading thecodingmachine/safe (v1.3.3)
- Downloading paragonie/constant_time_encoding (v2.4.0)
- Downloading beberlei/assert (v3.3.0)
- Downloading spomky-labs/otphp (v10.0.1)
- Downloading scheb/2fa-bundle (v5.4.2)
- Downloading lcobucci/jwt (3.4.4)
- Downloading scheb/2fa-trusted-device (v5.4.2)
- Downloading scheb/2fa-backup-code (v5.4.2)
- Downloading ramsey/uuid (3.9.3)
- Downloading phpunit/php-token-stream (4.0.4)
- Downloading nelmio/cors-bundle (2.1.0)
- Downloading league/uri-parser (1.4.1)
- Downloading league/uri-interfaces (1.1.1)
- Downloading league/uri-schemes (1.2.1)
- Downloading league/uri-hostname-parser (1.1.1)
- Downloading league/uri-components (1.8.2)
- Downloading knplabs/knp-time-bundle (v1.15.0)
- Downloading knplabs/knp-menu (v3.1.2)
- Downloading knplabs/knp-menu-bundle (v3.1.0)
- Downloading dragonmantank/cron-expression (v2.3.1)
- Downloading doctrine/persistence (2.1.0)
- Downloading doctrine/instantiator (1.4.0)
- Downloading doctrine/inflector (2.0.3)
- Downloading doctrine/common (3.1.1)
- Downloading doctrine/orm (2.8.1)
- Downloading symfony/doctrine-bridge (v4.4.19)
- Downloading doctrine/sql-formatter (1.1.1)
- Downloading doctrine/doctrine-bundle (2.2.3)
- Downloading contao/imagine-svg (1.0.2)
- Downloading contao/image (1.0.3)
- Downloading contao/core-bundle (4.9.11)
- Downloading contao/calendar-bundle (4.9.11)
- Downloading contao/comments-bundle (4.9.11)
- Downloading contao/faq-bundle (4.9.11)
- Downloading contao/listing-bundle (4.9.11)
- Downloading toflar/psr6-symfony-http-cache-store (3.0.1)
- Downloading symfony/web-profiler-bundle (v4.4.19)
- Downloading symfony/stopwatch (v4.4.19)
- Downloading zendframework/zend-eventmanager (3.2.1)
- Downloading zendframework/zend-code (3.4.1)
- Downloading ocramius/proxy-manager (2.2.3)
- Downloading symfony/proxy-manager-bridge (v4.4.18)
- Downloading symfony/dotenv (v4.4.19)
- Downloading symfony/debug-bundle (v4.4.19)
- Downloading contao/installation-bundle (4.9.11)
- Downloading contao/manager-bundle (4.9.11)
- Downloading contao/news-bundle (4.9.11)
- Downloading contao/newsletter-bundle (4.9.11)
- Removing terminal42/header-replay-bundle (1.5.3)
- Removing tecnickcom/tcpdf (6.3.5)
- Removing symfony/symfony (v3.4.47)
- Removing symfony/polyfill-php70 (v1.20.0)
- Removing symfony/polyfill-php56 (v1.20.0)
- Removing symfony/polyfill-intl-icu (v1.22.0)
- Removing symfony/polyfill-apcu (v1.22.0)
- Removing sensiolabs/security-checker (v6.0.3)
- Removing sensiolabs/ansi-to-html (v1.1.3)
- Removing sensio/distribution-bundle (v5.0.25)
- Removing ralouphie/getallheaders (3.0.3)
- Removing psr/link (1.0.0)
- Removing php-http/guzzle6-adapter (v1.1.1)
- Removing oyejorge/less.php (v1.7.0.14)
- Removing league/uri (4.2.2)
- Removing jeremykendall/php-domain-parser (3.0.0)
- Removing jdorn/sql-formatter (v1.2.17)
- Removing guzzlehttp/psr7 (1.7.0)
- Removing guzzlehttp/promises (1.4.0)
- Removing guzzlehttp/guzzle (6.5.5)
- Removing fig/link-util (1.1.2)
- Removing doctrine/reflection (1.2.2)
- Removing doctrine/doctrine-cache-bundle (1.4.0)
- Removing contao-components/respimage (1.4.2)
- Removing contao-components/mediaelement (4.2.14)
- Removing contao-components/html5shiv (3.7.3)
- Removing contao-components/compass (0.12.2.1)
- Installing composer/package-versions-deprecated (1.11.99.1): Extracting archive
- Installing ausi/slug-generator (v1.1.1): Extracting archive
- Installing dasprid/enum (1.0.3): Extracting archive
- Installing bacon/bacon-qr-code (2.0.3): Extracting archive
- Upgrading contao-components/contao (7.1.6 => 9.1.1): Extracting archive
- Upgrading contao-components/dropzone (4.3.0 => 5.7.2): Extracting archive
- Upgrading contao-components/highlight (8.9.1 => 9.18.1): Extracting archive
- Upgrading contao-components/jquery (1.12.4 => 3.5.1): Extracting archive
- Upgrading contao-components/tinymce4 (4.6.7.3 => 4.9.12): Extracting archive
- Installing symfony/yaml (v4.4.19): Extracting archive
- Installing symfony/http-foundation (v4.4.19): Extracting archive
- Installing symfony/event-dispatcher-contracts (v1.1.9): Extracting archive
- Installing symfony/event-dispatcher (v4.4.19): Extracting archive
- Installing symfony/var-dumper (v4.4.19): Extracting archive
- Installing symfony/debug (v4.4.19): Extracting archive
- Installing symfony/error-handler (v4.4.19): Extracting archive
- Installing symfony/http-kernel (v4.4.19): Extracting archive
- Installing symfony/dependency-injection (v4.4.19): Extracting archive
- Installing symfony/filesystem (v4.4.19): Extracting archive
- Installing symfony/config (v4.4.19): Extracting archive
- Installing symfony/options-resolver (v5.2.3): Extracting archive
- Downgrading symfony/http-client (v5.2.3 => v4.4.19): Extracting archive
- Installing psr/http-factory (1.0.1): Extracting archive
- Installing psr/http-client (1.0.1): Extracting archive
- Upgrading php-http/httplug (v1.1.0 => 2.2.0): Extracting archive
- Upgrading php-http/client-common (1.10.0 => 2.3.0): Extracting archive
- Installing wikimedia/less.php (1.8.2): Extracting archive
- Installing webignition/disallowed-character-terminated-string (2.0): Extracting archive
- Installing webignition/robots-txt-file (3.0): Extracting archive
- Upgrading twig/twig (v1.44.2 => v2.14.3): Extracting archive
- Installing terminal42/service-annotation-bundle (1.1.3): Extracting archive
- Installing symfony/dom-crawler (v4.4.19): Extracting archive
- Installing nyholm/psr7 (1.3.2): Extracting archive
- Installing terminal42/escargot (1.0.1): Extracting archive
- Installing symfony/translation-contracts (v2.3.0): Extracting archive
- Installing symfony/twig-bridge (v4.4.19): Extracting archive
- Installing symfony/twig-bundle (v4.4.19): Extracting archive
- Installing symfony/translation (v4.4.19): Extracting archive
- Installing symfony/polyfill-iconv (v1.22.0): Extracting archive
- Installing egulias/email-validator (2.1.25): Extracting archive
- Upgrading swiftmailer/swiftmailer (v5.4.12 => v6.2.5): Extracting archive
- Upgrading symfony/swiftmailer-bundle (v2.6.7 => v3.5.2): Extracting archive
- Installing symfony/security-core (v4.4.19): Extracting archive
- Installing symfony/polyfill-intl-grapheme (v1.22.0): Extracting archive
- Installing symfony/string (v5.2.3): Extracting archive
- Installing symfony/property-info (v5.2.3): Extracting archive
- Installing symfony/property-access (v5.2.3): Extracting archive
- Installing symfony/security-http (v4.4.19): Extracting archive
- Installing symfony/security-guard (v4.4.19): Extracting archive
- Installing symfony/security-csrf (v5.2.3): Extracting archive
- Installing symfony/security-bundle (v4.4.19): Extracting archive
- Installing symfony/routing (v4.4.19): Extracting archive
- Installing symfony/process (v4.4.19): Extracting archive
- Installing symfony/monolog-bridge (v4.4.19): Extracting archive
- Installing symfony/lock (v4.4.19): Extracting archive
- Installing symfony/finder (v4.4.19): Extracting archive
- Installing symfony/var-exporter (v5.2.3): Extracting archive
- Installing symfony/cache-contracts (v2.2.0): Extracting archive
- Installing symfony/cache (v4.4.19): Extracting archive
- Installing symfony/framework-bundle (v4.4.19): Extracting archive
- Installing symfony/expression-language (v4.4.19): Extracting archive
- Installing symfony/console (v4.4.19): Extracting archive
- Installing symfony/asset (v4.4.19): Extracting archive
- Installing symfony-cmf/routing (2.3.3): Extracting archive
- Installing symfony-cmf/routing-bundle (2.4.2): Extracting archive
- Installing thecodingmachine/safe (v1.3.3): Extracting archive
- Installing paragonie/constant_time_encoding (v2.4.0): Extracting archive
- Installing beberlei/assert (v3.3.0): Extracting archive
- Installing spomky-labs/otphp (v10.0.1): Extracting archive
- Installing scheb/2fa-bundle (v5.4.2): Extracting archive
- Installing lcobucci/jwt (3.4.4): Extracting archive
- Installing scheb/2fa-trusted-device (v5.4.2): Extracting archive
- Installing scheb/2fa-backup-code (v5.4.2): Extracting archive
- Installing ramsey/uuid (3.9.3): Extracting archive
- Upgrading phpunit/php-token-stream (3.1.2 => 4.0.4): Extracting archive
- Upgrading nelmio/cors-bundle (1.5.6 => 2.1.0): Extracting archive
- Installing league/uri-parser (1.4.1): Extracting archive
- Installing league/uri-interfaces (1.1.1): Extracting archive
- Installing league/uri-schemes (1.2.1): Extracting archive
- Installing league/uri-hostname-parser (1.1.1): Extracting archive
- Installing league/uri-components (1.8.2): Extracting archive
- Removing knplabs/knp-time-bundle (v1.10.0)
- Installing knplabs/knp-time-bundle (v1.15.0): Extracting archive
- Upgrading knplabs/knp-menu (2.6.0 => v3.1.2): Extracting archive
- Upgrading knplabs/knp-menu-bundle (v2.3.0 => v3.1.0): Extracting archive
- Installing dragonmantank/cron-expression (v2.3.1): Extracting archive
- Upgrading doctrine/persistence (1.3.8 => 2.1.0): Extracting archive
- Installing doctrine/instantiator (1.4.0): Extracting archive
- Upgrading doctrine/inflector (1.4.3 => 2.0.3): Extracting archive
- Upgrading doctrine/common (2.13.3 => 3.1.1): Extracting archive
- Installing doctrine/orm (2.8.1): Extracting archive
- Installing symfony/doctrine-bridge (v4.4.19): Extracting archive
- Installing doctrine/sql-formatter (1.1.1): Extracting archive
- Upgrading doctrine/doctrine-bundle (1.12.13 => 2.2.3): Extracting archive
- Upgrading contao/imagine-svg (0.2.3 => 1.0.2): Extracting archive
- Upgrading contao/image (0.3.9 => 1.0.3): Extracting archive
- Upgrading contao/core-bundle (4.4.55 => 4.9.11): Extracting archive
- Upgrading contao/calendar-bundle (4.4.55 => 4.9.11): Extracting archive
- Upgrading contao/comments-bundle (4.4.55 => 4.9.11): Extracting archive
- Upgrading contao/faq-bundle (4.4.55 => 4.9.11): Extracting archive
- Upgrading contao/listing-bundle (4.4.55 => 4.9.11): Extracting archive
- Upgrading toflar/psr6-symfony-http-cache-store (2.3.1 => 3.0.1): Extracting archive
- Installing symfony/web-profiler-bundle (v4.4.19): Extracting archive
- Installing symfony/stopwatch (v4.4.19): Extracting archive
- Installing zendframework/zend-eventmanager (3.2.1): Extracting archive
- Installing zendframework/zend-code (3.4.1): Extracting archive
- Installing ocramius/proxy-manager (2.2.3): Extracting archive
- Installing symfony/proxy-manager-bridge (v4.4.18): Extracting archive
- Installing symfony/dotenv (v4.4.19): Extracting archive
- Installing symfony/debug-bundle (v4.4.19): Extracting archive
- Upgrading contao/installation-bundle (4.4.55 => 4.9.11): Extracting archive
- Upgrading contao/manager-bundle (4.4.55 => 4.9.11): Extracting archive
- Upgrading contao/news-bundle (4.4.55 => 4.9.11): Extracting archive
- Upgrading contao/newsletter-bundle (4.4.55 => 4.9.11): Extracting archive
Package patchwork/utf8 is abandoned, you should avoid using it. Use symfony/polyfill-mbstring or symfony/string instead.
Package phpunit/php-token-stream is abandoned, you should avoid using it. No replacement was suggested.
Package zendframework/zend-code is abandoned, you should avoid using it. Use laminas/laminas-code instead.
Package zendframework/zend-eventmanager is abandoned, you should avoid using it. Use laminas/laminas-eventmanager instead.
Generating optimized autoload files
Class League\Uri\Schemes\AbstractUri located in ./vendor/league/uri-schemes/src/Schemes/deprecated.php does not comply with psr-4 autoloading standard. Skipping.
Class League\Uri\Schemes\Data located in ./vendor/league/uri-schemes/src/Schemes/deprecated.php does not comply with psr-4 autoloading standard. Skipping.
Class League\Uri\Schemes\File located in ./vendor/league/uri-schemes/src/Schemes/deprecated.php does not comply with psr-4 autoloading standard. Skipping.
Class League\Uri\Schemes\Ftp located in ./vendor/league/uri-schemes/src/Schemes/deprecated.php does not comply with psr-4 autoloading standard. Skipping.
Class League\Uri\Schemes\Http located in ./vendor/league/uri-schemes/src/Schemes/deprecated.php does not comply with psr-4 autoloading standard. Skipping.
Class League\Uri\Schemes\Uri located in ./vendor/league/uri-schemes/src/Schemes/deprecated.php does not comply with psr-4 autoloading standard. Skipping.
Class League\Uri\Schemes\UriException located in ./vendor/league/uri-schemes/src/Schemes/deprecated.php does not comply with psr-4 autoloading standard. Skipping.
Class League\Uri\Schemes\Ws located in ./vendor/league/uri-schemes/src/Schemes/deprecated.php does not comply with psr-4 autoloading standard. Skipping.
mmap() failed: [12] Cannot allocate memory
mmap() failed: [12] Cannot allocate memory
# Process terminated with exit code 255
# Result: Unknown error
Am Ende des Protokolls scheinen Empfehlungen für Update-Alternativen zu stehen. Wie sind diese zu deuten bzw. auszuführen? Auf das Newsletter-Bundle könnte ich defintiv auch verzichten.
Gerade merke ich, dass die Fehler auch schon beim Testlauf zu sehen sind. Siehe Screenshot…
Anhang 24310
Liste der Anhänge anzeigen (Anzahl: 1)
Wiederholung erfolgreich
Ahoi, ich habs jetzt einfach nochmal wiederholt und hatte Glück. Der Strato-Server hat mehr RAM ausgespuckt – richtige Uhrzeit ;-)
Anhang 24311
Aktuell habe ich auf der Subdomain für die Vorbereitung kein SSL laufen. Das Backend ist auf jeden Fall erreichbar, aber beim Frontend spackt es etwas (Ikoognito und http funzt). Gab es da Änderungen in Contao? Ich habe einfach mal die Checkbox für https in den Startpunkt-Einstellungen deaktiviert.
Sollte ich der Subdomain SSL gönnen oder geht das für die Weiterentwicklung auch ohne?
Außerdem schlägt das Install-Tool noch vor folgende Tabellen/Spalten zu löschen… execute?
Code:
Tabellen löschen
Alle auswählen
DROP TABLE tl_cron
DROP TABLE tl_newsletter_recipients_backup
DROP TABLE tl_session
Spalten löschen
Alle auswählen
ALTER TABLE tl_comments_notify DROP tokenConfirm
ALTER TABLE tl_comments_notify DROP ip
ALTER TABLE tl_content DROP youtubeStop
ALTER TABLE tl_content DROP youtubeStart
ALTER TABLE tl_content DROP autoplay
ALTER TABLE tl_form_field DROP fsType
ALTER TABLE tl_layout DROP doctype
ALTER TABLE tl_log DROP ip
ALTER TABLE tl_member DROP activation
ALTER TABLE tl_member DROP createdOn
ALTER TABLE tl_member DROP autologin
ALTER TABLE tl_member DROP loginCount
ALTER TABLE tl_module DROP flashJS
ALTER TABLE tl_module DROP flashID
ALTER TABLE tl_module DROP interactive
ALTER TABLE tl_module DROP source
ALTER TABLE tl_module DROP altContent
ALTER TABLE tl_module DROP flashvars
ALTER TABLE tl_module DROP transparent
ALTER TABLE tl_module DROP size
ALTER TABLE tl_module DROP totalLength
ALTER TABLE tl_module DROP cols
ALTER TABLE tl_newsletter_recipients DROP token
ALTER TABLE tl_newsletter_recipients DROP ip
ALTER TABLE tl_newsletter_recipients DROP confirmed
ALTER TABLE tl_page DROP mobileLayout
ALTER TABLE tl_theme DROP defaultImageDensities
ALTER TABLE tl_user DROP loginCount
ALTER TABLE tl_user DROP limitWidth