Whoops, looks like something went wrong.
  • Hello.
    I can't install Newscoop and to be honest I have no idea what this error message means. I need help.


    Whoops, looks like something went wrong.

    2/2DBALException: An exception occurred while executing 'INSERT INTO SystemPreferences (`varname`, `value`, `last_modified`) VALUES ('installation_id', ?, NOW())' with params ["a27a6e79d105ecf929bbe062fe61061232d58c3f"]:

    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'installation_id' for key 'varname'

    1. in /home/cabox/workspace/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91
    2. at DBALException::driverExceptionDuringQuery(object(PDOException), 'INSERT INTO SystemPreferences (`varname`, `value`, `last_modified`) VALUES ('installation_id', ?, NOW())', array('a27a6e79d105ecf929bbe062fe61061232d58c3f')) in /home/cabox/workspace/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 167
    3. at Statement->execute() in /home/cabox/workspace/newscoop/library/Newscoop/Installer/Services/FinishService.php line 227
    4. at FinishService->saveInstanceConfig(array('site_title' => 'title', 'recheck_user_password' => 'pass', 'user_email' => 'email@mail.com'),object(Connection)) in /home/cabox/workspace/newscoop/install/index.php line 346
    5. at {closure}(object(Request))
    6. at call_user_func_array(object(Closure), array(object(Request))) in /home/cabox/workspace/newscoop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 145
    7. at HttpKernel->handleRaw(object(Request), '1') in /home/cabox/workspace/newscoop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 66
    8. at HttpKernel->handle(object(Request), '1', true) in /home/cabox/workspace/newscoop/vendor/silex/silex/src/Silex/Application.php line 543
    9. at Application->handle(object(Request)) in /home/cabox/workspace/newscoop/vendor/silex/silex/src/Silex/Application.php line 520
    10. at Application->run() in /home/cabox/workspace/newscoop/install/index.php line 354

    1/2PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'installation_id' for key 'varname'

    1. in /home/cabox/workspace/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 165
    2. at PDOStatement->execute(null) in /home/cabox/workspace/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 165
    3. at Statement->execute() in /home/cabox/workspace/newscoop/library/Newscoop/Installer/Services/FinishService.php line 227
    4. at FinishService->saveInstanceConfig(array('site_title' => 'title', 'recheck_user_password' => 'pass', 'user_email' => 'email@mail.com'),object(Connection)) in /home/cabox/workspace/newscoop/install/index.php line 346
    5. at {closure}(object(Request))
    6. at call_user_func_array(object(Closure), array(object(Request))) in /home/cabox/workspace/newscoop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 145
    7. at HttpKernel->handleRaw(object(Request), '1') in /home/cabox/workspace/newscoop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 66
    8. at HttpKernel->handle(object(Request), '1', true) in /home/cabox/workspace/newscoop/vendor/silex/silex/src/Silex/Application.php line 543
    9. at Application->handle(object(Request)) in /home/cabox/workspace/newscoop/vendor/silex/silex/src/Silex/Application.php line 520
    10. at Application->run() in /home/cabox/workspace/newscoop/install/index.php line 354
    Post edited by Thiago CB at 2015-05-19 10:03:48
  • 5 Comments sorted by
  • Vote Up0Vote Down Paweł MikołajczukPaweł Mikołajczuk
    Posts: 62Member, Sourcefabric Team
    Hey, 

    just run this sql query (in phpmyadmin)

    DELETE FROM `SystemPreferences` WHERE `varname` = "installation_id"

    and finish installation. 
  • Hello Pawel, I have the same issue but the sql query does not work (Ive used the entry values appearing on my error 'news-NULL' for key 'PRIMARY')

    PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'news-NULL' for key 'PRIMARY'

    and

    DBALException: An
    exception occurred while executing 'INSERT INTO `ArticleTypeMetadata`
    (`type_name`, `field_name`, `field_weight`, `is_hidden`,
    `comments_enabled`, `fk_phrase_id`, `field_type`, `field_type_param`,
    `is_content_field`, `max_size`, `show_in_editor`) VALUES ('news',
    'NULL', NULL, 0, 1, NULL, NULL, NULL, 0, NULL, 1),('news', 'lead', 1, 0,
    0, NULL, 'text', NULL, 0, 160, 0),('news', 'content', 2, 0, 0, NULL,
    'body', 'editor_size=500', 1, NULL, 0);':



    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'news-NULL' for key 'PRIMARY'


    Any help would be appreciated.
  • Hi, Armando Nava, I have the same problem. Could you tell me, how  had you fix yours one? It would be wery helpful! (Sorry for my bad english)
  • I have the same errors, people all ask the same question of how to fix, yet no answers. Shouldn't a script be a lot easier to run than this? I have run into problems with each step. 
  • The work around for this particular error was to install the core.sql file manually. Then run the install script.