[only question] How sort last visited website from places.sqlite ? [SOLVED]
Categories
(Toolkit :: Places, defect)
Tracking
()
People
(Reporter: swojskichlopak, Unassigned)
Details
User Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:72.0) Gecko/20100101 Firefox/72.0
Steps to reproduce:
I'm trying get last visited website from firefox from the linux command line.
I opened the pages in several tabs.
sqlite3 places.sqlite "select datetime(last_visit_date/1000000,'unixepoch','localtime') as last_visit_time,url from moz_places order by last_visit_time"
PS: Sorry, I write here because mozilla block users which want create account with age "0". I have the right not to specify my age and I will exercise this right.
Actual results:
When I open web in new tab, all is ok :
" 2020-01-11 20:30:49|http://www. "
but when I open website in the same website:
" |http://www. "
Expected results:
Firefox can show last visited website.
Is this possible from the command line?
|
||
Comment 1•6 years ago
|
||
Bugbug thinks this bug should belong to this component, but please revert this change in case of error.
|
||
Comment 2•6 years ago
|
||
This is not a bug report or an enhancement request. If you don't want to use the support forum, you can use a third-party site like /r/firefox, StackOverflow, or Ubuntu Forums.
Maybe I found a problem.
I cleared the whole browser history and tried again.
I have noticed the file (places.sqlite) being refreshed, but not always.
So,
- line with " |http://www. " probably this is bookmark, not website.
- website which I looked, has not yet been saved to the file.
I tried use it to block connections from website scripts.
But I see now also website which I not open.
Probably without building own browser plugin or install ready, this is not possible block.
[SOLVED]
Description
•