mysql 5.7.9 make all read function error

If you run tt-rss on an officially unsupported platform (shared hosting, Windows, etc.) post here
ptsa
Bear Rating Trainee
Bear Rating Trainee
Posts: 26
Joined: 08 Jul 2015, 05:21

mysql 5.7.9 make all read function error

Postby ptsa » 29 Nov 2015, 16:23

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
Attachments
121.jpg
121.jpg (29.13 KiB) Viewed 5441 times

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: mysql 5.7.9 make all read function error

Postby fox » 29 Nov 2015, 18:09

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

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: mysql 5.7.9 make all read function error

Postby fox » 03 Dec 2015, 15:34



Return to “Unsupported platforms”

Who is online

Users browsing this forum: No registered users and 1 guest