Learn SQL by Building a Student Database: Part 1 - Build a Student Database: Part 1

Tell us what’s happening:

Hello,
I am unable to start the program Learn SQL by Building a Student Database: Part 1. I have other issues as well. I will start with the first and attach screenshots.

  1. Everything from my “Learn Bash Scripting by Building Five Programs” is wiped out it seems. I just see a message “The editor could not be opened because the file was not found.”

  2. Also, at the end of that course, I cannot open a new workspace. I select the option and click through, but when I select Start New Tutorial, I receive a message saying “Oops! Select an Empty VSCode Workspace.”

  3. I also cannot find the Dev Containers: Rebuild and Reopen in Container course after installing the extension.

Thank you.

Your code so far

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36 Edg/138.0.0.0

Challenge Information:

Learn SQL by Building a Student Database: Part 1 - Build a Student Database: Part 1



can you explain what you mean by wiped out please?
There’s been ongoing issues with people moving forward to new courses but this is something i haven’t heard before so please explain what you meant there.

Hello, thank you for the reply.

In the first screenshot, at the top, you can see the tabs for the five programs. None of them show the content of those programs and they all say, “The editor could not be opened because the file was not found.”

I’m not 100% sure but when you created those programs, did you push them to any repo or they were just local to your docker environment?

(in general any files / directories you create have to be pushed to github because they’ll get erased if you rebuild the container for any reason)

I think they were just local to the docker environment, but I am not sure. How would I check if these were pushed to github?

You would be aware if you had done that I think as it requires creating a repo and multiple steps.

As far as I know, there is a warning in the readme file in the repo that says that files will get removed if you rerun the build. Maybe you did that?

I may have yeah. I am ultimately more concerned about being able to start a new course. I am unable to start any new ones. I may have reran the build while trying to start a new course.

if you’re on windows, you can try these steps which have worked for me multiple times

But please read through them first and let me know if you have any questions because if you do, better ask me before you try them (it will be hard to fix things, if you misunderstand something)

Thank you, I have not yet tried those steps, but I seemed to get to a point where I could start a new program. I am trying to do the “Dev Containers: Rebuild and Reopen in Container” course. When selecting the course, I am prompted to select a container configuration template. Do you know which one I should select?


no I’m sorry. This is not something I figured out.

Thank you, I’ll post a new topic for that since it is different from this one and see if that works. I may need to come back to your resolution if this does not work.

you do not need to post a new topic.
If someone knows the answer, they will answer here.

[quote=““Rebuild and Reopen in Container” does not show up in DevContainers, post:27, topic:756989”]
cp -r rdb-alpha rdb-alpha1
[/quote]

I am going to have to try this. I ran your first step and receive the below error.

actually the first step is to exit vs code.
You will need to do this from your command line in wsl

also please read the instructions and let me know if you don’t understand something

for eg. I say to cp the rdb-alpha directory. Hopefully you know this means that you need to be in the parent dir to do that.

( if you treat the steps like they are exact, you’ll run into many problems. Please try to understand what I’m saying to do before you do it. )

How do I first get to the parent directory?

how did you create your rdb-alpha directory when you started out?
The initial instructions were:

Open a terminal and clone the RDB Alpha repo if you don't already have it with git clone https://github.com/freeCodeCamp/rdb-alpha
Navigate to the rdb-alpha directory in the terminal with cd rdb-alpha, and open VS Code with code .

So hopefully you can open a terminal and just do an ls and see your rdb-alpha dir, in which case you are in the parent folder.

I followed the instructions on the course page when setting this up.

I created the instructions for people who are on windows but who are using WSL (Windows Subsystem for Linux).

If you’re not using WSL, you will need to find your rdb-alpha directory and make a copy of it in your file explorer if that makes thing easier for you. But you will need to open a terminal and navigate to the new copy in order to run the other commands.

If you’re interested in WSL, you can find out more about it here: Install WSL | Microsoft Learn

I posed a screenshot of WSL earlier. Was that not what you were expecting?