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

[mitchel312]

Tell us what’s happening:

I keep getting this error message “ERROR: duplicate key value violates unique constraint “sounds_filename_key”
DETAIL: Key (filename)=(yippee.wav) already exists.” When I put the correct command into the terminal.

Your code so far

Your browser information:

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

Challenge Information:

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

freeCodeCamp.org

[mitchel312]

Here is a screenshot of the terminal:

[Teller]

Hi @mitchel312

Please display the contents of the table using SELECT

Happy coding

[ILM]

if you already have a row with that name you can’t add an other, you may want to check what’s already inside your table

[mitchel312]

Thank you! Will do. I have another question. Here are the screenshots:

I am getting the same error message for this prompt as well. I checked both actions and characters tables to make sure that I had the correct IDs. I then put in the correct command and I got the same message. Thanks for your help!

[Teller]

Hi @mitchel312

Thecharacter_id for 7 is taken up by Yoshi.

Happy coding

[mitchel312]

I understand. However, when I put the command in the terminal, it would not work, if I put the command the following day it would then work. Does Github perform maintenance during the night or evenings? Do you think that would affect the terminal’s response to my commands? Thanks.

Blockquote

[Teller]

Hi @mitchel312

Without seeing the input and the requirements for the step, it it not possible to say.

However, do make sure to end PostgresSQL commands with a semi colon,
otherwise the previous command is still open - and will remain open until the command ends with a semi colon.

Happy coding