Relational Database Course stuck on Learn Relational Databases by Building a Mario Database module

I’ve managed to setup the Relational Database Course locally, according to the official instructions [1] and even completed the first module ‘Learn Bash by Building a Boilerplate’. However, on the second section ‘Learn Relational Databases by Building a Mario Database’ the program gets stuck on question #14 as shown in Figure 1. I’ve tried closing and reopening the terminal, using the Reset button, and even resetting the whole course with the command Remote-Containers: Rebuild Containeraccording to the instructions in [1], but the problem persisted. Additionally, hitting the button Run only results in the message ‘You should display the details of “second_table”’ being shown. Thanks in advance and sorry if I’m missing something obvious.

[1] Relational Database Course – How to Learn SQL in VSCode Using Docker and freeCodeCamp

Figure 1. VS Code stuck on Section 2, question 14 of the Relational Database Course.

Hey @diegocpal, any luck in getting passed this? I don’t think you’re missing anything obvious. I’m not quite sure what the problem is…

I just gave it a test and was able to get passed this step and other similar ones - after doing them as intended, and after resetting like you did. The SQL tutorials can be a little finicky - they generate logs that are read for the tests. Sometimes after resetting, the logs don’t get generated as intended and you get stuck without being able to pass a step. Although, I believe that should be mostly resolved and they are quite stable now. I don’t think that’s what is happening here, since I don’t see any output in your screenshot after you enter the command. You should see info about that table. Some of those commands in the middle should have shown you that.

I can tell you that the commands at the bottom, where the prompt has second_database-> instead of second_database=>, shouldn’t work. When the prompt doesn’t have the =>, it means that a command you entered on a previous line didn’t get completed. More specifically, in SQL, you can use multiple lines to enter a command. So if you press enter without a complete command (mainly, a missing semi-colon or missing quote), it will go to the next line, change the prompt, and you can continue with that command until you finish it correctly. Pretty sure that’s what is happening with the bottom few.

You said you tried using Remote-Containers: Rebuild Container to start over. You did that and got the same result both times? I would try that again and make sure to start the tutorial from the beginning again, by entering the URL.

This is a strange one, I’m hoping that you were able to resolve this already - let me know if the problem continues.

Thanks for the response. Unfortunately, I haven’t been able to resolve it. I,ve created a new folder to store the ‘rdb-alpha’ folder and started the lesson from a fresh start. Additionally, I tried to be much more careful with semicolons and the like, as you suggested. However, the lesson got stuck exactly on the same question as shown in Figure 1 and then I used the ‘reset’ button, to no effect. Also, I would like to add that in the meantime I managed to complete the modules: ‘Learn Bash Scripting by Building Five Programs’ and ‘Learn Nano by Building a Castle’ setting up the environment in the same manner. So, for some reason, the problem appears to be specific to this module and question. Thanks in advance.

Figure 1. State of the environment after pressing the reset button and trying again.

I’m stumped on this one @diegocpal. Seems like it should work - the CREATE TABLE worked, the \d worked, then the \d second_table doesn’t do anything :confused: Only thing I can think of is to see what’s different between your setup and a working setup. The things within the container/vm should be the same, that’s the point of it. But you could check the psql version, postgresql version, ubuntu version? And other things outside of it like the vscode version, remote-containers extension version - is your rdb-alpha repo up to date? I see you’re using linux mint? maybe that is causing problems. Doesn’t seem like it should, but I can’t be sure.

Yea - sorry I don’t have an answer for you at the moment. If you have another machine or OS maybe try on there?