Build an SQL Reference Object - Build an SQL Reference Object

Backend Development
1

Tell us what’s happening:

Hello Free Code Camp,

Workshop (Run Error) | SQL Reference Directory

Step: In your JSON file, add a delete key to the row object. Take a guess at the value, it should include the DELETE FROM and WHERE keywords. The whole value is in the hints.

Hint: The row.delete value should be “DELETE FROM table_name WHERE condition;”

I have tried to complete this Workshop 4 times, and every time when I reach this step I get an Error. I think there is an issue with this Workshop.

Please advise/help ASAP!

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/147.0.0.0 Safari/537.36

Challenge Information:

Build an SQL Reference Object - Build an SQL Reference Object

2

Welcome to the forum @ivan4786

Please post a screen grab of your terminal, including the instructions.

Happy coding

3

Hello Teller and thank you for your quick reply!

Here is the SS from the Workshop:

image
image1916×880 57.7 KB

4

image
image1911×878 78.3 KB

6

your screen shot doesn’t show any error. Can you show us what that looks like with the error?

Edit: if you expand the hint out fully, what does it say you should have typed?

Also have you tried to Reset?

7

Hey Teller, did you had a chance to read my comments, and do you need anything additional from me?

8

The code you wrote looks correct.

Try pressing the “Run” button a few times.

Did you reset the step as @hbar1st suggested?

Close the sql_reference.json tab and try the above steps again if that didn’t work.

9

Try pressing the “Run” button a few times. - I did.

Did you reset the step as @hbar1st suggested? - I did.

Close the sql_reference.json tab and try the above steps again if that didn’t work. - I did.

I have tried everything and I did this Workshop 4 times so far in a period of 24 hours and is still doesn’t work… I believe that there is an issue with this Workshop in GitHub.

Thoughts?

10

There is no known issue with this workshop.

What happened when you reset and tried again? What error did you see?

Also what does the hint say you should do when you expand it out fully?

11

When the test fails, it please click on the OUTPUT tab (two tabs to the left of your terminal tab in this image) and then, within that output space, click on the drop down list on the right side of the area. Choose CodeRoad option. Review any message shown in this tab after you click Run on the tutorial

12

This Reply helped me with finishing the last Certification Project for this Course - thank you!

Regarding the Workshop, there is a serious issues when I was doing the 65% of the steps. This Workshop should be either removed or replaced.

13

I haven’t had any issues myself. If you see an issue, let us know the details of that issue.
Thanks.

15

image
image1908×870 132 KB

16

image
image1913×873 200 KB

17

So I am still wondering what happens when you expand the hint out in full? (Keep clicking Get a Hint until it no longer gives you any hints.

Also still wondering what is in the CodeRoad logs (inside the Output tab).

Also would appreciate seeing a copy and paste of the contents of the file before and after your change. (Versus a screenshot of the file).

So run Reset and wait for it to finish restoring the file. Then using the mouse, copy the contents of the file here. Then add your code. Then copy again here.

18

One other suggestion for you. Close the Copilot window pane on the far right. Then right click on the instructions pane tab and choose the option to split to right. This should place the instructions pane in the far right area. Then in the left, click on the json file to bring it to the fore (on the left). This setup allows you to see the instructions and the code simultaneously.

19

Hbar,

I really appreciate all of your help so far!

I’ve spent 4 months doing these Coursers, and this is the first Workshop that doesn’t work properly. I really don’t have time to troubleshoot a platform like GitHub that FreeCodeCamp team is using it for their Workshops. All I can suggest from my experience is that this Workshop need to be either replaced or completely removed from GitHub.

20

Unfortunately your suggestion will not be taken seriously without some more information. Right now, we don’t know what it is you are experiencing. (It could be user error or not. Without more information, we cannot attempt to determine that one way or another).