Problem installing Newscoop 4.0 via Plesk
  • Vote Up0Vote Down letterproefletterproef
    Posts: 14Member
    All,

    Whenever I try to install Newscoop via Plesk I get this error:

     

    Error: Importing Database
    CREATE TABLE `Issues` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `IdPublication` int(10) unsigned NOT NULL DEFAULT '0',
    `Number` int(10) unsigned NOT NULL DEFAULT '0',
    `IdLanguage` int(10) unsigned NOT NULL DEFAULT '0',
    `Name` varchar(140) NOT NULL DEFAULT '',
    `PublicationDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `Published` enum('N','Y') NOT NULL DEFAULT 'N',
    `IssueTplId` int(10) unsigned DEFAULT NULL,
    `SectionTplId` int(10) unsigned DEFAULT NULL,
    `ArticleTplId` int(10) unsigned DEFAULT NULL,
    `ShortName` varchar(32) NOT NULL DEFAULT '',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `ShortName` (`IdPublication`,`IdLanguage`,`ShortName`),
    UNIQUE KEY `issue_unique` (`IdPublication`,`Number`,`IdLanguage`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8
    --
    -- Dumping data for table `Issues`
    --

    LOCK TABLES `Issues` WRITE
    /*!40000 ALTER TABLE `Issues` DISABLE KEYS */
    /*!40000 ALTER TABLE `Issues` ENABLE KEYS */
    CREATE TABLE `Sections` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `fk_issue_id` int(10) unsigned NOT NULL,
    `IdPublication` int(10) unsigned NOT NULL DEFAULT '0',
    `NrIssue` int(10) unsigned NOT NULL DEFAULT '0',
    `IdLanguage` int(10) unsigned NOT NULL DEFAULT '0',
    `Number` int(10) unsigned NOT NULL DEFAULT '0',
    `Name` varchar(255) NOT NULL DEFAULT '',
    `ShortName` varchar(32) NOT NULL DEFAULT '',
    `Description` blob,
    `SectionTplId` int(10) unsigned DEFAULT NULL,
    `ArticleTplId` int(10) unsigned DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `IdPublication` (`IdPublication`,`NrIssue`,`IdLanguage`,`Name`),
    UNIQUE KEY `ShortName` (`IdPublication`,`NrIssue`,`IdLanguage`,`ShortName`),
    UNIQUE KEY `section_unique` (`IdPublication`,`NrIssue`,`IdLanguage`,`Number`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8
    --
    -- Dumping data for table `Sections`
    --

    LOCK TABLES `Sections` WRITE
    /*!40000 ALTER TABLE `Sections` DISABLE KEYS */
    /*!40000 ALTER TABLE `Sections` ENABLE KEYS */


    FYI: I tried to install Newscoop as follows:

    1. FTP'ed all the files to httpdocs at server.

    2. System requirements are met

    3. Clicked next, agreed with the terms

    4. Created a database via Plesk and created a user/password

    5. Returned to installation screen, filled in correct username/password and database

    6. An error - see above - returned.

    Is someone able to pinpoint the problem and possibly the solution?


    Regards,

    Jelle


  • 7 Comments sorted by
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    It's just a sql code. You can try to execute this code in phpmyadmin and check is there any error message.
  • Vote Up0Vote Down letterproefletterproef
    Posts: 14Member
    I have emptied the database via phpyadmin, then tried to import campsite_core.sql in the database. This also rendered a error message. Saying that there's a syntax error. :/
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    it seems that mysql server is configured to run in compatible mode. Consult with hosting support.
  • Vote Up0Vote Down letterproefletterproef
    Posts: 14Member
    Can you explain a bit more about compatible mode?

  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
    but any way you need to ask hosting support to resolve this issue because dump file is ok in case  mysql standard configuration.

  • Vote Up0Vote Down letterproefletterproef
    Posts: 14Member
    Thanks a lot, I will try to see if the manual can provide a solution, but siince I am a noob with mysql maybe it's best if I ask the hoster to resolve the problem. Again, thanks a lot!
  • Vote Up0Vote Down letterproefletterproef
    Posts: 14Member
    Turned out it was an issue with MySQL. Error code 1064 corresponds to a version mismatch. Asked the hoster to update to MySQL 5.1 (from v.5.0) and installation went smooth.
Add a Comment