freecodecamp / rdb-alpha Goto Github PK

repo: https://www.github.com/freecodecamp/learn-world-cup-database

In queries.sh, one of the challenges is to write a SQL statement to return a list of unique winning teams in the dataset. The expected_output.txt file has an incorrect list.

To Reproduce
Steps to reproduce the behavior:

1. seed the database with the instructions in the lesson
2. write a SQL statement to return the list of unique winning teams

Expected behavior
The result set should only have 11 rows of unique winning teams.

cc @moT01

can anyone tell me from where I can download tutorial.json file for every course.
the links given not working

Describe the bug
The container doesn't build anymore because it tries to install Node 14 with a deprecated script. The bash scripts from NodeSource are deprecated. Also Node 14 is also deprecated, I guess that combination doesn't work anymore with the latest packages of Ubuntu 20.04.

To Reproduce
Steps to reproduce the behavior:
Try to re-build the container following the instructions from the repository.

Expected behavior
It builds :)

Desktop (please complete the following information):

• OS: Windows 11 with Docker for Windows

Additional context
Replacing the installation of Node with new approach and using Node 18 seems to work.
No idea if the course projects would work with Node 18.

ENV NODE_MAJOR=18
RUN sudo apt-get update && \
  sudo apt-get install -y ca-certificates curl gnupg && \
  sudo mkdir -p /etc/apt/keyrings && \
  curl -fsSL https://deb.nodesource.com/gpgkey/nodesource-repo.gpg.key | sudo gpg --dearmor -o /etc/apt/keyrings/nodesource.gpg && \
  echo "deb [signed-by=/etc/apt/keyrings/nodesource.gpg] https://deb.nodesource.com/node_$NODE_MAJOR.x nodistro main" | sudo tee /etc/apt/sources.list.d/nodesource.list && \
  sudo apt-get update && \
  sudo apt-get install nodejs -y

When I am trying to rebuild rdb container I am running in an issue of Node being able to install correctly. Appears to be related to this ---> nodesource/distributions#1379

Dockerfile might need to be tweaked to address that.

Describe the bug
This bug happens within "Learn Bash by building a boilerplate" Code Road tutorial

To Reproduce
Steps to reproduce the behavior:

1. I ran the tutorial as directed until I was prompted to long list the programs in a folder
2. ~/project/freeCodeCamp/node_modules is my filepath

Expected behavior
I expected to move on within the tutorial

Screenshots
Attached

Desktop (please complete the following information):

• OS: Windows
• Browser: Firefox
• Version: 10

Smartphone (please complete the following information):
N/A

Additional context

Describe the bug
Following tutorial instructions: Dev Containers Rebuild and Reopen in Container will fail due to error:
Failed to fetch http://archive.ubuntu.com/ubuntu/pool/main/d/dash/dash_ 0.5.10.2-6_amd64.deb 403 connecting to archive.ubuntu.com:80: connecting to 91 .189.91.82:80: dial tcp 91.189.91.82:80: connectex: Impossibile stabilire la con nessione. Risposta non corretta della parte connessa dopo l'intervallo di tempo oppure mancata risposta dall'host collegato. [IP: 91.189.91.82 80] 85.86 E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

To Reproduce
Steps to reproduce the behavior:

1. Clone repo
2. In VS Code, open the command palette with Ctrl / Cmd + Shift + P. Then, enter and run Dev Containers: Rebuild and Reopen in Container
3. Wait for process to interrupt
4. Read logs and see the error

Expected behavior
The image should build and the dev environment should open successfully

Desktop (please complete the following information):

• Windows 11 Pro
• Version 22H2
• Docker 4.26.1 (131620)

If I select 'Start New Tutorial' it brings up an error stating 'Git User Not Configured' even though my ~/.gitconfig already contains entries for user.name and user.email

OS: Sonoma 14.1.1

My Running Log was:

167.2 E: Failed to fetch http://archive.ubuntu.com/ubuntu/pool/main/c/coreutils/coreutils_8.30-3ubuntu2_amd64.deb 403 connecting to archive.ubuntu.com:80: connecting to 91.189.91.82:80: dial tcp 91.189.91.82:80: conn
ectex: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. [IP: 91.189.91.82 80]
167.2 E: Failed to fetch http://archive.ubuntu.com/ubuntu/pool/main/d/debianutils/debianutils_4.9.1_amd64.deb 403 connecting to archive.ubuntu.com:80: connecting to 91.189.91.82:80: dial tcp 91.189.91.82:80: connecte
x: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. [IP: 91.189.91.82 80]
167.2 E: Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/g/gzip/gzip_1.10-0ubuntu4.1_amd64.deb 403 connecting to archive.ubuntu.com:80: connecting to 91.189.91.83:80: dial tcp 91.189.91.83:80: connectex:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. [IP: 91.189.91.82 80]
167.2 E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?
167.2 Fetched 11.6 MB in 2min 39s (72.8 kB/s)

Dockerfile-with-features:14

12 |
13 | # Unminimize Ubuntu to restore man pages
14 | >>> RUN yes | unminimize
15 |
16 | # Set up timezone

