Learn-relational-databases-by-building-a-mario-database

[BigD1979666]

Hi all,

I have been slowly grinding away on 1. the learn-relational-databases-by-building-a-mario-database project and when I cam back this morning , the tutorial started over!

I still have my databases and progress saved as doing a SELECT * FROM characters shows all my work. Is there anyway to get past the first part of the tuto to where I left off without redoing everything I have already done ?

[jonathanudeh]

What part of the test is CodeRoad asking you to pass atm?

[BigD1979666]

Hi,

I stopped at "It looks good. Next, you are going to add a primary key. It’s a column that uniquely identifies each row in the table. "

When I check my db and what is inside, i have all the tables and columns up to this point but the tuto has started from the very beginning with “The first thing you need to do is start the terminal.”

So to test, I did thi part again but then it returned the error " "Try entering `ALTER TABLE characters ADD PRIMARY KEY(name); ’ as if there is a discrepancy with the terminal and the tutorial.

I’m at a loss as what to do . I really don’t want to start from scratch again.

[BigD1979666]

Not sure this helps but it’s an idea as to what I am facing .

Happens whether I use the credentials first given at the beginning of the tutorial or if I use the credentials given later once you actually set up some tables and columns .

[jonathanudeh]

First of, when you came back where in this image did you click

was it to start a new course or did you click go to your gitpod dashboard to continue
if the latter is the case then that’s good, cos it takes you to your dashboard where you select your project which takes you to your editor. If you clicked on start a new course instead then I guess you go back this page and click continue to go to your dashboard.

But then when you’re there you dont just continue as though you never took a break, what you do rather is copy and paste something like this in your terminal

psql --username=freecodecamp --dbname=postgres
to log into postgre and then you list the database using \l and then connect to the database you were working on with \c <database name> (ex: \c mario_database) which takes you into the database and then you can continue where you left off, hopefully.

[BigD1979666]

I tried the method you suggested

1. List item
2. go to gitpod dashboard to continue
3. login with base credentails
4. listed database using" \l"- it showed mine and the progress I made was still there
5. used “\c” to connect to my desired database"mario_database"
   however, the tutorial window still shows the very begginning of the tuto and when even when I try to redo this, it gives the error I mentioned before , which is the error if you didn’t make your first "key (name) "correctly -Try entering `ALTER TABLE characters ADD PRIMARY KEY(name);

It’s as if it’s out of sync somewhere .

[BigD1979666]

@jonathanudeh

psql --username=freecodecamp --dbname=postgres

That’s what I get on the tuto window

[BigD1979666]

Adn you can see my gitpod is up to date in vs code .

[BigD1979666]

@jonathanudeh

psql --username=freecodecamp --dbname=postgres

I figured it out. I reset in the code:start tuto window, exited out of my session with \q in the terminal, did the first exercise and then “ctrl+enter” until I was back where I left off in my exercises . Hope this doesn’t happen again. Thanks for your help in any case