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 trial
Darren Joy
19,573 Points.open command error
Following along in workspaces.. get this error
sqlite> .open database.db Error: unknown command or invalid arguments: "open". Enter ".help" for help
This seems to suggests that for some reason it is not recognizing the . (dot) before the open?
Anyone see this error themselves and/or know of a workaround?
4 Answers
Emiliano Ceccon
931 PointsHi!
You can try running the command ".help" and see if the command ".open" appears in the list, I had read that it seems that it has been removed or deprecated, so you can try open the database file without the .open keyword:
treehouse:~/workspace$ sqlite3 database.db
I hope I've helpful to you!
Daniel Robert Prieto
1,974 PointsIt doesn't work for me... 1 minute in and I can't continue :-(
Emiliano Ceccon
931 PointsHi Daniel, what do you mean with "1 minute in and I can't continue"?
Unsubscribed User
48,988 Points.open database.db is not working.... EVEN WITH sqlite3 database.db at the start. opening .help doesn't show any command .open !?
What to do ?
Unsubscribed User
48,988 Pointsoh.... ok no .open needed just tables and go.... :-)
David Pena Abad
16,288 PointsDavid Pena Abad
16,288 PointsThanks Emiliano,
I did have the same problem and with your instructions I could open the file.
See you soon,
David
Emiliano Ceccon
931 PointsEmiliano Ceccon
931 PointsThanks David, I'm glad that my answer has been helpful to you!
Atrian Wagner
24,811 PointsAtrian Wagner
24,811 PointsThank you! This is the solution. It's unfortunate that they couldn't update the video or the teacher's notes. The worst part is that with all the different threads of people asking this same question, some of the answers listed in response to the other ones are just wrong. Thank you for providing the correct answer.