Read articles titles dont change state

[rwa66]

If i read articles or mark them as read they don't get changed to the read state.
They stay in the left pane and don't get greyed out.
System log says:

Code: Select all

E_USER_ERROR (256)   classes\db\mysqli.php:33   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 = 1 AND true) as tmp) failed: You can't specify target table 'ttrss_user_entries' for update in FROM clause

Fresh install of v15.7
PHP 5.6.0
MySQL 5.7
Self hosted IIS 7.5

I've Google a bit, only thing i could find on 'You can't specify target table for update in FROM clause' is that MySQL can't use an open table as temp table. Don't know if that's the case and how to solve it.

[fox]

well if this is suddenly not allowed now i guess someone will have to rewrite those queries

it works for me on 5.5

e: you sure you're running innodb?

[rwa66]

Yup, all tables are InnoDB, it is my default engine in MySQL.
I will try to do another clean install for the third time, if that won't work i will try MySQL5.5 to be sure it is 5.7.

Edit:
Just did a clean install again, same behavior. Will try older MySQL tomorrow.

[rwa66]

I just installed MySQL 5.6.26 and everything works as usual.
So I guess MySQL 5.7 is the culprit and I guess queries should be rewritten.
For now I'll stay on 5.6. If there are testers needed for 5.7, just notify me.

[fox]

i'll update the wiki re: 5.7 incompatibility

if someone wants to bother with the queries i'll take a look at a pull request i guess

[darknite323]

Might want to hold off on any code changes/additions.
MySQL download page is showing 5.6.26 as the latest General release.
5.7.x is still in Development.
http://dev.mysql.com/downloads/mysql/

[fox]

ah windows users and their fascination with prerelease software

see also: windows 10

[rwa66]

My bad. I thought a "Milestone Release" was the latest and greatest.
And yes, Running Windows 10 for over a year now on several machines