MySQL key length error during installation

[rene8686]

Hello,
got a strange issue.

I'm trying to install Baikal server on a Windows Server 2012 r2 machine with IIS8.5 and MySQL.

When I create a subdomain for the Baikal server I can't access the site, I need to lower the php version from 5.6 to 5.4 which is ok.

Than I can install the Application and everything themes to work. But when logging in to the admin area I get this error: (evwnthough I get the message, that Baikal Server has benn properly installed and is running.

exception 'Exception' with message 'SQL ERROR in: 'SELECT count() as nbitems
FROM calendars
WHERE
1=1'; Message: Array
(
[0] => 42S02
[1] => 1146
[2] => Table 'baikal.calendars' doesn't exist
)
' in D:\webroot\baikal\Core\Frameworks\Flake\Core\Database.php:181
Stack trace:
#0 D:\webroot\baikal\Core\Frameworks\Flake\Core\Requester\Sql.php(201): Flake\Core\Database->query('SELECT count()...')
#1 D:\webroot\baikal\Core\Frameworks\BaikalAdmin\Controller\Dashboard.php(48): Flake\Core\Requester\Sql->count()
#2 D:\webroot\baikal\Core\Frameworks\Flake\Core\Render\Container.php(70): BaikalAdmin\Controller\Dashboard->render()
#3 D:\webroot\baikal\Core\Frameworks\Flake\Controller\Page.php(84): Flake\Core\Render\Container->renderBlocks()
#4 D:\webroot\baikal\admin\index.php(81): Flake\Controller\Page->render()
#5 {main}

I did it several times, no change.

I downloaded the Version from the website. (0.2.7)

Anyone an idea?

Thanks!

[alexanderschnitzler]

I had the same issue and it was because of a silently failing installation process.

I simply executed all sql queries manually. To be found here:
Core/Resources/Db/MySQL/db.sql

Afterwards everything went just fine.

[18seven]

thx alexanderschnitzler .

failed here

mysql> CREATE TABLE IF NOT EXISTS locks (
    ->     id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    ->     owner VARCHAR(100),
    ->     timeout INTEGER UNSIGNED,
    ->     created INTEGER,
    ->     token VARCHAR(100),
    ->     scope TINYINT,
    ->     depth TINYINT,
    ->     uri VARCHAR(1000),
    ->     INDEX(token),
    ->     INDEX(uri)
    -> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

[evert]

Will be fixed once we update to sabre/dav 3.1