CODEWITHSUNDEEP
androidsqlite
Mathias Conradt
Mathias Conradt

Reputation: 28665

sqlite3 on Android fails with: syntax error: unexpected "("

I pushed sqlite3 (from my Android SDK tools folder) to my rooted device (Galaxy S III, 4.0.3), since it wasn't on there.

But executing any query fails with an error, even just calling 'sqlite3' alone.

via adb shell:

~ # sqlite3
/system/xbin/sqlite3: line 1: syntax error: unexpected "("

~ # sqlite3 /data/system/accounts.db "delete from grants;"
/system/xbin/sqlite3: line 1: syntax error: unexpected "("

What's wrong?

Upvotes: 1

Views: 1811

Answers (2)

CL.
CL.

Reputation: 180060

When starting, sqlite3 executes the file ~/.sqliterc. Check whether it exists, and what it contains.

But in this case, it would output a message -- Loading resources from .../.sqliterc, so this is not what happens here.

Upvotes: 0

atfergus
atfergus

Reputation: 320

See if putting quotes around sqlite3 on the command line works: ~ # "sqlite3"

Upvotes: 1

Related Questions