Active Topics
-
[HOWTO] Comprehensive Firmware Flashing Guide for N9 (1,580)
to Nokia N9 / N950 by aspergerguy - 12 hrs, 37 mins ago -
Nokia N9-00 Prototype Build S1.12 (RM-680 codename "Dali") (250)
to Nokia N9 / N950 by en0s - 3 days, 9 hrs ago -
[Announce] Maebble - Pebble support for Maemo (118)
to Applications by glo-worm - 3 days, 21 hrs ago -
Possible to flash Leste to eMMC? (6)
to Maemo 7 / Leste by Eri - 4 days, 11 hrs ago - more...
DaSilva |
2010-12-06
, 14:48
|
|
Posts: 729 |
Thanked: 155 times |
Joined on Dec 2009
|
#31
|
Would be nice to use this command together with timestamps...
|
|
2010-12-28
, 13:50
|
|
Posts: 2 |
Thanked: 0 times |
Joined on Dec 2010
|
#32
|
Hi i ran the command in the terminal of my N900 but its giving me some error
"SQL error: no such table: Events"
help...!!!!!!
"SQL error: no such table: Events"
help...!!!!!!
 |
|
2010-12-28
, 14:15
|
|
Posts: 1,637 |
Thanked: 4,424 times |
Joined on Apr 2009
@ Germany
|
#33
|
Originally Posted by ankursinghal
which command?
Hi i ran the command in the terminal of my N900 but its giving me some error
"SQL error: no such table: Events"
help...!!!!!!
Nicolai
__________________
my contributions:
Desktop Clock Widget|Calendar Home Widget|Lens Cover Reminder|ConnectNow|Scout|App Search Widget|ProfilesX|
Desktop-Switcher|SMS-Messageblocker
-Donate-
my contributions:
Desktop Clock Widget|Calendar Home Widget|Lens Cover Reminder|ConnectNow|Scout|App Search Widget|ProfilesX|
Desktop-Switcher|SMS-Messageblocker
-Donate-
|
|
2010-12-29
, 09:22
|
|
Posts: 2 |
Thanked: 0 times |
Joined on Dec 2010
|
#34
|
i ran this command
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html
have replaced xxxxxxxxxxxx with a phone number
and got the error
"SQL error: no such table: Events"
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html
have replaced xxxxxxxxxxxx with a phone number
and got the error
"SQL error: no such table: Events"
|
|
2010-12-30
, 11:03
|
|
Posts: 1,637 |
Thanked: 4,424 times |
Joined on Apr 2009
@ Germany
|
#35
|
there are two events db-files depending on your Firmware version.
try el-v1.db instead of el.db:
sqlite3 -html /home/user/.rtcom-eventlogger/el-v1.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html
try el-v1.db instead of el.db:
sqlite3 -html /home/user/.rtcom-eventlogger/el-v1.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html
__________________
my contributions:
Desktop Clock Widget|Calendar Home Widget|Lens Cover Reminder|ConnectNow|Scout|App Search Widget|ProfilesX|
Desktop-Switcher|SMS-Messageblocker
-Donate-
my contributions:
Desktop Clock Widget|Calendar Home Widget|Lens Cover Reminder|ConnectNow|Scout|App Search Widget|ProfilesX|
Desktop-Switcher|SMS-Messageblocker
-Donate-
