Learn Relational Databases by Building a Mario Database - Build a Mario Database

I keep having issues with the lesson. I’ve restarted the lesson three times, and around step 30 when I have to start inserting information into the tables the lesson crashes on me. It doesn’t show error messages, it doesn’t say I’ve done the step wrong, it just stops. My screen looks like this:


And it just stops processing any information. Can anyone help me fix this? I’d really like to earn this certificate.

Your browser information:

User Agent is: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36

Challenge Information:

Learn Relational Databases by Building a Mario Database - Build a Mario Database

Hello, @camyrenee , welcome to the fCC forum!

Sometimes I got this error too. Note that on the first time you wrote your Mario command you didn’t close your single quote, so every single line and character after it’s been treated as part of the string, including the other commands and the semicolon too.

To psql you are typing just a sequence of characters, therefore it’s waiting for the command to stop at an ; to execute it and this will never happen until you close your quotes.

You can correct this error in 3 ways:

  1. End the string by placing an ' followed by a ; throwing an error then type the command properly
  2. Enter Ctrl+C to end the current process and return to the prompt, then type the proper command
  3. Just close the project and open it again, then type the proper command

Hopes this helps! Happy coding!