Hi,<br><br>Now with QtMoko v9.<br><br><div class="gmail_quote">On Thu, Sep 10, 2009 at 12:35 AM, Radek Polak <span dir="ltr"><<a href="mailto:psonek2@seznam.cz">psonek2@seznam.cz</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I have attached script for creating contacts table. Can you please<br>
download it to you phone and try following:<br>
<br>
apt-get install sqlite3<br>
sqlite3 -init contacts.sql /opt/qtmoko/qtopia_db.sqlite<br></blockquote><div><br>I did that, and it worked. In sqlite3 (using '.tables') I can see that the contacts table is there <br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Let me know if that helps.<br></blockquote><div><br>Well, no - it didn't help. addressbook still complains in the same way as before.<br><br>Are you cetain that this (/opt/qtmoko/qtopia_db.sqlite) is the right database?<br>
There are a few on the system:<br>root@neo:~# find / -name '*sqlite' -print<br>/root/Applications/Qtopia/qtopia_db.sqlite<br>/opt/qtmoko/qtopia_db.sqlite<br>/home/root/Applications/Qtopia/qtopia_db.sqlite<br>/home/root/Applications/qtopiamail/qtopia_db.sqlite<br>
/media/card/qtopia_db.sqlite<br>/tmp/qtopia-0/opt/qtmoko/qtopia_db.sqlite<br><br><br> How can I find out which is the right one?<br>root@neo:~# ls -l /opt/qtmoko/qtopia_db.sqlite<br>-rw-r--r-- 1 1000 1000 175104 Sep 13 21:59 /opt/qtmoko/qtopia_db.sqlite<br>
<br>root@neo:~# ls -l /root/Applications/Qtopia/qtopia_db.sqlite /home/root/Applications/Qtopia/qtopia_db.sqlite /home/root/Applications/qtopiamail/qtopia_db.sqlite /media/card/qtopia_db.sqlite /tmp/qtopia-0/opt/qtmoko/qtopia_db.sqlite<br>
-rw-r--r-- 1 root root 151552 Sep 13 22:05 /home/root/Applications/Qtopia/qtopia_db.sqlite<br>-rw-r--r-- 1 root root 20480 Aug 12 17:42 /home/root/Applications/qtopiamail/qtopia_db.sqlite<br>-rwxr-xr-x 1 root root 278528 Oct 12 2009 /media/card/qtopia_db.sqlite<br>
-rw-r--r-- 1 root root 0 Sep 13 21:34 /root/Applications/Qtopia/qtopia_db.sqlite<br>-rw-r--r-- 1 root root 162816 Aug 12 17:42 /tmp/qtopia-0/opt/qtmoko/qtopia_db.sqlite<br><br></div></div>Perhaps the addressbook needs some env vars configured when started from a (ssh) shell?<br>
-- <br>Regards,<br>Torfinn Ingolfsen<br>