Database column missing with new site
  • Vote Up0Vote Down Paul GillingwaterPaul Gillingwater
    Posts: 2Member
    I just installed a new site, created a publication and issue, and then created an article.

    Nothing appears on the primary site, and in the error log I see the following error:







    p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 16.0px Courier; color: #fff0a5; background-color: #13773d}
    span.s1 {font-variant-ligatures: no-common-ligatures}



    [Thu Dec 08 15:18:46.315042 2016] [:error] [pid 27610] [client 188.22.173.92:54260] Newscoop error: Undefined variable: sectionObj in /var/www/newscoop/admin-files/articles/duplicate.php:464, referer: http://centralnews.site/admin/articles/duplicate.php?security_token=1PKP63anUPGZOHtNaD8S1vnrVVCr4tC6&f_publication_id=1&f_issue_number=0&f_section_number=0&f_language_id=1&f_language_selected=1&f_article_number=1&f_action=&f_action_workflow=Y&f_article_code[]=1_1&f_mode=single&f_action=publish

  • 2 Comments sorted by
  • Vote Up0Vote Down Paul GillingwaterPaul Gillingwater
    Posts: 2Member
    Here's the error message with the column missing:







    p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 16.0px Courier; color: #fff0a5; background-color: #13773d}
    span.s1 {font-variant-ligatures: no-common-ligatures}



    [Thu Dec 08 14:45:00.099424 2016] [:error] [pid 7906] [client 188.22.173.92:52915] PHP Fatal error:  Uncaught except


    ion 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.fk_output_id' in 'field 


    list'' in /var/www/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:694\nStack trace:\n#0 /var/www/new


    scoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(694): PDOStatement->execute()\n#1 /var/www/newscoop/vend


    or/doctrine/orm/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php(748): Doctrine\\DBAL\\Connection->executeQuery(


    'SELECT t0.id AS...', Array, Array)\n#2 /var/www/newscoop/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(


    196): Doctrine\\ORM\\Persisters\\BasicEntityPersister->load(Array, NULL, NULL, Array, 0, 1, NULL)\n#3 /var/www/newsc


    oop/src/Newscoop/NewscoopBundle/Form/Type/PublicationType.php(68): Doctrine\\ORM\\EntityRepository->findOneBy(Array)


    \n#4 /var/www/newscoop/vendor/symfony/symfony/src/Symfony/Component/Form/ResolvedFormType.php(140): Newscoop\\Newsco


    opBundle\\Form\\Type\\PublicationType->buildForm(Object(Symfony\\Component\\Form\\FormBuilder), Array in /var/www/ne


    wscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91

  • Vote Up0Vote Down James BrabsonJames Brabson
    Posts: 16Member
    Check out the fix I posted here: https://forum.sourcefabric.org/discussion/comment/34963#Comment_34963, it looks like it's probably the same error. Best of luck!
Add a Comment