Upgrade from a very old version and duplicate entry

1

Hi!

I am upgrading a very old version of tinyrss to the latest one and I’ve the following

[15:34:13/17094] Performing updates to version 138
[15:34:13/17094] * Updating to version 137…
[15:34:13/17094] > begin
[15:34:13/17094] > alter table ttrss_feeds add constraint ttrss_feeds_feed_url_owner_uid_key unique (feed_url(255), owner_uid)
[15:34:13/17094] Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘2’ for key ‘ttrss_feeds_feed_url_owner_uid_key’
[15:34:13/17094] One of the updates failed. Either retry the process or perform updates manually.

Before started update from 127 it seems

[15:33:56/17090] Performing updates to version 138
[15:33:56/17090] * Updating to version 127…
[15:33:56/17090] > BEGIN
[15:33:56/17090] > UPDATE ttrss_version SET schema_version = 127
[15:33:56/17090] > COMMIT
[15:33:56/17090] * Completed.
[15:33:56/17090] * Updating to version 128…

Any way to fix the db manually?
Thanks!

2

There are some challenges with a few schema updates when using MySQL.

See the FAQs Schema Upgrade Fails on MySQL 5.7.

Also see:

https://community.tt-rss.org/t/potential-problems-when-upgrading-to-schema-137/2122

There some discussion about schema upgrade failures in the old forum but it’s not working at the moment (I’ve mentioned this to fox).

3

you will have to find the duplicate feed and remove it (or change the URL somehow, i.e. add a question mark to the end) then schema upgrade should apply.

the forum will remain half broken i guess because of php changes but the posts should be readable now.

e: thanks to monkey patches provided by https://www.stephan-frank.de/board/index.php?topic=2.0 oldforum lives again, sorta.

4

Thanks! let me try finding that duplicate key :slight_smile:

5

Upgrade complete thanks!