Tell us what’s happening:
I can’t get past the step for “The rebase added the “row” commits…”
I added the requested line as follows:
“primary_key”: “ALTER TABLE table_name ADD PRIMARY KEY(column_name);”
It does not allow me to move forward. I even used the hint options and copy the whole file and pasted it into the .json and it still will not let me continue.
I will have to post the whole file in a separate post as the maximum query limit is getting reached.
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/148.0.0.0 Safari/537.36
Challenge Information:
Build an SQL Reference Object - Build an SQL Reference Object
GitHub Link: https://github.com/freeCodeCamp/freeCodeCamp/blob/main/curriculum/challenges/english/blocks/workshop-sql-reference-object/5fa323cdaf6a73463d590659.md
Here is the whole file. Not sure what I’m doing wrong when I copied directly from the hints and pasted.
{
“database”: {
"create": "CREATE DATABASE database_name;",
"drop": "DROP DATABASE database_name;"
},
“table”: {
"create": "CREATE TABLE table_name();",
"drop": "DROP TABLE table_name;"
},
“row”: {
"insert": "INSERT INTO table_name(columns) VALUES(values);",
"update": "UPDATE table_name SET column_name = new_value WHERE condition;"
},
“column”: {
"add": "ALTER TABLE table_name ADD COLUMN column_name;",
"drop": "ALTER TABLE table_name DROP COLUMN column_name;",
"rename": "ALTER TABLE table_name RENAME COLUMN column_name TO new_name;",
"primary_key": "ALTER TABLE table_name ADD PRIMARY KEY(column_name);"
}
}
Hi @dfairc39
Press the Reset button and try again.
If that doesn’t work please post a screen grab of the terminal.
Happy coding
click on the OUTPUT tab in the terminal area
then click on the drop down menu and choose CodeRoad(Tests) option
what errors are logged there?
Yeah, I tried resetting to no avail. Here is the screen grab:
I selected OUTPUT but the only drop down I see is “Tasks” to the right side. When I expand it, I do not see an option for CodeRoad(Tests). Am I missing something?
Try scrolling through the list?
is this a local build? I tried on codespaces and I can see both CodeRoad(Logs) and CodeRoad(Tests)
Edit: nevermind. I see from your screenshot that you have over 2000 changes logged in the workspace. I think something broke your workspace but I cannot tell you how to fix it other than to start from scratch
2nd edit: for my info, can you run git status in your terminal?
Also can you try closing the terminal and opening a new one to see if the OUTPUT tab still doesn’t have the coderoad options in the tasks list?
Tried restarting the terminal but, still no CodeSpace(Test) option. Here is what was displayed from git status.
can you go back to the project path and run git status there? I think that’s where all the changes were made
thanks. If you are able to, instead of a screenshot, please copy and paste the text itself (so that I can update a github issue with the list of files there).
I’m not going to be able to help you fix this, but your codespace might be able to help the maintainers identify the issue (but not sure to be honest if they will or not)
Here it is:
camper: /project$ git status
On branch reset-orphan-branch
You are currently cherry-picking commit b78f2c0c.
(fix conflicts and run "git cherry-pick --continue")
(use "git cherry-pick --skip" to skip this patch)
(use "git cherry-pick --abort" to cancel the cherry-pick operation)
No commits yet
Unmerged paths:
(use "git add/rm ..." as appropriate to mark resolution)
deleted by us: .freeCodeCamp/.mocharc.json
deleted by us: .freeCodeCamp/test/sample_files/sql_reference.json
Untracked files:
(use "git add ..." to include in what will be committed)
.freeCodeCamp/node_modules/
.freeCodeCamp/test/.cwd
.freeCodeCamp/test/.next_command
sql_reference/
