Update the engine from 4.2.4 to 4.4.3 (or latest)
  • Help me to update the engine from 4.2.4 to 4.4.3
    Post edited by Andrei S. at 2015-06-02 02:48:11
  • 14 Comments sorted by
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    try to install 4.4 and restore backup from 4.2
    Post edited by Andrey Podshivalov at 2015-06-02 04:48:54
  • will be 4.4 installed without any problems after 4.2?
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    install 4.4 in separate alias. do not upgrade directly 4.2 
    You need to test 4.4 version (with restored data) before using as live site.
  • 4.4.3 was installed. I have restored backup4.2.4 in the adminpanel newscoop. And now I have blank page in mysite and in mysite/admin.
    What is happened?
    Post edited by Andrei S. at 2015-06-02 08:32:20
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    add into .htaccess

    SetEnv APPLICATION_ENV dev

  • A now I have in browser:

    Whoops, looks like something went wrong.



    1/1 ClassNotFoundException:
    Attempted to load class "RaulFraileLadybugBundle" from namespace
    "RaulFraile\Bundle\LadybugBundle" in
    /var/www/newscoop/application/AppKernel.php line 57. Do you need to
    "use" it from another namespace?




    1. in /var/www/newscoop/application/AppKernel.php line 57




  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    run from newscoop root

    ./composer.phar install
  • Full crush!
    >-)
    A lot of failes during './composer.phar install' such as:
    Failed to download phpspec/prophecy from source: Failed to clone git@github.com:phpspec/prophecy.git, git was not found, check that it is installed and in your PATH env.

    sh: 1: git: not found

        Now trying to download from dist
    And in the end:
    Package friendsofsymfony/rest is abandoned, you should avoid using it. No replacement was suggested.
    Package guzzle/common is abandoned, you should avoid using it. Use guzzle/guzzle instead.
    Package guzzle/stream is abandoned, you should avoid using it. Use guzzle/guzzle instead.
    Package guzzle/parser is abandoned, you should avoid using it. Use guzzle/guzzle instead.
    Package guzzle/http is abandoned, you should avoid using it. Use guzzle/guzzle instead.
    And Now browser says:
    Whoops, looks like something went wrong.

    1/1 ContextErrorException: Notice: date_default_timezone_set(): Timezone ID '+3' is invalid in /var/www/newscoop/include/campsite_init.php line 38



    Post edited by Andrei S. at 2015-06-02 09:15:58
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    1/1 ContextErrorException: Notice: date_default_timezone_set(): Timezone ID '+3' is invalid in /var/www/newscoop/include/campsite_init.php line 38


    so, resolve it
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    run sql command:

    update SystemPreferences set value = 'UTC' where varname = 'TimeZone'
  • In the mysql console:
    mysql> update SystemPreferences set value = 'UTC' where varname = 'TimeZone'\g
    ERROR 1046 (3D000): No database selected

    Whre is it necceury to specify DB name?


  • Sql command has peformed.
    Now:
    3/3 Zend_Controller_Exception: An exception occurred while executing 'SELECT p0_.Id AS Id0, p0_.Name AS Name1, p0_.comments_public_enabled AS comments_public_enabled2, p0_.comments_moderator_to AS comments_moderator_to3, p0_.comments_moderator_from AS comments_moderator_from4, p0_.IdDefaultAlias AS IdDefaultAlias5, p0_.IdURLType AS IdURLType6, p0_.fk_forum_id AS fk_forum_id7, p0_.comments_enabled AS comments_enabled8, p0_.comments_article_default_enabled AS comments_article_default_enabled9, p0_.comments_subscribers_moderated AS comments_subscribers_moderated10, p0_.comments_public_moderated AS comments_public_moderated11, p0_.comments_captcha_enabled AS comments_captcha_enabled12, p0_.comments_spam_blocking_enabled AS comments_spam_blocking_enabled13, p0_.url_error_tpl_id AS url_error_tpl_id14, p0_.seo AS seo15, p0_.meta_title AS meta_title16, p0_.meta_keywords AS meta_keywords17, p0_.meta_description AS meta_description18, i1_.id AS id19, i1_.Number AS Number20, i1_.Name AS Name21, i1_.Published AS Published22, i1_.ShortName AS ShortName23, s2_.id AS id24, s2_.Number AS Number25, s2_.Name AS Name26, s2_.ShortName AS ShortName27 FROM Publications p0_ LEFT JOIN Issues i1_ ON p0_.Id = i1_.IdPublication LEFT JOIN Sections s2_ ON i1_.id = s2_.fk_issue_id':

    SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p0_.meta_title' in 'field list'#0 /var/www/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT p0_.Id A...', Array)
    #1 /var/www/newscoop/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT p0_.Id A...', Array, Array, NULL)
    #2 /var/www/newscoop/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
    #3 /var/www/newscoop/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query->_doExecute()
    #4 /var/www/newscoop/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(586): Doctrine\ORM\AbstractQuery->execute(NULL, 2)
    #5 /var/www/newscoop/src/Newscoop/NewscoopBundle/Menu/Builder.php(268): Doctrine\ORM\AbstractQuery->getArrayResult()
    #6 /var/www/newscoop/src/Newscoop/NewscoopBundle/Menu/Builder.php(122): Newscoop\NewscoopBundle\Menu\Builder->prepareContentMenu(Object(Knp\Menu\MenuItem), false)
    #7 /var/www/newscoop/cache/dev/applicationDevDebugProjectContainer.php(4535): Newscoop\NewscoopBundle\Menu\Builder->mainMenu()
    #8 /var/www/newscoop/application/bootstrap.php.cache(2090): applicationDevDebugProjectContainer->getNewscoopNewscoop_Menu_MainService()
    #9 /var/www/newscoop/vendor/knplabs/knp-menu-bundle/Provider/ContainerAwareProvider.php(25): Symfony\Component\DependencyInjection\Container->get('newscoop_newsco...')
    #10 /var/www/newscoop/vendor/knplabs/knp-menu/src/Knp/Menu/Provider/ChainProvider.php(21): Knp\Bundle\MenuBundle\Provider\ContainerAwareProvider->get('main', Array)
    #11 /var/www/newscoop/application/layouts/scripts/admin_menu.phtml(2): Knp\Menu\Provider\ChainProvider->get('main')
    #12 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/View.php(108): include('/var/www/newsco...')
    #13 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/View/Abstract.php(888): Zend_View->_run('/var/www/newsco...')
    #14 /var/www/newscoop/application/layouts/scripts/admin.phtml(111): Zend_View_Abstract->render('admin_menu.phtm...')
    #15 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/View.php(108): include('/var/www/newsco...')
    #16 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/View/Abstract.php(888): Zend_View->_run('/var/www/newsco...')
    #17 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/Layout.php(796): Zend_View_Abstract->render('admin.phtml')
    #18 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/Layout/Controller/Plugin/Layout.php(143): Zend_Layout->render()
    #19 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/Controller/Plugin/Broker.php(333): Zend_Layout_Controller_Plugin_Layout->postDispatch(Object(Zend_Controller_Request_Http))
    #20 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/Controller/Front.php(965): Zend_Controller_Plugin_Broker->postDispatch(Object(Zend_Controller_Request_Http))
    #21 /var/www/newscoop/src/Newscoop/ZendBridgeBundle/Controller/BridgeController.php(59): Zend_Controller_Front->dispatch()
    #22 [internal function]: Newscoop\ZendBridgeBundle\Controller\BridgeController->indexAction(Object(Symfony\Component\HttpFoundation\Request))
    #23 /var/www/newscoop/application/bootstrap.php.cache(3008): call_user_func_array(Array, Array)
    #24 /var/www/newscoop/application/bootstrap.php.cache(2970): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
    #25 /var/www/newscoop/application/bootstrap.php.cache(3119): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
    #26 /var/www/newscoop/application/bootstrap.php.cache(2368): Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
    #27 /var/www/newscoop/public/index.php(69): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
    #28 /var/www/newscoop/admin.php(2): require_once('/var/www/newsco...')
    #29 {main}

    2/3 DBALException: An exception occurred while executing 'SELECT p0_.Id AS Id0, p0_.Name AS Name1, p0_.comments_public_enabled AS comments_public_enabled2, p0_.comments_moderator_to AS comments_moderator_to3, p0_.comments_moderator_from AS comments_moderator_from4, p0_.IdDefaultAlias AS IdDefaultAlias5, p0_.IdURLType AS IdURLType6, p0_.fk_forum_id AS fk_forum_id7, p0_.comments_enabled AS comments_enabled8, p0_.comments_article_default_enabled AS comments_article_default_enabled9, p0_.comments_subscribers_moderated AS comments_subscribers_moderated10, p0_.comments_public_moderated AS comments_public_moderated11, p0_.comments_captcha_enabled AS comments_captcha_enabled12, p0_.comments_spam_blocking_enabled AS comments_spam_blocking_enabled13, p0_.url_error_tpl_id AS url_error_tpl_id14, p0_.seo AS seo15, p0_.meta_title AS meta_title16, p0_.meta_keywords AS meta_keywords17, p0_.meta_description AS meta_description18, i1_.id AS id19, i1_.Number AS Number20, i1_.Name AS Name21, i1_.Published AS Published22, i1_.ShortName AS ShortName23, s2_.id AS id24, s2_.Number AS Number25, s2_.Name AS Name26, s2_.ShortName AS ShortName27 FROM Publications p0_ LEFT JOIN Issues i1_ ON p0_.Id = i1_.IdPublication LEFT JOIN Sections s2_ ON i1_.id = s2_.fk_issue_id':

    SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p0_.meta_title' in 'field list'

    1/3 PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p0_.meta_title' in 'field list'
    Post edited by Andrei S. at 2015-06-02 13:26:00
  • I can't decide wihout any help
    :-L
  • Is there the problem in plugins?