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

PHP PHP & Databases with PDO Getting Started With PDO Introductions

Posted by Hasnain Ashfaq
Hasnain Ashfaq
Courses Plus Student 3,929 Points

Nothings seems to work for me not even sqlite3 database.db

I am trying to open the database in word space. .open does not exist. Sqlite3 database.db does some weird stuff. It goes to next line and nothing happens except "..>".

Chris Grazioli
Chris Grazioli
31,225 Points
Chris Grazioli
Chris Grazioli
31,225 Points

I am having the same issue, nothing is working

5 Answers

Micah Courey
Micah Courey
20,168 Points

If you're already in sqlite you need to first type .quit to leave sqlite and then from the terminal type: 

sqlite3 database.db
Hasnain Ashfaq
Hasnain Ashfaq
Courses Plus Student 3,929 Points

Thanks so much! Solved the problem.

Chris Grazioli
Chris Grazioli
31,225 Points
Chris Grazioli
Chris Grazioli
31,225 Points

When stuck in sqlite with this prompt "...>" nothing works. NOT even .quit, KILL, exit, ctrl-Q

Micah Courey
Micah Courey
20,168 Points
Micah Courey
Micah Courey
20,168 Points

Pablo, You need to enter the "sqlite3 database.db" from the terminal not from inside the sqlite shell. if you see "sqlite>" before what you type you are in the sqlite shell. You will need to exit sqlite by typing .quit and then from the terminal type "sqlite3 database.db".

Pablo Duran
Pablo Duran
15,052 Points
Pablo Duran
Pablo Duran
15,052 Points

Hi Micah,

Thank you very much, I missed the part to use .quit command, now is working.

Best regards.

Ted Sumner
PLUS
Ted Sumner
Courses Plus Student 17,967 Points
Ted Sumner
Ted Sumner
Courses Plus Student 17,967 Points

It sounds like you missed a critical step in the setup. Without taking the course, I cannot begin to think what it might be. I suggest first, clear your browser cache. There are sometimes issues with that. If that does not solve your problem, retake the setup part of the course making sure you follow every step and get the result shown in the video.

Pablo Duran
Pablo Duran
15,052 Points
Pablo Duran
Pablo Duran
15,052 Points

Hi Ted,

I have the same issue as the guy who sent this question. I clear the browser cache and followed the steps as the video, also I tried with the command "sqlite> sqlite3 database.db" as in another post recommended but all I received is "...>" .

You spoke about missed a critical step in the setup, but in the video the teacher don't explain something like a setup, in fact he said everything is ready to use:

from transcript: It's also SQLite instead of MySQL so it's very light weight. 1:28 We'll be able to use most of the same query commands, especially for 1:31 this particular lesson.

Can you please explain this setup.

Please let us know if there is something else to be able to continue with the course.

Regards.

Sam Donald
Sam Donald
36,305 Points
Sam Donald
Sam Donald
36,305 Points

Pablo Duran clearing the cashes worked for me.

Mark Berning
Mark Berning
11,326 Points
Mark Berning
Mark Berning
11,326 Points

for those who get stuck with the ...> prompt, it is waiting for sql commands so just type a ; and then hit return to jump out of that mode. Then you should be back with a sqlite> prompt. Type .databases and you should be connected to your treehouse db.