Read articles titles dont change state

If you run tt-rss on an officially unsupported platform (shared hosting, Windows, etc.) post here
rwa66
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 09 Feb 2014, 16:11

Read articles titles dont change state

Postby rwa66 » 23 Aug 2015, 19:48

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.

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

Re: Read articles titles dont change state

Postby fox » 23 Aug 2015, 21:19

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
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 09 Feb 2014, 16:11

Re: Read articles titles dont change state

Postby rwa66 » 23 Aug 2015, 22:17

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
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 09 Feb 2014, 16:11

Re: Read articles titles dont change state

Postby rwa66 » 24 Aug 2015, 12:37

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.

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

Re: Read articles titles dont change state

Postby fox » 24 Aug 2015, 13:02

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
Bear Rating Trainee
Bear Rating Trainee
Posts: 40
Joined: 30 Oct 2013, 15:46

Re: Read articles titles dont change state

Postby darknite323 » 24 Aug 2015, 14:16

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/

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

Re: Read articles titles dont change state

Postby fox » 24 Aug 2015, 14:36

ah windows users and their fascination with prerelease software

see also: windows 10

rwa66
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 09 Feb 2014, 16:11

Re: Read articles titles dont change state

Postby rwa66 » 24 Aug 2015, 15:06

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:


Return to “Unsupported platforms”

Who is online

Users browsing this forum: No registered users and 4 guests