administrator [anarchydica]

administrator [anarchydica] 1 Jahr her friendica

!Friendica Support

Hi Leute,

ich habe beim Updaten der DB immer wieder ein Problem:

Version: 2022.03
Datenbankversion: 1452/1434 // Post-Update-Version 1452/1452

Hatte jemand schon so ein Szenario gesehen und eine Lösung?

php bin/console.php dbstructure update

ALTER TABLE `user-contact` ADD `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the contact url', ADD `hidden` boolean COMMENT 'This contact is hidden from the others', ADD `pending` boolean COMMENT '', ADD `rel` tinyint unsigned COMMENT 'The kind of the relation between the user and the contact', ADD `info` mediumtext COMMENT '', ADD `notify_new_posts` boolean COMMENT '', ADD `remote_self` boolean COMMENT '', ADD `fetch_further_information` tinyint unsigned COMMENT '', ADD `ffi_keyword_denylist` text COMMENT '', ADD `subhub` boolean COMMENT '', ADD `hub-verify` varchar(255) COMMENT '', ADD `protocol` char(4

ALTER TABLE `user-contact` ADD `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the contact url', ADD `hidden` boolean COMMENT 'This contact is hidden from the others', ADD `pending` boolean COMMENT '', ADD `rel` tinyint unsigned COMMENT 'The kind of the relation between the user and the contact', ADD `info` mediumtext COMMENT '', ADD `notify_new_posts` boolean COMMENT '', ADD `remote_self` boolean COMMENT '', ADD `fetch_further_information` tinyint unsigned COMMENT '', ADD `ffi_keyword_denylist` text COMMENT '', ADD `subhub` boolean COMMENT '', ADD `hub-verify` varchar(255) COMMENT '', ADD `protocol` char(4) COMMENT 'Protocol of the contact', ADD `rating` tinyint COMMENT 'Automatically detected feed poll frequency', ADD `priority` tinyint unsigned COMMENT 'Feed poll priority', ADD UNIQUE INDEX `uri-id_uid` (`uri-id`,`uid`), ADD FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE; 

Fehler 1050 beim Update der Datenbank aufgetreten
Table './anarchydica/user@002dcontact' already exists
Fehler beim Ändern der Datenbank aufgetretenALTER TABLE `user-contact` ADD `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the contact url', ADD `hidden` boolean COMMENT 'This contact is hidden from the others', ADD `pending` boolean COMMENT '', ADD `rel` tinyint unsigned COMMENT 'The kind of the relation between the user and the contact', ADD `info` mediumtext COMMENT '', ADD `notify_new_posts` boolean COMMENT '', ADD `remote_self` boolean COMMENT '', ADD `fetch_further_information` tinyint unsigned COMMENT '', ADD `ffi_keyword_denylist` text COMMENT '', ADD `subhub` boolean COMMENT '', ADD `hub-verify` varchar(255) COMMENT '', ADD `protocol` char(4) COMMENT 'Protocol of the contact', ADD `rating` tinyint COMMENT 'Automatically detected feed poll frequency', ADD `priority` tinyint unsigned COMMENT 'Feed poll priority', ADD UNIQUE INDEX `uri-id_uid` (`uri-id`,`uid`), ADD FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE; <br />

Friendica Support hat dies geteilt.

administrator [anarchydica] 1 Jahr her friendica

SHOW CREATE TABLE `user-contact`;



user-contact	CREATE TABLE `user-contact` (
  `cid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Contact id of the linked public contact',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'User id',
  `blocked` tinyint(1) DEFAULT NULL COMMENT 'Contact is completely blocked for this user',
  `ignored` tinyint(1) DEFAULT NULL COMMENT 'Posts from this contact are ignored',
  `collapsed` tinyint(1) DEFAULT NULL COMMENT 'Posts from this contact are collapsed',
  PRIMARY KEY (`uid`,`cid`),
  KEY `cid` (`cid`),
  CONSTRAINT `user-contact_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `contact` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user-contact_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='User specific public contact data'

Friendica Support hat dies geteilt.

administrator [anarchydica] 1 Jahr her friendica

Ich habe es gemerkt und den Post angepasst, das ist was du gemeint hast?

Friendica Support hat dies geteilt.

administrator [anarchydica] 1 Jahr her friendica

Ich kann leider kein SQL. Wenn ich die Ausgabe mit der von @Roland Häder vergleiche, dann fehlen mir Felder? Demnach brauch in ein Grundbefehl und eine Liste der zu generierenden Felder?

Friendica Support hat dies geteilt.

administrator [anarchydica] 1 Jahr her friendica

Entschuldige die lange Verzögerung. Nein, ich verstehe leider nicht was ich machen soll. Kannst du mir kurz zusammenfassen, was ich dir liefern soll?

Friendica Support hat dies geteilt.

administrator [anarchydica] 1 Jahr her friendica

Das macht natürlich Sinn:

ALTER TABLE `user-contact` ADD `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the contact url', ADD FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE;


MySQL meldet:
#1050 - Tabelle './anarchydica/user@002dcontact' bereits vorhanden

Friendica Support hat dies geteilt.

administrator [anarchydica] 1 Jahr her friendica

Ok, also Updaten war keine gute Idee. Danach hatte ich auf nichts mehr zugriff. Nur noch eine weiße Seite mit Service nicht verfügbar.

Friendica Support hat dies geteilt.