Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialMUZ140610 Tinashe Marunda
7,028 PointsUnable to open database in the SQLLITE 3 error which says unknown comman or invalid arguments appears once i try to open
Please help
3 Answers
Bryan Manhollan
Courses Plus Student 9,841 PointsTo clarify the above answer (because I had trouble with it to). You have to type this in from the original console prior to opening sqlite3. Which will look something like this:
treehouse:~/workspace$ sqlite3 database.db
This will open sqlite3 in your console as well as add database.db to your databases.
Gyver Vick
5,347 PointsI initially had the same problem as you, but I tried using the following syntax, and it worked.
sqlite3 database.db
MUZ140610 Tinashe Marunda
7,028 PointsThank you so much guys. I was able to solve the problem
Tammy Burke
9,720 PointsTammy Burke
9,720 PointsThen just use .databases to see the database, don't use .open
Bryan Manhollan
Courses Plus Student 9,841 PointsBryan Manhollan
Courses Plus Student 9,841 PointsYou don't need to. If you type .databases you should see it listed.
Robert Rodriguez
3,796 PointsRobert Rodriguez
3,796 PointsThank you for posting this workaround to the issue. I was getting frustrated that I wouldn't be able to complete this important topic.