mysql 5.7.9 make all read function error

[ptsa]

can not make all read

Query UPDATE ttrss_user_entries SET unread = false, last_read = NOW() WHERE ref_id IN (SELECT id FROM (SELECT id FROM ttrss_entries, ttrss_user_entries WHERE ref_id = id AND owner_uid = 1 AND unread = true AND feed_id = 276 AND true) as tmp) failed: You can't specify target table 'ttrss_user_entries' for update in FROM clause

[fox]

you (or someone else who uses this piece of shit "database") try this workaround, report back if it helps, preferably with a diff

http://stackoverflow.com/questions/3252 ... -clause-sa

[fox]

op, try this: https://tt-rss.org/gitlab/fox/tt-rss/co ... 923deef7b3