Hello, I tried to install latest version of Roadiz and it's impossible 🙁
I tried to install it on 3 different environments local (MAMP), local (Fedora) and webhosting, but still the same error 🙁
I have a lot of local sites with Roadiz on those environments and all installations were OK.
please, could you help me or fix it?
thx Roman
Database could not be installed
Your database could not be installed due to following errors. Verify your database credentials or if database has been installed yet.
Cannot connect to database
An exception occurred while executing 'CREATE TABLE settings (id INT AUTO_INCREMENT NOT NULL, setting_group_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, value LONGTEXT DEFAULT NULL, visible TINYINT(1) DEFAULT '1' NOT NULL, type INT NOT NULL, defaultValues LONGTEXT DEFAULT NULL, UNIQUE INDEX UNIQ_E545A0C55E237E06 (name), INDEX IDX_E545A0C550DDE1BD (setting_group_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes #0 /home/creativ8/public_html/idesign.ooo/standard-edition/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(184): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException)) #1 /home/creativ8/public_html/idesign.ooo/standard-edition/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(158): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'An exception oc...') #2 /home/creativ8/public_html/idesign.ooo/standard-edition/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1124): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'CREATE TABLE se...') #3 /home/creativ8/public_html/idesign.ooo/standard-edition/vendor/roadiz/roadiz/src/Roadiz/Utils/Doctrine/SchemaUpdater.php(103): Doctrine\DBAL\Connection->exec('CREATE TABLE se...') #4 /home/creativ8/public_html/idesign.ooo/standard-edition/vendor/roadiz/roadiz/themes/Install/Controllers/DatabaseController.php(144): RZ\Roadiz\Utils\Doctrine\SchemaUpdater->updateSchema() #5 /home/creativ8/public_html/idesign.ooo/standard-edition/vendor/symfony/http-kernel/HttpKernel.php(151): Themes\Install\Controllers\DatabaseController->databaseSchemaAction(Object(RZ\Roadiz\Core\HttpFoundation\Request)) #6 /home/creativ8/public_html/idesign.ooo/standard-edition/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(RZ\Roadiz\Core\HttpFoundation\Request), 1) #7 /home/creativ8/public_html/idesign.ooo/standard-edition/vendor/roadiz/roadiz/src/Roadiz/Core/Kernel.php(335): Symfony\Component\HttpKernel\HttpKernel->handle(Object(RZ\Roadiz\Core\HttpFoundation\Request), 1, true) #8 /home/creativ8/public_html/idesign.ooo/standard-edition/web/install.php(65): RZ\Roadiz\Core\Kernel->handle(Object(RZ\Roadiz\Core\HttpFoundation\Request)) #9 {main}