Tiny Core Linux

Tiny Core Extensions => TCE Q&A Forum => Topic started by: JohnJS on December 17, 2010, 01:43:30 PM

Title: Unable to start sqlite3 (SOLVED)
Post by: JohnJS on December 17, 2010, 01:43:30 PM

Using tc 3.3.
Have been unable to start sqlite3. Tried from aterm and 'run program'
Also tried moving sqlite3 to 'on demand' without any success.
Had no problem using sqlite3 with other linux systems.
Any suggestions?
Thanks.

Title: Re: Unable to start sqlite3
Post by: gerald_clark on December 17, 2010, 01:51:18 PM

The package is sqlite3-bin.
Sqlite3 is just libraries.

Title: Re: Unable to start sqlite3
Post by: JohnJS on December 17, 2010, 01:58:23 PM

Hi Gerald_clark,
Downloaded sqlite3-bin
This is what I get:
tc@box:~$ sqlite3 test
sqlite3: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory.

Title: Re: Unable to start sqlite3
Post by: Arslan S. on December 17, 2010, 02:04:17 PM

load ncurses extension, a simple missing dependency issue

Title: Re: Unable to start sqlite3 (SOLVED)
Post by: JohnJS on December 17, 2010, 02:23:11 PM

Thanks Arslan S
Starts okay now.
Edit:
Does not create file name test (sqlite3 test) which previous versions did.
Running just sqlite3 am able to create a table.

After creating table and importing a csv file it will only show all, for example:
select * from Info; shows everything but:
select * from Info where Payee like "Me"; does nothing.
Edit:
csv was incorrectly imported, my error. All is well now.
Thanks for assistance.

Title: Re: Unable to start sqlite3 (SOLVED)
Post by: ^thehatsrule^ on December 18, 2010, 12:42:13 AM

Added ncurses to dep