Baikal - Update (Linux): Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| Zeile 52: | Zeile 52: | ||
</pre> | </pre> | ||
At lines 225, 260 change the lines (adding length for unique part): | |||
<pre> | <pre> | ||
$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));'); | |||
</pre> | </pre> | ||
| Zeile 67: | Zeile 67: | ||
at line 299; | at line 299; | ||
At line 373 change the lines (adding length for unique part): | At line 373 change the lines (adding default value for 'id' and length for text unique part): | ||
<pre> | <pre> | ||
Version vom 2. August 2020, 08:58 Uhr
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
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