OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

Forums Forums OroCRM OroCRM – Installation/Technical Issues or Problems Error updating and installing

This topic contains 0 replies, has 1 voice, and was last updated by  zebrahosting 8 years, 8 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #26621

    zebrahosting
    Participant

    Just managed to install a working OROCRM which seems to run ok and connects to my Magento also fine.
    But when I want to run the update or install a package I get this warning:

    × The command “”/usr/bin/php” “/home/TAO/web/test.taotraining.nl/public_html/crm-application/app/console” cache:clear –no-warmup –env=prod” failed. Exit Code: 255(Unknown error) Output: ================ Error Output: ================ PHP Fatal error: Uncaught exception ‘Doctrine\DBAL\Driver\Mysqli\MysqliException’ with message ‘You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘:jobId, :name, :createdAt, :value)’ at line 1′ in /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94 Stack trace: #0 /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliConnection.php(120): Doctrine\DBAL\Driver\Mysqli\MysqliStatement->__construct(Object(mysqli), ‘INSERT INTO jms…’) #1 /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(86): Doctrine\DBAL\Driver\Mysqli\MysqliConnection->prepare(‘INSERT INTO jms…’) #2 /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(783): Doctrine\DBAL\Statement->__construct(‘INSERT in /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 90

    I see that it is calling /usr/bin/php which should not be necessary (my cron also runs without).
    If I run the command in the console without the first part it opens a > prompt.

    Then I tried to run the update commands from the console:
    composer update (ends fine)

    app/console oro:platform:update ended in drama:

    PHP Fatal error: Uncaught exception ‘Symfony\Component\DependencyInjection\Exception\ParameterNotFoundException’ with message ‘The service “oro_wamp.publisher” has a dependency on a non-existent parameter “websocket_host”.’ in /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBag.php:108
    Stack trace:
    #0 /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBag.php(234): Symfony\Component\DependencyInjection\ParameterBag\ParameterBag->get(‘websocket_host’)
    #1 /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBag.php(205): Symfony\Component\DependencyInjection\ParameterBag\ParameterBag->resolveString(‘%websocket_host…’, Array)
    #2 /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/symfony/symfony/src/Symfony/Component/Dep in /home/TAO/web/test.taotraining.nl/public_html/crm-application/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ParameterBag/ParameterBag.php on line 108

    The CRM is not working anymore. Blank page only.
    Not sure how to go from here.

    Suggestions welcome.

    MySQL version: 5.5.44-0ubuntu0.14.04.1 – (Ubuntu)
    Apache/2.4.7 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/1.0.1f

The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.

Back to top