Forumsregeln
RUNALYZE started as one-man-project with only one user and has grown to an app with around 15.000 users of our official online version. Server requirements and complexity of the app and its configuration grow with the feature list. Please understand that our main focus is on implementing new features and serving a performant online version. Therefore, support for local installations is limited and we cannot guarantee any support.

Please always provide log files (and screenshots, activity files if it makes sense) and all other needed information: https://docs.runalyze.com/en/latest/support.html

We spend our leisure time to make RUNALYZE as good as possible and we still have tons of great ideas, but time is scarce and after a hard training we first need some fruits or a smoothie. You can support the development of RUNALYZE with every financial contribution — We highly appreciate every grant.
https://blog.runalyze.com/donate/
Friedi1970
Neuling
Beiträge: 14
Registriert: Mo 19. Dez 2016, 04:51

Update auf 4.1.2 unmöglich

Fr 25. Aug 2017, 16:24

Hallo zusammen,

ich versuche gerade verzweifelt auf v. 4.1.2 upzudaten und bin am Verzweifeln.

Wenn ich das Update aufrufe, erhalte ich folgende Meldung:
RUNALYZE Migrations


Migrating up to 20170430165002 from 20170311194530

++ migrating 20170320194525

-> CREATE TABLE IF NOT EXISTS `runalyze_notification` (
`id` INT UNSIGNED AUTO_INCREMENT NOT NULL,
`messageType` tinyint unsigned NOT NULL,
`createdAt` INT UNSIGNED NOT NULL,
`expirationAt` INT UNSIGNED DEFAULT NULL,
`data` TINYTEXT NOT NULL,
`wasRead` tinyint(1) unsigned NOT NULL DEFAULT 0,
`account_id` INT UNSIGNED NOT NULL,
INDEX IDX_F99B51889B6B5FBA (account_id),
PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB

-> ALTER TABLE runalyze_notification ADD CONSTRAINT FK_F99B51889B6B5FBA FOREIGN KEY (account_id) REFERENCES runalyze_account (id)
Migration 20170320194525 failed during Execution. Error An exception occurred while executing 'ALTER TABLE runalyze_notification ADD CONSTRAINT FK_F99B51889B6B5FBA FOREIGN KEY (account_id) REFERENCES runalyze_account (id)':

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint


[Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing 'ALTER TABLE runalyze_notification AD
D CONSTRAINT FK_F99B51889B6B5FBA FOREIGN KEY (account_id) REFERENCES runaly
ze_account (id)':
SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint



[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint



[PDOException]
SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint


doctrine:migrations:migrate [--write-sql] [--dry-run] [--query-time] [--allow-no-migration] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--db DB] [--em EM] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] []
Über Github habe ich dann herausgefunden, dass auf einmal die Inno-DB vorgeschrieben und nicht mehr optional ist :shock: Ich habe dann versucht, das über phpmyadmin und diesem Script zu lösen: https://github.com/Runalyze/Runalyze/bl ... ucture.sql

Leider verursacht das einen Fehler:
Fehler

Es scheint einen Fehler in Ihrer MySQL-Abfrage zu geben. Die MySQL-Fehlerausgabe, falls vorhanden, kann Ihnen auch bei der Fehleranalyse helfen.

ERROR: Unbekannte Interpunktion @ 1623
STR: //
SQL: -- phpMyAdmin SQL Dump
-- version 4.2.11
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 08. Sep 2015 um 16:59
-- Server Version: 5.6.21
-- PHP-Version: 5.6.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";# MySQL lieferte ein leeres Resultat zurück (d. h. null Zeilen).


--
-- Datenbank: `runalyze`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `runalyze_account`
--

CREATE TABLE IF NOT EXISTS `runalyze_account` (
`id` int(10) unsigned NOT NULL,
`username` varchar(60) NOT NULL,
`name` varchar(50) NOT NULL DEFAULT '',
`mail` varchar(100) NOT NULL,
`language` varchar(5) NOT NULL DEFAULT '',
`timezone` smallint(5) unsigned NOT NULL DEFAULT '0',
`password` varchar(64) NOT NULL DEFAULT '',
`salt` char(64) NOT NULL DEFAULT '',
`registerdate` int(10) unsigned DEFAULT NULL,
`lastaction` int(10) unsigned DEFAULT NULL,
`changepw_hash` char(32) DEFAULT NULL,
`changepw_timelimit` int(10) unsigned DEFAULT NULL,
`activation_hash` char(32) DEFAULT NULL,
`deletion_hash` char(32) DEFAULT NULL,
`allow_mails` tinyint(1) unsigned NOT NULL DEFAULT '1',
`allow_support` tinyint(1) unsigned NOT NULL DEFAULT '0',
`role` tinyint(3) unsigned NOT NULL DEFAULT '1',
`gender` tinyint(1) unsigned NOT NULL DEFAULT '0',
`birthyear` int(4) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;# MySQL lieferte ein leeres Resultat zurück (d. h. null Zeilen).


--
-- Trigger `runalyze_account`
--
DROP TRIGGER IF EXISTS `del_tr_train`;# MySQL lieferte ein leeres Resultat zurück (d. h. null Zeilen).

DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;
DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
FOR EACH ROW BEGIN
DELETE FROM runalyze_conf WHERE accountid = OLD.id;


SQL-Befehl:

DELIMITER // CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account` FOR EACH ROW BEGIN DELETE FROM runalyze_conf WHERE accountid = OLD.id;

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER //
CREATE TRIGGER `del_tr_train` AFTER DELETE ON `runalyze_account`
F' at line 1
Ich komme hier einfach nicht mehr weiter :( Weiß jemand Rat?

Zurück zu „Runalyze v4.1.x“

Advertisement

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast