× Warning! This forum is in archival status. New contributions may not work.
Newscoop installation error.SQLSTATE[42000]: Specified key was too long; max key length is 1000 byte
  • During installation CMS Newscoop error:

    PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes' in /var/www/mysite.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:633\nStack trace:\n#0 /var/www/mysite.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(633): PDO->query('CREATE TABLE IF...')\n#1 /var/www/mysite.com/library/Newscoop/Doctrine/AdoDbAdapter.php(66): Doctrine\\DBAL\\Connection->executeQuery('CREATE TABLE IF...', Array)\n#2 /var/www/mysite.com/install/classes/CampInstallationBase.php(971): Newscoop\\Doctrine\\AdoDbAdapter->execute('CREATE TABLE IF...')\n#3 /var/www/mysite.com/install/classes/CampInstallationBase.php(262): CampInstallationBaseHelper::ImportDB('/var/www/uain.t...', Array)\n#4 /var/www/mysite.com/install/classes/CampInstallationBase.php(91): CampInstallationBase->databaseConfiguration(Array)\n#5 /var/www/mysite.com/install/classes/CampInstallation.php(96): CampInstallationBase->execute()\n#6 /var/www/mysite.com/install/index.php(86): CampIn in /var/www/mysite.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php on line 633, referer: http://mysite.com/install/index.php

    Please help to remove this error.
    Post edited by Vladislav R at 2014-06-01 14:44:55
  • 2 Comments sorted by
  • Hi,
    please specify which Newscoop release was used, and what is your setup/hosting plan
    --
    Ljuba Rankovic
    Senior Front End Developer, Sourcefabric
    ljuba.rankovic@sourcefabric.org

    http://www.sourcefabric.org
    http://www.twitter.com/Sourcefabric
  • Hello.
    I'm using last version this CMS on VPS server.