Page 1 of 1

mysql 5.7.9 make all read function error

Posted: 29 Nov 2015, 16:23
by 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

Re: mysql 5.7.9 make all read function error

Posted: 29 Nov 2015, 18:09
by 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

Re: mysql 5.7.9 make all read function error

Posted: 03 Dec 2015, 15:34
by fox