Active Topics
-
Is there a section to talk about Java ME? Apps, etc. (6)
to General by Kalatti - 4 days, 8 hrs ago - more...
|
2012-08-20
, 21:14
|
|
Posts: 136 |
Thanked: 19 times |
Joined on Nov 2011
@ Hungary
|
#42
|
Anybody about my installation problem:
"Now, I can install the repo, but can't install sqlite3, because some packages can't authenticated. I install with root. Any suggestions?
I ran terminal:
"devel-su"
then
"apt-get install sqlite3"
"Now, I can install the repo, but can't install sqlite3, because some packages can't authenticated. I install with root. Any suggestions?
I ran terminal:
"devel-su"
then
"apt-get install sqlite3"
|
|
2012-08-20
, 23:12
|
|
Posts: 8 |
Thanked: 8 times |
Joined on Jun 2010
@ United States
|
#43
|
Adam, is there any way I could see your terminal output? It could be a screenshot of the N9 itself (ScreenshotMee on the Ovi store is good for this) or a screenshot from your computer, if you're connecting that way. The contents of /etc/apt/sources.list.d/harmattan-dev.list might be helpful to see, too.
|
|
2012-08-21
, 06:04
|
|
Posts: 136 |
Thanked: 19 times |
Joined on Nov 2011
@ Hungary
|
#44
|
Originally Posted by Shinto
Thanks for your help, but finally, I could manage to install sqlite3. I downloaded sqlite3.deb from harmattan.dev.nokia.com, I tried to install, but during the install it was missing some dependencies. After that I tried to install that dependencies, and the Terminal suggest to use "apt-get -f install" command and that was the solution, it installed it.
Adam, is there any way I could see your terminal output? It could be a screenshot of the N9 itself (ScreenshotMee on the Ovi store is good for this) or a screenshot from your computer, if you're connecting that way. The contents of /etc/apt/sources.list.d/harmattan-dev.list might be helpful to see, too.
Then I tried the code to refresh my mails read/unread count and it's refreshed
but I don't know the result, because I have more than 6k mails and the "mark all read" function not working Any terminal command to mark all mail read?
Thanks.
Adam
|
|
2012-08-21
, 17:37
|
|
Posts: 8 |
Thanked: 8 times |
Joined on Jun 2010
@ United States
|
#45
|
Originally Posted by Hacker
As far as I can tell, and from my experience, the trigger will always work, just not right away. If your new-mail notification goes off and you immediately open the e-mail application, you probably won't see the blue circles. If you wait a while, perhaps another e-mail update cycle or two, they'll probably be there.Today, it has worked well, for instance, but over the weekend, there were several times when it didn't work. I don't know the pattern of when it works and when it doesn't.
I'm guessing this is due to the write-ahead-log DB checkpoints, and my attempts to force quicker updates (through PRAGMA wal_autocheckpoint) don't seem to stick. So without a true code fix, I'm afraid this may be as good as it gets.
Originally Posted by Arthuro_Adam
Yes, by running an UPDATE command in sqlite3. This is what such an operation would look like:
Any terminal command to mark all mail read?
Code:
~ $ /usr/bin/sqlite3 /home/user/.qmf/database/qmailstore.db SQLite version 3.7.7 2011-06-23 19:49:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> UPDATE mailmessages SET status=19137 WHERE status IN (18496,18497); sqlite> .quit ~ $
| The Following User Says Thank You to Shinto For This Useful Post: | ||
|
|
2012-08-21
, 20:59
|
|
Posts: 136 |
Thanked: 19 times |
Joined on Nov 2011
@ Hungary
|
#46
|
Originally Posted by Shinto
Thanks, I did it, but it didn't work, I have the same 4k unread mails
As far as I can tell, and from my experience, the trigger will always work, just not right away. If your new-mail notification goes off and you immediately open the e-mail application, you probably won't see the blue circles. If you wait a while, perhaps another e-mail update cycle or two, they'll probably be there.
I'm guessing this is due to the write-ahead-log DB checkpoints, and my attempts to force quicker updates (through PRAGMA wal_autocheckpoint) don't seem to stick. So without a true code fix, I'm afraid this may be as good as it gets.
Yes, by running an UPDATE command in sqlite3. This is what such an operation would look like:
Code:~ $ /usr/bin/sqlite3 /home/user/.qmf/database/qmailstore.db SQLite version 3.7.7 2011-06-23 19:49:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> UPDATE mailmessages SET status=19137 WHERE status IN (18496,18497); sqlite> .quit ~ $
|
|
2012-11-23
, 12:11
|
|
Posts: 10 |
Thanked: 3 times |
Joined on Nov 2012
|
#47
|
Are there any news for solving this bug?
thanks
yam603
thanks
yam603
|
|
2013-01-07
, 22:49
|
|
Posts: 1 |
Thanked: 1 time |
Joined on Jan 2013
@ Poland
|
#48
|
Ok this solution with trigger is quite great but the problem is that some unread mail got status 18496 or 2048 or even 51264 and for all them the blue circle don't work. I checked with my gmail account in which everything is ok the unread mail status there is set to 2049. So the best solution would be to change all of that codes to 2049 or 18497 but the question is why unread messages have different status codes. If we change them I suppose we loose some maybe quite important information. So if anyone could found a description of status codes in fenix mail it would be great help and possible lead to solving this problem.
| The Following User Says Thank You to czajniczeq For This Useful Post: | ||
|
|
2013-10-02
, 12:40
|
|
Posts: 53 |
Thanked: 9 times |
Joined on Apr 2012
|
#49
|
Some problem with me here - I have unread mail, and for two of three mail accounts I can mark all mails as read. Just for my account with 4.4xx unread mails it doesn't work.
|
|
2014-05-16
, 08:32
|
|
Posts: 19 |
Thanked: 6 times |
Joined on Dec 2012
|
#50
|
Hi,
I think I have a better way to resolve this issue. I'm working on it but will need help to make it as simple and fast as possible.
Here is the results I've found.
In database there's a table named : Mailstatusflags
This table is used to create mailmessages.status value
that's why you can have values like
The flag were looking for is "incoming" : bitstatus = 1
Statusbit = 8 : "READ"
Statusbit = 12 : "NEW"
18496 = 0100 1000 0100 0000 mean :
1st bit = 0 = not "incoming"
7th bit = 1 = "contentavailable"
12th bit = 1 = "new"
15th bit = 1 = "partialcontentavailable"
2048 = 1000 000 000
12th bit = 1 = "new"
51264 = 0001 0100 1001 000
= repliedall, read, unloadeddata, readreplyrequested
@czajniczeq, I don't think this message should be count as unread !?!
and so on ...
What I'm looking for now is the best way to create a trigger "on before insert" that set 1st bit to 1 (18496 +1, 2048+1) when message is new : 12th bit = 1
I think this will resolve for a long time and in a reliable way this little bug !
regards.
I think I have a better way to resolve this issue. I'm working on it but will need help to make it as simple and fast as possible.
Here is the results I've found.
In database there's a table named : Mailstatusflags
This table is used to create mailmessages.status value
that's why you can have values like
Originally Posted by czajniczeq
this number is composed with mailstatusflags.bitstatus18496 or 2048 or even 51264
The flag were looking for is "incoming" : bitstatus = 1
Statusbit = 8 : "READ"
Statusbit = 12 : "NEW"
18496 = 0100 1000 0100 0000 mean :
1st bit = 0 = not "incoming"
7th bit = 1 = "contentavailable"
12th bit = 1 = "new"
15th bit = 1 = "partialcontentavailable"
2048 = 1000 000 000
12th bit = 1 = "new"
51264 = 0001 0100 1001 000
= repliedall, read, unloadeddata, readreplyrequested
@czajniczeq, I don't think this message should be count as unread !?!
and so on ...
What I'm looking for now is the best way to create a trigger "on before insert" that set 1st bit to 1 (18496 +1, 2048+1) when message is new : 12th bit = 1
I think this will resolve for a long time and in a reliable way this little bug !
regards.
Hitting this thanks button will make you smile and feel good ----------------------------------------------------------------->