Contao-Camp 2024
Ergebnis 1 bis 14 von 14

Thema: [Erledigt] 4.5.14 - Probleme bei Installation von "hyphenation"

  1. #1
    Contao-Fan
    Registriert seit
    17.10.2012.
    Ort
    Bern - Schweiz
    Beiträge
    443

    Standard [Erledigt] 4.5.14 - Probleme bei Installation von "hyphenation"

    Guten Tag zusammen

    Habe auf der einen Website Probleme mit der Installation von "hyphenation".

    Code:
    $ /opt/plesk/php/7.2/bin/php -q /var/www/vhosts/domain.net/httpdocs/microsites/web/contao-manager.phar.php composer require heimrichhannot/contao-hyphenator-bundle --no-suggest --no-update --no-scripts --prefer-stable --sort-packages --no-ansi --no-interaction
    
    Using config.component-dir has been deprecated. Please use extra.contao-component-dir instead.
    Using version ^1.9 for heimrichhannot/contao-hyphenator-bundle
    /var/www/vhosts/publitiv.net/httpdocs/microsites/composer.json has been updated
    
    # Process terminated with exit code 0
    # Result: OK
    
    
    > Resolving dependencies using Composer Cloud v2.2.0
    
    # Job ID q0YyNFYHzTXFruu7I5ESQP5QzRNmVrEEUG5iNfxbRrK4NVQ8FNVg7HUixG2lG3oCGmcItwKgAcSgAyTD2qoGP0xVVJoq completed in 62 seconds
    # Memory usage: 424.67MB (peak: 2187.98MB), time: 59.72s.
    
    $ /opt/plesk/php/7.2/bin/php -q /var/www/vhosts/domain.net/httpdocs/microsites/web/contao-manager.phar.php composer install --prefer-dist --no-dev --no-progress --no-suggest --no-ansi --no-interaction --optimize-autoloader
    
    Using config.component-dir has been deprecated. Please use extra.contao-component-dir instead.
    ocramius/package-versions:  Generating version class...
    ocramius/package-versions: ...done generating version class
    contao/manager-plugin: Generating plugin class...
    contao/manager-plugin: ...done generating plugin class
    
    In DefinitionErrorExceptionPass.php line 37:
                                                                                   
      Cannot autowire service "HeimrichHannot\UtilsBundle\Form\FormUtil": argumen  
      t "$framework" of method "__construct()" references interface "Contao\CoreB  
      undle\Framework\ContaoFrameworkInterface" but no such service exists. You s  
      hould maybe alias this interface to the existing "contao.framework" service  
      .                                                                            
                                                                                   
    
    Loading composer repositories with package information
    Installing dependencies from lock file
    Package operations: 5 installs, 0 updates, 0 removals
    As there is no 'unzip' command installed zip files are being unpacked using the PHP zip extension.
    This may cause invalid reports of corrupted archives. Besides, any UNIX permissions (e.g. executable) defined in the archives will be lost.
    Installing 'unzip' may remediate them.
      - Installing wa72/htmlpagedom (v1.4.2): Loading from cache
      - Installing vanderlee/syllable (1.5.3): Loading from cache
      - Installing heimrichhannot/contao-request-bundle (1.0.8): Loading from cache
      - Installing heimrichhannot/contao-utils-bundle (2.127.0): Loading from cache
      - Installing heimrichhannot/contao-hyphenator-bundle (1.9.0): Loading from cache
    Package heimrichhannot/contao-youtube is abandoned, you should avoid using it. Use heimrichhannot/contao-youtube-bundle instead.
    Generating optimized autoload files
    > Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication
    Script Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication handling the post-install-cmd event terminated with an exception
    
    In ScriptHandler.php line 95:
                                                                                   
      An error occurred while executing the "contao:install-web-dir" command:      
      In DefinitionErrorExceptionPass.php line 37:                                 
                                                                                   
                                                                                   
        Cannot autowire service "HeimrichHannot\UtilsBundle\Form\FormUtil": argum  
      en                                                                           
        t "$framework" of method "__construct()" references interface "Contao\Cor  
      eB                                                                           
        undle\Framework\ContaoFrameworkInterface" but no such service exists. You  
       s                                                                           
        hould maybe alias this interface to the existing "contao.framework" servi  
      ce                                                                           
        .                                                                          
                                                                                   
    
    install [--prefer-source] [--prefer-dist] [--dry-run] [--dev] [--no-dev] [--no-custom-installers] [--no-autoloader] [--no-scripts] [--no-progress] [--no-suggest] [-v|vv|vvv|--verbose] [-o|--optimize-autoloader] [-a|--classmap-authoritative] [--apcu-autoloader] [--ignore-platform-reqs] [--] [<packages>...]
    
    
    # Process terminated with exit code 1
    # Result: General error
    
    
    ---
    
    ### Der Hintergrundprozess wurde unerwartet beendet ###
    Die Installation habe ich auch auf einem neu aufgesetzten Contao installiert, da hat es wunderbar funktioniert.

    Hat wer eine Idee, an was es genau liegen könnte?

    Folgende Pakete habe ich auf dieser Plattform Installiert:

    • cgo-it/contao-rate-it-bundle
    • Contao Cookiebar
    • dieschittigs/contao-recaptcha
    • mmenu - Mobile Navigation für Contao
    • fritzmg/contao-sharebuttons
    • Contao Short URLs
    • heimrichhannot/contao-youtube
    • heimrichhannot/dlh_googlemaps
    • hypergalaktisch/contao-animate
    • jrgregory/m17-sticky-backend-footer
    • RockSolid Slider
    • martin-kozianka/contao-timetags
    • Länderauswahl für die Contao Formulare
    • EasyThemes
    • terminal42/contao-mailusername
    • Notification Center
    Geändert von Dee (15.03.2020 um 09:04 Uhr)

  2. #2
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    33.896
    Partner-ID
    10107

    Standard

    Grundsätzlich solltest du auf Contao 4.8.7 aktualisieren und dabei alle Pakete aktualisieren lassen.

  3. #3
    Contao-Fan
    Registriert seit
    17.10.2012.
    Ort
    Bern - Schweiz
    Beiträge
    443

    Standard

    Wollte es eben updaten. Zu Beginn schien es zu laufen, dann brach es ab

    Code:
    Bestätigen & Schließen
    $ /opt/plesk/php/7.2/bin/php -q /var/www/vhosts/publitiv.net/httpdocs/microsites/web/contao-manager.phar.php composer require contao/manager-bundle=4.8.* contao/news-bundle=4.8.* contao/calendar-bundle=4.8.* contao/faq-bundle=4.8.* contao/comments-bundle=4.8.* contao/newsletter-bundle=4.8.* contao/listing-bundle=4.8.* --no-suggest --no-update --no-scripts --prefer-stable --sort-packages --no-ansi --no-interaction
    
    Using config.component-dir has been deprecated. Please use extra.contao-component-dir instead.
    /var/www/vhosts/publitiv.net/httpdocs/microsites/composer.json has been updated
    
    # Process terminated with exit code 0
    # Result: OK
    
    
    > Resolving dependencies using Composer Cloud v2.2.0
    
    # Job ID bWKiUqijcuk9tbmhazr4T7KulBDRzbMfOhNGDrnouOTHnyw2UY4shCryp0bJ84X6TAGWLrBDxjR4ySHyfnurX6VmM3boG2jLIq4uMQtSUlSsjoONpMnIEqkkjAQEsQ completed in 87 seconds
    # Memory usage: 429.05MB (peak: 1985.56MB), time: 85.99s.
    
    $ /opt/plesk/php/7.2/bin/php -q /var/www/vhosts/publitiv.net/httpdocs/microsites/web/contao-manager.phar.php composer install --prefer-dist --no-dev --no-progress --no-suggest --no-ansi --no-interaction --optimize-autoloader
    
    Using config.component-dir has been deprecated. Please use extra.contao-component-dir instead.
    ocramius/package-versions:  Generating version class...
    ocramius/package-versions: ...done generating version class
    contao/manager-plugin: Generating plugin class...
    contao/manager-plugin: ...done generating plugin class
    Added the web/index.php file.
    Added the web/preview.php file.
    Added the web/robots.txt file.
    Added the web/app.php file.
    Deleted the web/app_dev.php file.
    
     // Clearing the cache for the prod environment with debug                      
     // false                                                                       
    
     [OK] Cache for the "prod" environment (debug=false) was successfully cleared.  
    
    
     // Warming up the cache for the prod environment with debug                    
     // false                                                                       
    
    10:03:59 ERROR     [console] Error thrown while running command "cache:warmup --env=prod". Message: "[Semantical Error] The annotation "@Sensio\Bundle\FrameworkExtraBundle\Configuration\Route" in method cgoIT\rateit\Controller\AjaxRateItController::ajaxAction() does not exist, or could not be auto-loaded in /var/www/vhosts/publitiv.net/httpdocs/microsites/vendor/cgo-it/contao-rate-it-bundle/src/Controller/ (which is being imported from "/var/www/vhosts/publitiv.net/httpdocs/microsites/vendor/cgo-it/contao-rate-it-bundle/src/Resources/config/routing.yml"). Make sure annotations are installed and enabled." ["exception" => Symfony\Component\Config\Exception\LoaderLoadException { …},"command" => "cache:warmup --env=prod","message" => "[Semantical Error] The annotation "@Sensio\Bundle\FrameworkExtraBundle\Configuration\Route" in method cgoIT\rateit\Controller\AjaxRateItController::ajaxAction() does not exist, or could not be auto-loaded in /var/www/vhosts/publitiv.net/httpdocs/microsites/vendor/cgo-it/contao-rate-it-bundle/src/Controller/ (which is being imported from "/var/www/vhosts/publitiv.net/httpdocs/microsites/vendor/cgo-it/contao-rate-it-bundle/src/Resources/config/routing.yml"). Make sure annotations are installed and enabled."]
    
    In FileLoader.php line 166:
                                                                                   
      [Semantical Error] The annotation "@Sensio\Bundle\FrameworkExtraBundle\Conf  
      iguration\Route" in method cgoIT\rateit\Controller\AjaxRateItController::aj  
      axAction() does not exist, or could not be auto-loaded in /var/www/vhosts/p  
      ublitiv.net/httpdocs/microsites/vendor/cgo-it/contao-rate-it-bundle/src/Con  
      troller/ (which is being imported from "/var/www/vhosts/publitiv.net/httpdo  
      cs/microsites/vendor/cgo-it/contao-rate-it-bundle/src/Resources/config/rout  
      ing.yml"). Make sure annotations are installed and enabled.                  
                                                                                   
    
    In AnnotationException.php line 54:
                                                                                   
      [Semantical Error] The annotation "@Sensio\Bundle\FrameworkExtraBundle\Conf  
      iguration\Route" in method cgoIT\rateit\Controller\AjaxRateItController::aj  
      axAction() does not exist, or could not be auto-loaded.                      
                                                                                   
    
    cache:warmup [--no-optional-warmers] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--] <command>
    
    Loading composer repositories with package information
    Installing dependencies from lock file
    Package operations: 55 installs, 17 updates, 20 removals
      - Removing tecnickcom/tcpdf (6.3.2)
      - Removing symfony/polyfill-util (v1.13.1)
      - Removing symfony/polyfill-php70 (v1.13.1)
      - Removing symfony/polyfill-php56 (v1.13.1)
      - Removing symfony/polyfill-apcu (v1.13.1)
      - Removing symfony/http-client-contracts (v2.0.1)
      - Removing symfony/http-client (v5.0.2)
      - Removing sensiolabs/security-checker (v6.0.3)
      - Removing sensio/framework-extra-bundle (v5.4.1)
      - Removing psr/link (1.0.0)
      - Removing leafo/scssphp (v0.7.8)
      - Removing fig/link-util (1.1.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)
      - Removing symfony/polyfill-intl-icu (v1.13.1)
      - Removing symfony/symfony (v3.4.36)
      - Removing sensio/distribution-bundle (v5.0.25)
      - Removing terminal42/header-replay-bundle (1.5.3)
      - Updating contao-components/contao (7.1.5 => 9.1.0): As there is no 'unzip' command installed zip files are being unpacked using the PHP zip extension.
    This may cause invalid reports of corrupted archives. Besides, any UNIX permissions (e.g. executable) defined in the archives will be lost.
    Installing 'unzip' may remediate them.
    Downloading (100%)
      - Updating contao-components/jquery (1.12.4 => 3.4.1): Downloading (100%)
      - Updating contao-components/tablesort (3.4.12 => 4.0.1): Downloading (100%)
      - Installing symfony/yaml (v4.3.9): Downloading (100%)
      - Downgrading symfony/mime (v5.0.2 => v4.4.2): Downloading (100%)
      - Installing symfony/http-foundation (v4.3.9): Downloading (100%)
      - Installing symfony/event-dispatcher-contracts (v1.1.7): Downloading (100%)
      - Installing symfony/event-dispatcher (v4.3.9): Downloading (100%)
      - Installing symfony/debug (v4.4.2): Downloading (100%)
      - Installing symfony/http-kernel (v4.3.9): Downloading (100%)
      - Downgrading symfony/service-contracts (v2.0.1 => v1.1.8): Downloading (100%)
      - Installing symfony/dependency-injection (v4.3.9): Downloading (100%)
      - Installing symfony/filesystem (v4.3.9): Downloading (100%)
      - Installing symfony/config (v4.3.9): Downloading (100%)
      - Installing symfony/options-resolver (v5.0.2): Downloading (100%)
      - Installing terminal42/service-annotation-bundle (1.0.0): Downloading (100%)
      - Installing symfony/var-dumper (v4.3.9): Downloading (100%)
      - Installing symfony/translation-contracts (v1.1.7): Downloading (100%)
      - Installing symfony/twig-bridge (v4.4.2): Downloading (100%)
      - Installing symfony/twig-bundle (v4.3.9): Downloading (100%)
      - Installing symfony/translation (v4.3.9): Downloading (100%)
      - Updating symfony/swiftmailer-bundle (v3.3.1 => v3.4.0): Downloading (100%)
      - Installing symfony/inflector (v5.0.2): Downloading (100%)
      - Installing symfony/property-access (v4.4.2): Downloading (100%)
      - Installing symfony/security (v4.3.9): Downloading (100%)
      - Installing symfony/security-bundle (v4.3.9): Downloading (100%)
      - Installing symfony/routing (v4.3.9): Downloading (100%)
      - Installing symfony/process (v4.3.9): Downloading (100%)
      - Installing symfony/lock (v4.3.9): Downloading (100%)
      - Installing symfony/finder (v4.3.9): Downloading (100%)
      - Installing symfony/var-exporter (v4.4.2): Downloading (100%)
      - Installing symfony/cache-contracts (v1.1.7): Downloading (100%)
      - Installing symfony/cache (v4.3.9): Downloading (100%)
      - Installing symfony/framework-bundle (v4.3.9): Downloading (100%)
      - Installing symfony/expression-language (v4.3.9): Downloading (100%)
      - Installing symfony/console (v4.3.9): Downloading (100%)
      - Installing symfony/asset (v4.3.9): Downloading (100%)
      - Installing symfony-cmf/routing (2.1.1): Downloading (100%)
      - Installing symfony-cmf/routing-bundle (2.2.0): Downloading (100%)
      - Installing paragonie/constant_time_encoding (v2.3.0): Downloading (100%)
      - Installing beberlei/assert (v3.2.7): Downloading (100%)
      - Installing spomky-labs/otphp (v9.1.4): Downloading (100%)
      - Installing scssphp/scssphp (1.0.6): Downloading (100%)
      - Installing lcobucci/jwt (3.3.1): Downloading (100%)
      - Installing scheb/two-factor-bundle (v4.12.0): Downloading (100%)
      - Installing symfony/templating (v5.0.2): Downloading (100%)
      - Updating imagine/imagine (v0.7.1 => 1.2.3): Downloading (100%)
      - Installing doctrine/instantiator (1.3.0): Downloading (100%)
      - Installing doctrine/orm (v2.7.0): Downloading (100%)
      - Installing symfony/doctrine-bridge (v4.3.9): Downloading (100%)
      - Updating contao/image (0.3.9 => 1.0.1): Downloading (100%)
      - Installing dasprid/enum (1.0.0): Downloading (100%)
      - Installing bacon/bacon-qr-code (2.0.0): Downloading (100%)
      - Updating contao/core-bundle (4.5.14 => 4.8.7): Downloading (100%)
      - Updating contao/calendar-bundle (4.5.14 => 4.8.7): Downloading (100%)
      - Updating contao/comments-bundle (4.5.14 => 4.8.7): Downloading (100%)
      - Updating contao/faq-bundle (4.5.14 => 4.8.7): Downloading (100%)
      - Updating contao/listing-bundle (4.5.14 => 4.8.7): Downloading (100%)
      - Installing toflar/psr6-symfony-http-cache-store (2.2.1): Downloading (100%)
      - Installing symfony/web-profiler-bundle (v4.3.9): Downloading (100%)
      - Installing zendframework/zend-eventmanager (3.2.1): Downloading (100%)
      - Installing zendframework/zend-code (3.4.1): Downloading (100%)
      - Installing ocramius/proxy-manager (2.2.3): Downloading (100%)
      - Installing symfony/proxy-manager-bridge (v4.3.9): Downloading (100%)
      - Installing symfony/monolog-bridge (v4.3.9): Downloading (100%)
      - Installing symfony/dotenv (v4.3.9): Downloading (100%)
      - Installing symfony/debug-bundle (v4.3.9): Downloading (100%)
      - Updating contao/installation-bundle (4.5.14 => 4.8.7): Downloading (100%)
      - Updating contao/manager-bundle (4.5.14 => 4.8.7): Downloading (100%)
      - Updating contao/news-bundle (4.5.14 => 4.8.7): Downloading (100%)
      - Updating contao/newsletter-bundle (4.5.14 => 4.8.7): Downloading (100%)
      - Installing symfony/css-selector (v5.0.2): Downloading (100%)
    Package heimrichhannot/contao-youtube is abandoned, you should avoid using it. Use heimrichhannot/contao-youtube-bundle instead.
    Package zendframework/zend-eventmanager is abandoned, you should avoid using it. Use laminas/laminas-eventmanager instead.
    Package zendframework/zend-code is abandoned, you should avoid using it. Use laminas/laminas-code instead.
    Generating optimized autoload files
    > Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication
    Script Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication handling the post-install-cmd event terminated with an exception
    
    In ScriptHandler.php line 88:
                                                                                   
      An error occurred while executing the "cache:warmup" command: 10:03:59 ERRO  
      R     [console] Error thrown while running command "cache:warmup --env=prod  
      ". Message: "[Semantical Error] The annotation "@Sensio\Bundle\FrameworkExt  
      raBundle\Configuration\Route" in method cgoIT\rateit\Controller\AjaxRateItC  
      ontroller::ajaxAction() does not exist, or could not be auto-loaded in /var  
      /www/vhosts/publitiv.net/httpdocs/microsites/vendor/cgo-it/contao-rate-it-b  
      undle/src/Controller/ (which is being imported from "/var/www/vhosts/publit  
      iv.net/httpdocs/microsites/vendor/cgo-it/contao-rate-it-bundle/src/Resource  
      s/config/routing.yml"). Make sure annotations are installed and enabled." [  
      "exception" => Symfony\Component\Config\Exception\LoaderLoadException { …},  
      "command" => "cache:warmup --env=prod","message" => "[Semantical Error] The  
       annotation "@Sensio\Bundle\FrameworkExtraBundle\Configuration\Route" in me  
      thod cgoIT\rateit\Controller\AjaxRateItController::ajaxAction() does not ex  
      ist, or could not be auto-loaded in /var/www/vhosts/publitiv.net/httpdocs/m  
      icrosites/vendor/cgo-it/contao-rate-it-bundle/src/Controller/ (which is bei  
      ng imported from "/var/www/vhosts/publitiv.net/httpdocs/microsites/vendor/c  
      go-it/contao-rate-it-bundle/src/Resources/config/routing.yml"). Make sure a  
      nnotations are installed and enabled."]                                      
                                                                                   
      In FileLoader.php line 166:                                                  
                                                                                   
                                                                                   
        [Semantical Error] The annotation "@Sensio\Bundle\FrameworkExtraBundle\Co  
      nf                                                                           
        iguration\Route" in method cgoIT\rateit\Controller\AjaxRateItController::  
      aj                                                                           
        axAction() does not exist, or could not be auto-loaded in /var/www/vhosts  
      /p                                                                           
        ublitiv.net/httpdocs/microsites/vendor/cgo-it/contao-rate-it-bundle/src/C  
      on                                                                           
        troller/ (which is being imported from "/var/www/vhosts/publitiv.net/http  
      do                                                                           
        cs/microsites/vendor/cgo-it/contao-rate-it-bundle/src/Resources/config/ro  
      ut                                                                           
        ing.yml"). Make sure annotations are installed and enabled.                
                                                                                   
                                                                                   
                                                                                   
                                                                                   
      In AnnotationException.php line 54:                                          
                                                                                   
                                                                                   
        [Semantical Error] The annotation "@Sensio\Bundle\FrameworkExtraBundle\Co  
      nf                                                                           
        iguration\Route" in method cgoIT\rateit\Controller\AjaxRateItController::  
      aj                                                                           
        axAction() does not exist, or could not be auto-loaded.                    
                                                                                   
                                                                                   
                                                                                   
                                                                                   
      cache:warmup [--no-optional-warmers] [-h|--help] [-q|--quiet] [-v|vv|vvv|--  
      verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--en  
      v ENV] [--] <command>                                                        
                                                                                   
    
    install [--prefer-source] [--prefer-dist] [--dry-run] [--dev] [--no-dev] [--no-custom-installers] [--no-autoloader] [--no-scripts] [--no-progress] [--no-suggest] [-v|vv|vvv|--verbose] [-o|--optimize-autoloader] [-a|--classmap-authoritative] [--apcu-autoloader] [--ignore-platform-reqs] [--] [<packages>...]
    
    
    # Process terminated with exit code 1
    # Result: General error
    
    
    ---
    
    ### Der Hintergrundprozess wurde unerwartet beendet ###

  4. #4
    Contao-Fan
    Registriert seit
    17.10.2012.
    Ort
    Bern - Schweiz
    Beiträge
    443

    Standard

    Jetzt sind alle unsere Microsites nicht mehr erreichbar

    Auch die Reparatur ist fehlgeschlagen:
    Code:
    $ /opt/plesk/php/7.2/bin/php -q /var/www/vhosts/publitiv.net/httpdocs/microsites/web/contao-manager.phar.php composer install --prefer-dist --no-dev --no-progress --no-suggest --no-ansi --no-interaction --optimize-autoloader
    
    
    # Process terminated with exit code 143
    # Result: Termination (request to terminate) [signal 15]
    
    
    ---
    
    ### Der Hintergrundprozess wurde unerwartet beendet ###

  5. #5
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    33.896
    Partner-ID
    10107

    Standard

    Bei größeren Updates solltest du das natürlich zuerst lokal testen.

    cgo-it/contao-rate-it-bundle ist aktuell nicht mit Contao 4.8 kompatibel: https://github.com/cgoIT/contao-rate-it-bundle/issues/2

  6. #6
    Contao-Fan
    Registriert seit
    17.10.2012.
    Ort
    Bern - Schweiz
    Beiträge
    443

    Standard

    OK danke Spooky.

    Muss ich den dies gleich entfernen? Das wäre etwas ungünstig, da wir dies im Einsatz haben.
    Besteht eventuell die Möglichkeit das irgendwie OnHold zu setzen damit ich das dann einfach nur updaten kann?

    Die Seiten laufen nun wieder. Jedoch kann ich die DB nicht updaten:

    Code:
    [2020-01-20 09:47:25] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'publi_microsites' AND TABLE_NAME = 'tl_layout' ORDER BY ORDINAL_POSITION ASC AND COLUMN_NAME = 'sections'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /var/www/vhosts/publitiv.net/httpdocs/microsites/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /var/www/vhosts/publitiv.net/httpdocs/microsites/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND COLUMN_NAME = 'sections'' at line 1 at /var/www/vhosts/publitiv.net/httpdocs/microsites/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} []
    Weiss jetzt nicht genau, wie ich weiter vorgehen soll. Hast du mir einen Rat?

  7. #7
    Contao-Fan
    Registriert seit
    17.10.2012.
    Ort
    Bern - Schweiz
    Beiträge
    443

    Standard

    So, habe nun erst auf 4.7 updated und anschliessend auf 4.8, was dann wunderbar funktioniert hat.

    Nun habe ich aber das Problem, dass ich die Datenbank nicht voll aktualisieren kann. Folgende Tasks führen zu einem Fehler:

    Spalten anlegen

    CREATE UNIQUE INDEX url ON tl_search (url)

    CREATE INDEX fromtable ON tl_version (fromtable)

    Code:
    [2020-01-20 13:58:57] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE UNIQUE INDEX url ON tl_search (url)':  SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes." at /var/www/vhosts/example.net/httpdocs/microsites/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'CREATE UNIQUE INDEX url ON tl_search (url)':\n\nSQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. at /var/www/vhosts/publitiv.net/httpdocs/microsites/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. at /var/www/vhosts/example.net/httpdocs/microsites/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. at /var/www/vhosts/example.net/httpdocs/microsites/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)"} []
    Die Websites können momentan nicht aufgerufen werden.

    Hat wer eine Idee, wie ich das wieder richten kann?

    Edit: Ins Backend komme ich rein.

  8. #8
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    33.896
    Partner-ID
    10107

    Standard

    Je nach MySQL Server könnte es sein, dass du folgendes in deine config.yml einfügen musst:
    Code:
    doctrine:
        dbal:
            connections:
                default:
                    default_table_options:
                        charset: utf8
                        collate: utf8_unicode_ci

  9. #9
    Contao-Fan
    Registriert seit
    17.10.2012.
    Ort
    Bern - Schweiz
    Beiträge
    443

    Standard

    Habe das in "/app/config/config.yml" eingetragen, hochgeladen, Cache usw. gelöscht, Install-Tool aufgerufen.

    Leider funktioniert das nicht :-(

    Hab ich das am richtigen Ort rein kopiert?

    P.S Bei einer anderen Plattform mit selber DB hat die Aktualisierung funktioniert.

    Edit: Habe nun alles neu geöffnet und konnte dann das Update durchführen. Hat wunderbar funktioniert. Nun muss ich noch schauen, warum die Websites nicht angezeigt werden. Vielleicht, weil es noch rateIt- Reste rumliegen hat.

    Danke Spooky
    Geändert von Dee (20.01.2020 um 15:34 Uhr)

  10. #10
    Contao-Fan
    Registriert seit
    17.10.2012.
    Ort
    Bern - Schweiz
    Beiträge
    443

    Standard

    Habe nun alles was mit RateIt zusammenhing soweit als möglich gelöscht. Website wird dennoch nicht angezeigt.

    Kriege noch die folgende Meldung unter "var/logs":
    Code:
    [2020-01-20 14:51:04] request.CRITICAL: Uncaught PHP Exception Symfony\Component\Asset\Exception\InvalidArgumentException: "There is no "contao-components/html5shiv" asset package." at /var/www/vhosts/example.net/httpdocs/microsites/vendor/symfony/asset/Packages.php line 78 {"exception":"[object] (Symfony\\Component\\Asset\\Exception\\InvalidArgumentException(code: 0): There is no \"contao-components/html5shiv\" asset package. at /var/www/vhosts/example.net/httpdocs/microsites/vendor/symfony/asset/Packages.php:78)"} []
    Hat wer eine Idee, wie ich diesen Fehler beheben kann?

  11. #11
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    33.896
    Partner-ID
    10107

    Standard

    Du musst dein fe_page Template aktualisieren. Das html5shiv gibt es nicht mehr.

  12. #12
    Contao-Fan
    Registriert seit
    17.10.2012.
    Ort
    Bern - Schweiz
    Beiträge
    443

    Standard

    Danke für den Tipp!
    Habe die Templates gelöscht und nun können die Websites wieder aufgerufen werden.

    Jetzt bin ich trotzdem wieder am Anfang des Weges :-) Leider kann ich keine Pakete mehr installieren. Kriege folgende Fehlermeldung:

    Code:
    Bestätigen & Schließen
    $ /opt/plesk/php/7.3/bin/php -q /var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php composer require heimrichhannot/contao-hyphenator-bundle --no-suggest --no-update --no-scripts --prefer-stable --sort-packages --no-ansi --no-interaction
    
    Using config.component-dir has been deprecated. Please use extra.contao-component-dir instead.
    Using version ^1.9 for heimrichhannot/contao-hyphenator-bundle
    /var/www/vhosts/example.net/httpdocs/microsites/composer.json has been updated
    
    # Process terminated with exit code 0
    # Result: OK
    
    
    > Resolving dependencies using Composer Cloud v2.2.0
    
    # Job ID 9vp4F1ona0ceOa8awJGTDErsutXZrscRbKgpic4MpYyM75lq8t7k3J8Rf9HybWLPbTVjCGLNjYtB3cHE7nzeCkWjJHJI0XOowsDorgED9 completed in 84 seconds
    # Memory usage: 430.66MB (peak: 2007.66MB), time: 84.99s.
    
    $ /opt/plesk/php/7.3/bin/php -q /var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php composer install --prefer-dist --no-dev --no-progress --no-suggest --no-ansi --no-interaction --optimize-autoloader
    
    Using config.component-dir has been deprecated. Please use extra.contao-component-dir instead.
    Loading composer repositories with package information
    Installing dependencies from lock file
    Nothing to install or update
    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
    InvalidArgumentException: Config file "/var/www/vhosts/example.net/httpdocs/microsites/contao-manager/composer-install.set.json" does not exist. in phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/api/Process/AbstractProcess.php:56
    Stack trace:
    #0 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/api/Process/ProcessRunner.php(185): Contao\ManagerApi\Process\AbstractProcess::readConfig('/var/www/vhosts...')
    #1 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/api/Process/ProcessRunner.php(116): Contao\ManagerApi\Process\ProcessRunner->loadConfig()
    #2 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/api/Process/ProcessRunner.php(61): Contao\ManagerApi\Process\ProcessRunner->wait(1)
    #3 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/api/Command/ProcessRunnerCommand.php(46): Contao\ManagerApi\Process\ProcessRunner->run()
    #4 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/vendor/symfony/console/Command/Command.php(255): Contao\ManagerApi\Command\ProcessRunnerCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
    #5 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/vendor/symfony/console/Application.php(1029): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
    #6 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/vendor/symfony/console/Application.php(272): Symfony\Component\Console\Application->doRunCommand(Object(Contao\ManagerApi\Command\ProcessRunnerCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
    #7 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/api/ApiApplication.php(70): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
    #8 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/vendor/symfony/console/Application.php(148): Contao\ManagerApi\ApiApplication->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
    #9 phar:///var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php/api/console(86): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput))
    #10 /var/www/vhosts/example.net/httpdocs/microsites/web/contao-manager.phar.php(57): require('phar:///var/www...')
    #11 {main}
    # Process terminated with exit code 143
    # Result: Termination (request to terminate) [signal 15]
    
    
    ---
    
    ### Der Hintergrundprozess wurde unerwartet beendet ###
    Hast du noch einen Tipp parat?

  13. #13
    Contao-Fan
    Registriert seit
    17.10.2012.
    Ort
    Bern - Schweiz
    Beiträge
    443

    Standard

    Habe nun die config.yml auf Standard zurückgesetzt, also den folgende Code wieder gelöscht:
    Code:
    doctrine:
        dbal:
            connections:
                default:
                    default_table_options:
                        charset: utf8
                        collate: utf8_unicode_ci
    Auch habe ich in der composer.json die PHP-Version angepasst.

    Nun kann ich wieder Pakete installieren und auch die Aktualisierung der DB funktioniert.

    Nun habe ich noch eine allerletzte Frage: Habe nun noch eine "composer2.json". Braucht es diese? Wieso gibt es da nun eine 2?

  14. #14
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    33.896
    Partner-ID
    10107

    Standard

    Die kommt nicht von Contao oder vom Contao Manager.

Aktive Benutzer

Aktive Benutzer

Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)

Lesezeichen

Lesezeichen

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •