2/2DBALException: An exception occurred while executing 'INSERT INTO Versions (ver_name, ver_value)
  • Vote Up0Vote Down manfromnepalmanfromnepal
    Posts: 3Member

    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 'mysite_site.Versions' doesn't exist


    in /home/mysite/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
    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/mysite/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 702
    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/mysite/public_html/library/Newscoop/Installer/Services/DatabaseService.php line 502
    at DatabaseService->saveDatabaseVersion(object(Connection), '4.4.x', '2015.10.29') in /home/mysite/public_html/library/Newscoop/Installer/Services/DatabaseService.php line 82
    at DatabaseService->fillNewscoopDatabase(object(Connection)) in /home/mysite/public_html/install/index.php line 254
    at {closure}(object(Request))
    at call_user_func_array(object(Closure), array(object(Request))) in /home/mysite/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 145
    at HttpKernel->handleRaw(object(Request), '1') in /home/mysite/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 66
    at HttpKernel->handle(object(Request), '1', true) in /home/mysite/public_html/vendor/silex/silex/src/Silex/Application.php line 547
    at Application->handle(object(Request)) in /home/mysite/public_html/vendor/silex/silex/src/Silex/Application.php line 524
    at Application->run() in /home/mysite/public_html/install/index.php line 354

    Cannot install the latest version of newscoop, anybody helps please. 
    Post edited by manfromnepal at 2016-08-01 23:16:08
  • 1 Comment sorted by
  • Vote Up0Vote Down Simon MoriceSimon Morice
    Posts: 15Member
    This appears to be a mysql account permissions issue. I used mysql Workbench to give it all permissions and the install continued. I am quite sure this is not safe but I could find no other way.
Add a Comment