Reply
Thread Tools
Posts: 729 | Thanked: 155 times | Joined on Dec 2009
#31
Would be nice to use this command together with timestamps...
 
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...!!!!!!
 
nicolai's Avatar
Posts: 1,637 | Thanked: 4,424 times | Joined on Apr 2009 @ Germany
#33
Originally Posted by ankursinghal View Post
Hi i ran the command in the terminal of my N900 but its giving me some error
"SQL error: no such table: Events"


help...!!!!!!
which command?

Nicolai
 
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"
 
nicolai's Avatar
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
 
Reply

Thread Tools

 
Forum Jump


All times are GMT. The time now is 06:13.