Open deathbybandaid opened 1 year ago
That’s weird. Did you try importing the database contents from sqlite or something?
You can try work around this issue by changing DROP TRIGGER
to DROP TRIGGER IF EXISTS
on the following lines:
I did not import anything, I exported my opml with the plan of re-importing
I'll try that modification
That fixed it for me, I did have to drop my database and recreate it, as it was yelling about duplicate tables
That sounds like something got broken during the initial db table creation. Does it happen again without IF EXISTS
if you drop and re-create the database? Did you see anything else in the logs?
well, now it's just bizarre, as removing IF EXISTS
allows for a working database backend (after dropping)
This is so weird. We have another user reporting this.
I've been using sqlite for most of the time that I've used selfoss, and was curious if switching to mysql would provide any performance benefit.
Created mysql user/pass, created a database, gave user@localhost permissions for the database.
mysql 8.0.31-0ubuntu0.22.04.1 php 8.1 selfoss 2.20-d45cba4