Failed Database Migration to 147

Tiny Tiny RSS
1

After installing the new version via packages on FreeBSD 13.1 with Mysql 8.0.31 and Php 8.1 I have this error:

"[21:59:40/43314] Starting migration to 147…
[21:59:40/43314] Failed on line: create fulltext index ttrss_entries_title_search_idx on ttrss_entries(title)
[21:59:40/43314] Migration failed: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name ‘ttrss_entries_title_search_idx’`

One of migrations failed. Either retry the process or perform updates manually."

Can you help me?

2

https://community.tt-rss.org/t/update-to-schema-147-mysql/5663

Also: you’re using an unsupported configuration (host install, MySQL, etc.). Consider switching to the supported approach.

1 Like
3

i think there’s enough information here to solve this issue, anyone else replying with “me too, plz halp” is going to be probated.

4

I can’t use the supported approach because I have not Linux as OS. I use FreeBSD that is not Linux.
Thank you for the link.