Проблема при установке
  • Всем привет

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

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


    Что может быть?
  • 10 Comments sorted by
  • И еще:

    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

  • Исправил ошибки отредактировав 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 и пробуйте установить без всяких хаков
  • 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!
  • Uploaded a screenshot of the error:

  • 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
  • Столкнулся с такой же проблемой.
    Внёс в /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

  • Точно такая же проблема, как у 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 не дали полного решения?
  • Коллеги, версия Мускула какая?