Page 1 of 1

Read articles titles dont change state

Posted: 23 Aug 2015, 19:48
by 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.

Re: Read articles titles dont change state

Posted: 23 Aug 2015, 21:19
by 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?

Re: Read articles titles dont change state

Posted: 23 Aug 2015, 22:17
by 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.

Re: Read articles titles dont change state

Posted: 24 Aug 2015, 12:37
by 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.

Re: Read articles titles dont change state

Posted: 24 Aug 2015, 13:02
by 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

Re: Read articles titles dont change state

Posted: 24 Aug 2015, 14:16
by 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/

Re: Read articles titles dont change state

Posted: 24 Aug 2015, 14:36
by fox
ah windows users and their fascination with prerelease software

see also: windows 10

Re: Read articles titles dont change state

Posted: 24 Aug 2015, 15:06
by rwa66
My bad. I thought a "Milestone Release" was the latest and greatest. :oops:
And yes, Running Windows 10 for over a year now on several machines :wink: