[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 113: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 113: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 113: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 113: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 113: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 113: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5312: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3925)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5312: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3925)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5312: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3925)
Tiny Tiny RSS • Undo mark all read
Page 1 of 2

Undo mark all read

Posted: 02 Nov 2013, 22:56
by cbrannon
I've marked a bunch of articles as read when I shouldn't have. I'm hoping there is a timestamp in the database I can search for that corresponds to that action and flip a 'read/unread' bit on those. I'm poking around in the DB now but if someone can point me to the right table(s)/column(s) that would be helpful.

Thanks,
Chris

Re: Undo mark all read

Posted: 02 Nov 2013, 23:58
by fox
ttrss_user_entries.last_read

Re: Undo mark all read

Posted: 03 Nov 2013, 00:27
by cbrannon
In case this is useful for others, I fixed it with:

UPDATE `cbrannon_ttrss`.`ttrss_user_entries` SET `ttrss_user_entries`.`unread` = '1' WHERE `ttrss_user_entries`.`last_read` = '2013-11-02 18:31:17'

Re: Undo mark all read

Posted: 03 Nov 2013, 00:39
by sleeper_service
*thumbs up*

Re: Undo mark all read

Posted: 03 Nov 2013, 07:37
by bastage
Awesome tip .. thankfully I've never screwed up too badly but for the few times I've had to "fix" a personal user error like this I've done it manually so I'm definitely bookmarking this.

Re: Undo mark all read

Posted: 11 Nov 2014, 17:43
by guly
+1 for a plugin that adds "undo mark all as read" function :)

Re: Undo mark all read

Posted: 20 Nov 2014, 23:56
by Bob
Oops. Thanks for the query, i would never have found that out in my panicked state ;)

Re: Undo mark all read

Posted: 26 Jan 2015, 15:55
by norm
Thanks! Solved my "Mark as read" user failure :)

Re: Undo mark all read

Posted: 10 Feb 2015, 00:35
by k0OAhV

Re: Undo mark all read

Posted: 31 Jan 2016, 20:51
by NGPriest
I kinda did

DELETE FROM ttrss_user_entires
WHERE last_read=2016-01-31 hh:mm:ss

And kinda deleted all the rows...
What can i do now? :S

Re: Undo mark all read

Posted: 01 Feb 2016, 03:21
by sleeper_service

Re: Undo mark all read

Posted: 11 Feb 2016, 13:08
by aratistern

Re: Undo mark all read

Posted: 22 Feb 2016, 06:23
by rcaputo

Re: Undo mark all read

Posted: 22 Feb 2016, 15:40
by pcause
I have actually built and am testing a plugin to extended mark read and also add a mark unread. The plugin allows you to:

- select your timeframe : N {hours/days/weeks/months}
- qualify by search keywords, using the same syntax as the tt-rss search
- mark the items that match the above read or unread.

Use the code from the base "mark read" command for a start and also the function that creates the search string. The thing that isn't working yet is the mark read/under on the top level of labels if you have a search criteria specified. Also, I've only tested postgresql, as that is what I use. I have the mysql code there but it is untested. I expect to have this ready for others to try late this week or on the weekend.

Re: Undo mark all read

Posted: 19 Dec 2016, 19:30
by adhawkins