Baikal - Update (Linux)
Version vom 2. August 2020, 08:45 Uhr von Martin Kirner (Diskussion | Beiträge) (→SQL-Syntax-Errors)
Noch in Bearbeitung
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
Comment out line 225, 260:
// $pdo->exec("CREATE INDEX principaluri_uri ON calendarsubscriptions (principaluri, uri);"); // $pdo->exec('CREATE UNIQUE INDEX path_property ON propertystorage (path, name);');
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 387 change the lines (adding length for unique part):
UNIQUE (principaluri(255), uri(255)), UNIQUE (calendarid, principaluri(255)),
Links
https://sabre.io/baikal/upgrade/
Zurück zu Baikal