Learn Relational Databases by Building a Database of Video Game Characters
Issue: The step is ‘I wonder what that third one is. It says characters_character_id_seq. I think I have a clue. View the details of the characters table.’
I am using \d characters; for the command but it’s not working at all.
Tried ‘Enter psql --username=freecodecamp --dbname=mario_database into the terminal to log in if you aren’t already’, but nothing. The previous step was completed successfully.
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/139.0.0.0 Safari/537.36
Challenge Information:
Learn Relational Databases by Building a Database of Video Game Characters - Build a Database of Video Game Characters
No, it did not work. Ran into another problem posted elsewhere here.
This module is very cumbersome to set up with many steps to have something go wrong. To advance to the next tutorial, I am having to completely delete rdb-alpha or git clone it in a separate directory just to switch projects.
Dev Containers: rebuild does not seem to work at all. Only a completely fresh git clone for the rdb-alpha seems to work.
Step: Toadstool’s name is wrong as well, it’s actually Toad. Use UPDATE to SET his name to Toad. Use the condition favorite_color=‘Red’
Not working. Tried \q and log back in. used exact syntax for hint. tried renaming values to match table config at step before to trigger the exact change. nothing works.
This is the worst module so far by far. 165 steps. A pain to restart modules. always get stuck doing the correct steps around 30-40%. I get troubleshoot, yeah, but this isn’t learning.
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/139.0.0.0 Safari/537.36
Challenge Information:
Learn Relational Databases by Building a Database of Video Game Characters - Build a Database of Video Game Characters
I am going to try this one more time later. It’s extremely frustrating that correct answers aren’t getting registered. When using remote dev container in VS code, could there be an issue with how long one is connected to the remote connection?
If this module keeps failing with correct answers, and even when using \q and logging back in, I’m just NOT going to try the Data Visualization module anymore, and I don’t recommend anyone using it. What should be maybe 40 minutes of work turns into days just because CodeRoad keeps failing.
If anyone is running into the same situation, PLEASE HELP!
Please show a screen shot of the entire screen including the terminals and what you typed.
I just completed this model last week without any issue but I have a lot of prior experience so it may be that you are not being careful enough in your typing.
We are aware that the rdb module is hard to setup (especially on windows).
I hope fCC will come up with an easier set of instructions for users at some point.
If in the meantime you need help starting a new module, it may be faster for you to join the discord server for fcc and discuss it with me there directly. (There is a channel called #programming-help there you can post in and we can guide you if you are struggling with the steps I shared in another forum post)
I encountered this bug as well.
one of the triggers i noticed for this bug: when i enter a command without semicolon, and the terminal start of the line changes from “database_name=>” to “database_name->”, and i try to exit this state by pressing ^C.
then, all the display commands (for example \d, \l) stop working.
it seems to me like a bug in the psql terminal, though i can’t be sure who’s fault is it.
anyway, here’s a workaround:
enter the command: “exit”.
then open again the psql terminal with “psql --username=freecodecamp --dbname=mario_database” (note that the database you name must exist).
do you mean that the fact that all displaying commands suddenly stop working properly is not a bug? while most commands does seem to work? how come?
one may argue about whether it’s intuitive or not that ^C is not allowed in this terminal, but if the terminal start-of-the-line seems just as before, how can the common user assume that something is wrong?
when the start-of-the-line changes from = to something else it means that there is an unclosed command that you need to finish. If there is a symbol like ' or " it means there is a string to finish, if there is - it’s an unterminated command.
Commands can be multiline, they only end when there is a semicolon
based on your response, i guess that my bug-description wasn’t clear. i’m familiar with the start-of-the-line symbol of ’ for multi-line commands. the issue i described happens after i goes back to the normal mode (the one with “=>”). in this mode, the display should work well, but it simply doesn’t.
the terminal interprets what you type or what you enter.
CTRL-C is something called SIGINT which is an interrupt signal that is sent to the underlying code and seems to disable the terminal ‘echo’ or the display.
However you can still type, you just won’t be able to see anything.
That’s not a bug, because it is how the underlying code works in principal.
Using a terminal is not meant to be user-friendly unfortunately. That is why software developers usually create user interfaces (for users).
We’re in the ‘backend dev’ world though when we use a command line so, there’s a lot less intuitiveness to be expected here.
Yes, I’ve had the same issue around the same spot at least three times. Prob now is I can’t get CodeROad to go back to where I get enter in a new URL. It’s stuck on the Boiler plate. yes, I did rebuild container. Deleted old rdb directory redownload, but still coderoad always opens to boilerplate module.
It’s not difficult to follow the instructions to setup codeRoad. Do I have to reset configurations for the dev container for codeRoad or something? Edit a json file?
It’s cumbersome, I wouldn’t say hard. The problem for me now, additionally, is that codeRoad keeps opening to Boilerplate module now. I have deleted rdb alpha, redownloaded (cloned) it. Also did rebuild container in VS code. CodeRoad is now not opening to the menu to submit URL’s. Is there a json or configuration in VS code that I need to reset, refresh, clear, etc to get Code Road to open to the URL menu?
please accept my apologizes