Celestial Bodies Database - Build a Celestial Bodies Database

Backend Development
1

Hi there,

I have completed the " Build a Celestial Bodies Database" challenge.

I have made a Github account also. What I am struggling with is how to upload my finished database to Github so I can submit my work.

This is probably a very basic question but any help would be appreciated.

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36

Challenge: Celestial Bodies Database - Build a Celestial Bodies Database

Link to the challenge:

2

Firstly, in a bash terminal within the course, you need to create a dump of your database:

pg_dump -cC --inserts -U freecodecamp universe > universe.sql

This will create a universe.sql file in the project folder.

Next, open up a notepad (or similar app) on your PC and paste the entire contents of the above file and then save it to your desktop with the same filename.

Finally, create a new GitHub repo and upload the file to it.

You can then submit the repo link to FCC to pass the project.

2 Likes
5

Hi,

Thank you for that!

I have followed those steps and have a notepad document uploaded to my Github account with the solution. Unfortunately the URL isn’t being accepted, I get an error message saying “the project must be completed first”.

Any idea why this is? URL as below:

https://github.com/SBBanger/Build-Celestial-Bodies/blob/main/universe.sql/

Thanks

6

You might need to go back into the project. If you’ve completed the project successfully on CodeAlly you should see a 100% completion message. Make sure you click ‘Continue’ on this message and then go back to the FCC curriculum and click back through to the project page where you submit your git repo link.

7

Hi, Im having the same problem and this solution does not work for me.

8

is the file which is supposed to to be uploaded has to be named:
universe.sql

while uploading it to the github?

9

In GitHub, a repository must be created with the name of the project where you are busy.
A file called “universe.sql” must be added to the repository.
Copy the content from “universe.sql” generated in the project to the file “universe.sql” added to the GitHub repository.
The repository link from GitHub must be added in " step 2 " in the project.

1 Like
10

yes I did that

11

Copy the link ( adapted to your profile ) and past it in the “step 2” of the project.
image

12

ok
Thank you, Let me try that.

13

Thank you @icxc
it got passed

14

I have the same problem.
First project is fully completed, but during I past a link on GitHub repo with solution and entering buttom “I’ve competed this challenge” appears note: “You must complete the project first”.

The same problem was in previous course named “Learn Relational Databases by Building a Mario Database”. I complete the project and were waiting a check mark in cource card for 4 days.
Maybe information are updated in 3-4 after tasks is completed.

15

Have the same problem.

16

This is the most frustrating part of this whole process! I can’t make it work

17

For another project, reloading the page that says “You must complete the project first” worked. Worth giving a shot. : )

1 Like
18

Hi All,

I created the tables earlier with out a foreign key that references. Can you please advice if I am able to add them at later stage or the table need to be created again?

Screenshot 2024-05-06 at 2.46.58 PM
Screenshot 2024-05-06 at 2.46.58 PM1513×783 217 KB

19

Hello - same issue:

  • completed the project
  • dumped in bash
  • saved a notepad copy titled universe.sql in gitHub
  • url is not passing in FCC, with the message ‘you must complete project first’
    Thank you!
1 Like
20

La solución final es “Actualizar” (o es su defecto, volver a entrar al ejercicio), la pagina con las instrucciones del ejercicio. Pegar el “PATH” de GitHub donde figura el Archivo ‘universe.sql’ y completar.

Es la unica forma. Si no se actualiza la pagina, no funciona y nos va a dar siempre el error de que se debe finalizar el ejercicio.

Recordar que le PATH debe coincidir con el nombre del ejercicio.
Ej:
https://github.com/(tu_usuario)/learn-celestial-bodies-database/blob/981d95c2b2fe7e530657885fd04f33b0ce7bb01a/universe.sql

Este “PATH” se logra entrando en las opciones de la derecha (…)
No hay otra forma. Estuve varias horas peleando y era solo actualizar la pagina.

image
image827×376 27.9 KB