4.4.7 db missing fields
  • Vote Up0Vote Down mariamaria
    Posts: 38Member
    i am having an error
     Column not found: 1054 Unknown column 't0.fk_output_id' in table output_publication

    and here is the script that generate the output_publication table

    DROP TABLE IF EXISTS `output_publication`;
    CREATE TABLE `output_publication` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `fk_publication_id` int(11) unsigned NOT NULL,
      `fk_language_id` int(11) unsigned NOT NULL,
      `theme_path` varchar(255) NOT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `publication_language` (`fk_publication_id`,`fk_language_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    --
  • 1 Comment sorted by
  • helped me  - 
    cd /var/www/newscoop
    php -r "readfile('https://getcomposer.org/installer');" | php