Newscoop 4: Error: Importing Database
  • Vote Up0Vote Down TregTreg
    Posts: 2Member

    Hi,

    I'm trying to install Newscoop 4 on a Debian Squeeze (Plesk 10.4 + Nginx) system. I created a MYSQL database prior installation. Everything looks fine but when I entered my database credentials the installation process shows me:

    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 ...

    When I look for the database tables it seems that the database structure was created successfully - wired?!

    One thing is different in my setup. I have to use the Apache port 8080. Therefore, I use an installation URL like: http://subdomain.domain.com:8080/install/index.php I can't imagine, that this might be a problem. What else could it be?

    I read somewhere else something about an MQSQL mode ... As many other webpages with MYSQL database installation worked well, I'm curious that it might be an installation problem.

  • 3 Comments sorted by
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    try to load manually sql statement via mysql utility or phpmyadmin:

    DROP TABLE IF EXISTS `Issues`;
    /*!40101 SET @saved_cs_client     = @@character_set_client */;
    /*!40101 SET character_set_client = utf8 */;
    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;



  • Vote Up0Vote Down TregTreg
    Posts: 2Member

    I tried it and it shows me the message:

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE,
      UNIQUE KEY `ShortName` (`IdPublication`,`IdLanguage`,`ShortName`' at line 13

    These are someof the tables I can see in phphmyadmin:

    acl_role
    acl_rule
    Aliases
    ArticleAttachments
    ArticleAuthors
    ArticleImages
    ArticleIndex
    ArticlePublish
    ArticleRendition
    Articles
    ArticleTopics
    ArticleTypeMetadata
    article_datetimes
    Attachments
    audit_event
    AuthorAliases
    AuthorAssignedTypes
    AuthorBiographies
    Authors
    AuthorTypes
    AutoId
    Cache
    CityLocations
    CityNames
    Classes
    comment
    comment_acceptance
    comment_commenter
    community_ticker_event
    context_articles
    context_boxes
    Countries
    Dictionary
    EnumerationElements
    Enumerations
    Errors
    Events
    FailedLoginAttempts
    ...

    Are these some of the right ones?

    I also checked the users privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE

    I have the mysql + php version: 

    mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
    PHP 5.3.3-7+squeeze9 with Suhosin-Patch (cli) (built: May 9 2012 07:20:37)


  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    you should ask hoster support why this sql statement can not be applied.
Add a Comment