Baikal - Update (Linux)

Von Version 0.2.7 auf Version 0.7.1

Download

https://github.com/sabre-io/Baikal/releases

cd ~/temp
wget https://github.com/sabre-io/Baikal/releases/download/0.7.1/baikal-0.7.1.zip

Installation

unzip baikal-0.7.1.zip
sudo mv baikal /mnt/synology/web1/www/baikal0_7_1
cd /mnt/synology/web1/www/
sudo chown -R www-data:www-data baikal0_7_1

sudo mv baikal baikal_bak
sudo ln -s baikal0_7_1 baikal 

Upgrade

The constant PROJECT_DB_MYSQL_HOST, containing the MySQL host name, is not set.

Die Datei

sudo vi /mnt/synology/web1/www/bakail/config/baikal.yaml

bearbeiten und folgende Variablen anpassen:

mysql_host: ''
mysql_dbname: ''
mysql_username: ''
mysql_password: ''

SQL-Syntax-Errors

Remove all asc within

sudo vi /mnt/synology/web1/www/baikal0_7_1/Core/Frameworks/BaikalAdmin/Controller/Install/VersionUpgrade.php

At lines 225, 260 change the lines (adding length for unique part):

    $pdo->exec("CREATE INDEX principaluri_uri ON calendarsubscriptions (principaluri(360), uri(360));");
    $pdo->exec('CREATE UNIQUE INDEX path_property ON propertystorage (path(360), name(360));');         

Add following statement

$pdo->exec('ALTER TABLE propertystorage DROP PRIMARY KEY, MODIFY id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;'); 

at line 299;

At line 373 change the lines (adding default value for 'id' and length for text unique part):

    id integer primary key NOT NULL AUTO_INCREMENT,
    UNIQUE (principaluri(255), uri(255)),
    UNIQUE (calendarid, principaluri(255)), 

Links

https://sabre.io/baikal/upgrade/

Zurück zu Baikal