Проблема при установке
  • Vote Up0Vote Down Alexander EsinAlexander Esin
    Posts: 5Member

    Всем привет

    Такая проблема: ввожу данные для подключения к базе, запускаю установку и получаю:

    PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '********_nc.Versions' doesn't exist


    Что может быть?
  • 10 Comments sorted by
  • Vote Up0Vote Down Alexander EsinAlexander Esin
    Posts: 5Member
    И еще:

    DBALException: An exception occurred while executing 'INSERT INTO Versions (ver_name, ver_value) VALUES ("last_db_version", ?) ON DUPLICATE KEY UPDATE ver_value = ?' with params ["4.4.x", "4.4.x"]:

    SQLSTATE[42S02]: Base table or view not found: 1146 Table '***********_nc.Versions' doesn't exist

  • Vote Up0Vote Down Alexander EsinAlexander Esin
    Posts: 5Member
    Исправил ошибки отредактировав campsite_core.sql (удалил команду SET вверху).
    Установка пошла, но "не дошла:

    RuntimeException:

    1. in /home/public_html/library/Newscoop/Installer/Services/FinishService.php line 55
    2. at FinishService->generateProxies() in /home/public_html/install/index.php line 344
    3. at {closure}(object(Request))
    4. at call_user_func_array(object(Closure), array(object(Request))) in /home/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 145
    5. at HttpKernel->handleRaw(object(Request), '1') in /home/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 66
    6. at HttpKernel->handle(object(Request), '1', true) in /home/public_html/vendor/silex/silex/src/Silex/Application.php line 547
    7. at Application->handle(object(Request)) in /home/public_html/vendor/silex/silex/src/Silex/Application.php line 524
    8. at Application->run() in /home/public_html/install/index.php line 354
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    попробуйте в /etc/mysql/my.cnf  найти sql-mode= и установить sql-mode=""
    рестартуйте mysql и пробуйте установить без всяких хаков
  • Vote Up0Vote Down Robin HästRobin Häst
    Posts: 2Member
    Used a translator to see what was written..

    I'm experiencing the same problem as the first and second post during the installation phase.

    The installer says everything is fine, prompts me for Server name, Port, User name, Password, Database and if I want to overwrite existing database (tried with both options).

    This file: /etc/mysql/my.cnfdows not contain these lines of code: sql-mode= and sql-mode="". I tried adding them (could have been a bit lost in translation) but it didn't help.

    Any help would be greatly appreciated!

    Thank you!
  • Vote Up0Vote Down Robin HästRobin Häst
    Posts: 2Member
    Uploaded a screenshot of the error:

    Screenshot from 2016-04-19 00-37-02.png
    1301 x 744 - 198K
    Screenshot from 2016-04-19 00-36-30.png
    1301 x 744 - 164K
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    it depends on where you have placed sql-mode option
    The correct is in [mysqld] section:

    [mysqld]
    #
    # * Basic Settings
    #

    sql-mode=""

    Post edited by Andrey Podshivalov at 2016-04-19 03:24:11
  • Vote Up0Vote Down synthorgsynthorg
    Posts: 6Member
    Столкнулся с такой же проблемой.
    Внёс в /etc/mysql/my.cnf  параметр sql-mode=""
    Всё равно выдаёт ошибку.

    2/2DBALException: An exception occurred while executing 'INSERT INTO Versions (ver_name, ver_value) VALUES ("last_db_version", ?) ON DUPLICATE KEY UPDATE ver_value = ?' with params ["4.4.x", "4.4.x"]:

    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'admin_gazeta.Versions' doesn't exist

    1. in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
    2. at DBALException::driverExceptionDuringQuery(object(PDOException), 'INSERT INTO Versions (ver_name, ver_value) VALUES ("last_db_version", ?) ON DUPLICATE KEY UPDATE ver_value = ?', array('4.4.x', '4.4.x')) in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 702
    3. at Connection->executeQuery('INSERT INTO Versions (ver_name, ver_value) VALUES ("last_db_version", :version) ON DUPLICATE KEY UPDATE ver_value = :version', array('version' => '4.4.x')) in /home/admin/web/test.gazeta-gran.ru/public_html/library/Newscoop/Installer/Services/DatabaseService.php line 502
    4. at DatabaseService->saveDatabaseVersion(object(Connection), '4.4.x', '2015.10.29') in /home/admin/web/test.gazeta-gran.ru/public_html/library/Newscoop/Installer/Services/DatabaseService.php line 82
    5. at DatabaseService->fillNewscoopDatabase(object(Connection)) in /home/admin/web/test.gazeta-gran.ru/public_html/install/index.php line 254
    6. at {closure}(object(Request))
    7. at call_user_func_array(object(Closure), array(object(Request))) in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 145
    8. at HttpKernel->handleRaw(object(Request), '1') in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 66
    9. at HttpKernel->handle(object(Request), '1', true) in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/silex/silex/src/Silex/Application.php line 547
    10. at Application->handle(object(Request)) in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/silex/silex/src/Silex/Application.php line 524
    11. at Application->run() in /home/admin/web/test.gazeta-gran.ru/public_html/install/index.php line 354

    1/2PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'admin_gazeta.Versions' doesn't exist

    1. in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 694
    2. at PDOStatement->execute() in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 694
    3. at Connection->executeQuery('INSERT INTO Versions (ver_name, ver_value) VALUES ("last_db_version", :version) ON DUPLICATE KEY UPDATE ver_value = :version', array('version' => '4.4.x')) in /home/admin/web/test.gazeta-gran.ru/public_html/library/Newscoop/Installer/Services/DatabaseService.php line 502
    4. at DatabaseService->saveDatabaseVersion(object(Connection), '4.4.x', '2015.10.29') in /home/admin/web/test.gazeta-gran.ru/public_html/library/Newscoop/Installer/Services/DatabaseService.php line 82
    5. at DatabaseService->fillNewscoopDatabase(object(Connection)) in /home/admin/web/test.gazeta-gran.ru/public_html/install/index.php line 254
    6. at {closure}(object(Request))
    7. at call_user_func_array(object(Closure), array(object(Request))) in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 145
    8. at HttpKernel->handleRaw(object(Request), '1') in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 66
    9. at HttpKernel->handle(object(Request), '1', true) in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/silex/silex/src/Silex/Application.php line 547
    10. at Application->handle(object(Request)) in /home/admin/web/test.gazeta-gran.ru/public_html/vendor/silex/silex/src/Silex/Application.php line 524
    11. at Application->run() in /home/admin/web/test.gazeta-gran.ru/public_html/install/index.php line 354

  • Vote Up0Vote Down EasyscribblerEasyscribbler
    Posts: 3Member
    Точно такая же проблема, как у Alexander Esin.
    Александр, поделитесь, пожалуйста, получилось у вас установить-таки Newscoop? Что конкретно вы делали, чтобы полностью решить проблемы:

    PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '********_nc.Versions' doesn't exist

    DBALException: An exception occurred while executing 'INSERT INTO Versions (ver_name, ver_value) VALUES ("last_db_version", ?) ON DUPLICATE KEY UPDATE ver_value = ?' with params ["4.4.x", "4.4.x"]:

    SQLSTATE[42S02]: Base table or view not found: 1146 Table '***********_nc.Versions' doesn't exi


    Я так понимаю, правки в campsite_core.sql не дали полного решения?
  • Vote Up0Vote Down Butov StanislavButov Stanislav
    Posts: 112Member
    Коллеги, версия Мускула какая?
  • Vote Up0Vote Down EasyscribblerEasyscribbler
    Posts: 3Member
    Butov Stanislav, 5.0.11
Add a Comment