ERROR: failed to solve: process "/bin/sh -c yes | unminimize" did not complete successfully: exit code: 123
[2023-09-17T00:28:40.041Z] Stop (168350 ms): Run: docker buildx build --load --build-arg BUILDKIT_INLINE_CACHE=1 -f C:\Users\Admin\AppData\Local\Temp\devcontainercli\container-features\0.51.1-1694910351657\Dockerfile-with-features -t vsc-rdb-alpha-d2ada9813768c6ac39b119b198565f1ded176a0a7e7baccc5d544522e02ce872 --target dev_containers_target_stage --build-arg _DEV_CONTAINERS_BASE_IMAGE=dev_container_auto_added_stage_label g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha
[2023-09-17T00:28:40.043Z] Error: Command failed: docker buildx build --load --build-arg BUILDKIT_INLINE_CACHE=1 -f C:\Users\Admin\AppData\Local\Temp\devcontainercli\container-features\0.51.1-1694910351657\Dockerfile-with-features -t vsc-rdb-alpha-d2ada9813768c6ac39b119b198565f1ded176a0a7e7baccc5d544522e02ce872 --target dev_containers_target_stage --build-arg _DEV_CONTAINERS_BASE_IMAGE=dev_container_auto_added_stage_label g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha
[2023-09-17T00:28:40.043Z] at CAA (c:\Users\Admin.vscode\extensions\ms-vscode-remote.remote-containers-0.309.0\dist\spec-node\devContainersSpecCLI.js:463:1752)
[2023-09-17T00:28:40.043Z] at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
[2023-09-17T00:28:40.043Z] at async jw (c:\Users\Admin.vscode\extensions\ms-vscode-remote.remote-containers-0.309.0\dist\spec-node\devContainersSpecCLI.js:462:1691)
[2023-09-17T00:28:40.043Z] at async FK (c:\Users\Admin.vscode\extensions\ms-vscode-remote.remote-containers-0.309.0\dist\spec-node\devContainersSpecCLI.js:462:610)
[2023-09-17T00:28:40.043Z] at async FAA (c:\Users\Admin.vscode\extensions\ms-vscode-remote.remote-containers-0.309.0\dist\spec-node\devContainersSpecCLI.js:479:3660)
[2023-09-17T00:28:40.043Z] at async GC (c:\Users\Admin.vscode\extensions\ms-vscode-remote.remote-containers-0.309.0\dist\spec-node\devContainersSpecCLI.js:479:4775)
[2023-09-17T00:28:40.043Z] at async VeA (c:\Users\Admin.vscode\extensions\ms-vscode-remote.remote-containers-0.309.0\dist\spec-node\devContainersSpecCLI.js:611:12240)
[2023-09-17T00:28:40.044Z] at async WeA (c:\Users\Admin.vscode\extensions\ms-vscode-remote.remote-containers-0.309.0\dist\spec-node\devContainersSpecCLI.js:611:11981)
[2023-09-17T00:28:40.056Z] Stop (169469 ms): Run: C:\Users\Admin\AppData\Local\Programs\Microsoft VS Code\Code.exe --ms-enable-electron-run-as-node c:\Users\Admin.vscode\extensions\ms-vscode-remote.remote-containers-0.309.0\dist\spec-node\devContainersSpecCLI.js up --user-data-folder c:\Users\Admin\AppData\Roaming\Code\User\globalStorage\ms-vscode-remote.remote-containers\data --container-session-data-folder /tmp/devcontainers-7ed084e5-ff02-4c21-bf1e-82ad8a0565711694910347456 --workspace-folder g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha --workspace-mount-consistency cached --id-label devcontainer.local_folder=g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha --id-label devcontainer.config_file=g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha.devcontainer\devcontainer.json --log-level debug --log-format json --config g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha.devcontainer\devcontainer.json --default-user-env-probe loginInteractiveShell --remove-existing-container --mount type=volume,source=vscode,target=/vscode,external=true --mount type=bind,source=\wsl.localhost\Ubuntu\run\user\1000\wayland-0,target=/tmp/vscode-wayland-725a170d-b560-4426-b389-405e31c87859.sock --skip-post-create --update-remote-user-uid-default on --mount-workspace-git-root true --terminal-columns 218 --terminal-rows 15
[2023-09-17T00:28:40.056Z] Exit code 1
[2023-09-17T00:28:40.059Z] Command failed: C:\Users\Admin\AppData\Local\Programs\Microsoft VS Code\Code.exe --ms-enable-electron-run-as-node c:\Users\Admin.vscode\extensions\ms-vscode-remote.remote-containers-0.309.0\dist\spec-node\devContainersSpecCLI.js up --user-data-folder c:\Users\Admin\AppData\Roaming\Code\User\globalStorage\ms-vscode-remote.remote-containers\data --container-session-data-folder /tmp/devcontainers-7ed084e5-ff02-4c21-bf1e-82ad8a0565711694910347456 --workspace-folder g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha --workspace-mount-consistency cached --id-label devcontainer.local_folder=g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha --id-label devcontainer.config_file=g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha.devcontainer\devcontainer.json --log-level debug --log-format json --config g:\My Drive\2. Data_Learning\Online_Courses\freeCodeCamp\Relational Database\rdb-alpha.devcontainer\devcontainer.json --default-user-env-probe loginInteractiveShell --remove-existing-container --mount type=volume,source=vscode,target=/vscode,external=true --mount type=bind,source=\wsl.localhost\Ubuntu\run\user\1000\wayland-0,target=/tmp/vscode-wayland-725a170d-b560-4426-b389-405e31c87859.sock --skip-post-create --update-remote-user-uid-default on --mount-workspace-git-root true --terminal-columns 218 --terminal-rows 15
[2023-09-17T00:28:40.059Z] Exit code 1

Please help to fix, thank you guys!