!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
... mehr anzeigen!Friendica SupportHi 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) 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 />
https://github.com/friendica/friendica/issues/12488
[2023.03] PHP Warnings · Issue #12488 · friendica/friendica
GitHub