# Relational Database Courses - Persistent Issues **URL:** \ **Category:** freeCodeCamp Contributors\ **Tags:** contributing\ **Created:** [March 22, 2023, 3:34pm UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035 "2023-03-22T15:34:33Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![igorgetmeabrain](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/igorgetmeabrain/32/314517_2.png) [@igorgetmeabrain](https://forum.freecodecamp.org/u/igorgetmeabrain)\ **Post date:** [March 22, 2023, 3:34pm UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/1 "2023-03-22T15:34:33Z")
For the last few days I’ve seen multiple reports of people experiencing issues with these courses, particularly concerning the running of the CodeRoad tests and terminal/connection problems. I’ve been getting all kinds of weird results myself when working on the World Cup Database course.. Firstly, the tests throw up some kind of ‘before all hook’ error message and fail to recognise that my database exists, even though I can connect to it and view its contents (and have passed all corresponding tests previously). Secondly, when I try to seed the database with my bash script, it appears to do so successfully, in that I can then view all of the rows in my tables (though the tests refuse to acknowledge this too). I also get weird terminal behaviour similar to this screenshot. What are all these tildes for? That’s what happens when I do a ‘SELECT \* …’ command on my games table. ![Untitled](https://global.discourse-cdn.com/freecodecamp/original/4X/d/e/e/dee763e89db945fb2cc08ecf9a179a5071abb780.png) ---
**Author:** ![Sky020](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/sky020/32/128093_2.png) [@Sky020](https://forum.freecodecamp.org/u/Sky020)\ **Post date:** [March 22, 2023, 4:41pm UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/2 "2023-03-22T16:41:00Z")
I am not particularly aware of why there are issues with connections/tests in this section. I do just know: > [@igorgetmeabrain](#): > > I also get weird terminal behaviour similar to this screenshot. What are all these tildes for? That’s what happens when I do a ‘SELECT \* …’ command on my games table. The tildes are showing that those lines are not empty whitespace - they are not a part of the file/output. Typically, you see these with applications like `less`, and are configurable: > -~ or --tilde > Normally lines after end of file are displayed as a single > tilde (~). This option causes lines after end of file to > be displayed as blank lines. > [less(1) - Linux manual page](https://man7.org/linux/man-pages/man1/less.1.html) Hope that helps clear up your _aside_ question. ---
**Author:** ![igorgetmeabrain](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/igorgetmeabrain/32/314517_2.png) [@igorgetmeabrain](https://forum.freecodecamp.org/u/igorgetmeabrain)\ **Post date:** [March 23, 2023, 1:36pm UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/3 "2023-03-23T13:36:16Z")
Thanks for the response @Sky020 So, this is one of the persistent issues I’m experiencing (error message below). Sometimes, if I DROP DATABASE, save everything and reload, it starts to work again and I pass all tests. Other times it just doesn’t play ball. Another persistent issue is that the psql terminal crashes on me quite a bit, churning out tildes (as mentioned above) and then refusing to accept further input. ![Untitled](https://global.discourse-cdn.com/freecodecamp/original/4X/2/9/d/29d43756c7231bf2a843764dd00779671bcd129c.png) ---
**Author:** ![igorgetmeabrain](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/igorgetmeabrain/32/314517_2.png) [@igorgetmeabrain](https://forum.freecodecamp.org/u/igorgetmeabrain)\ **Post date:** [March 23, 2023, 4:47pm UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/4 "2023-03-23T16:47:12Z")
Another error. ![Untitled](https://global.discourse-cdn.com/freecodecamp/original/4X/e/6/0/e6068074b07674a9f46a9e6b1f558517a87a6bf9.png) ---
**Author:** ![igorgetmeabrain](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/igorgetmeabrain/32/314517_2.png) [@igorgetmeabrain](https://forum.freecodecamp.org/u/igorgetmeabrain)\ **Post date:** [March 24, 2023, 11:29am UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/5 "2023-03-24T11:29:32Z")
I have completed all code for this project now and have saved the relevant files into a git repo. I cannot for the life of me get the tests to pass on CodeRoad though, as I keep getting a ‘before all hook’ error message (as above). So I can’t complete the project on CodeRoad. Everything else working as expected. My database exists and the insert\_data.sh and queries.sh files behave exactly as expected and the output is exactly as specified. I have deleted the entire project on CodeAlly and started afresh twice but no dice. When I submit my git repo link, FCC tells me I need to complete the project first. Any ideas? ---
**Author:** ![igorgetmeabrain](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/igorgetmeabrain/32/314517_2.png) [@igorgetmeabrain](https://forum.freecodecamp.org/u/igorgetmeabrain)\ **Post date:** [March 25, 2023, 12:29pm UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/6 "2023-03-25T12:29:37Z")
I have finally successfully completed this project! My solution? 1. Delete the container in CodeAlly 2. Restart the project in FCC 3. Rebuild the database structure from scratch (without using dump file) 4. Paste in my previously written code for the insert\_data.sh and queries.sh files 5. Give them executable permissions and run them both 6. Run the tests and get 100% Complete message (finally!) 7. Submit git repo link to FCC ---
**Author:** ![luisfelix4](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/luisfelix4/32/308701_2.png) [@luisfelix4](https://forum.freecodecamp.org/u/luisfelix4)\ **Post date:** [April 5, 2023, 5:45am UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/7 "2023-04-05T05:45:18Z")
How do you delete container? Last step wont complete even after getting al lthe results ---
**Author:** ![igorgetmeabrain](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/igorgetmeabrain/32/314517_2.png) [@igorgetmeabrain](https://forum.freecodecamp.org/u/igorgetmeabrain)\ **Post date:** [April 5, 2023, 9:11am UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/8 "2023-04-05T09:11:29Z")
First, make sure you have saved a local backup of your files though (i.e. insert\_data.sh and queries.sh). Log in to [CodeAlly](https://codeally.io/) and click on the Cloud IDE tab. You should see a list of all of your projects and you can delete the one which is causing you issues. Then, when you’ve deleted the project container, you can go back to FCC and start the project afresh. Rebuild the database structure manually and then recreate your files from your backup and try running the tests. This should hopefully avoid the ‘before all hook’ error which prevents the project completing successfully on CodeRoad. ---
**Author:** ![luisfelix4](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/luisfelix4/32/308701_2.png) [@luisfelix4](https://forum.freecodecamp.org/u/luisfelix4)\ **Post date:** [April 5, 2023, 1:36pm UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/9 "2023-04-05T13:36:30Z")
Thank you, did that but still stick in the same problem. Here are my codes if someone can check it out > **[GitHub - Lefp1122/Worldcup](https://github.com/Lefp1122/Worldcup)** > > Contribute to Lefp1122/Worldcup development by creating an account on GitHub. ![image](https://global.discourse-cdn.com/freecodecamp/original/4X/7/6/a/76a63fc7882c1985b3f7f3d9be38c7cd9d702669.png) Results from querie.sh Total number of goals in all games from winning teams: 68 Total number of goals in all games from both teams combined: 90 Average number of goals in all games from the winning teams: 2.1250000000000000 Average number of goals in all games from the winning teams rounded to two decimal places: 2.13 Average number of goals in all games from both teams: 2.81250000000000000000 Most goals scored in a single game by one team: 7 Number of games where the winning team scored more than two goals: 6 Winner of the 2018 tournament team name: France List of teams who played in the 2014 ‘Eighth-Final’ round: Algeria Argentina Belgium Brazil Chile Colombia Costa Rica France Germany Greece Mexico Netherlands Nigeria Switzerland United States Uruguay List of unique winning team names in the whole data set: Argentina Belgium Brazil Colombia Costa Rica Croatia England France Germany Netherlands Russia Sweden Uruguay Year and team name of all the champions: 2014|Germany 2018|France List of teams that start with ‘Co’: Colombia Costa Rica ---
**Author:** ![system](https://global.discourse-cdn.com/freecodecamp/original/3X/e/1/e1c433102e34b46dfaa3e15d13ab9a514b127078.svg) [@system](https://forum.freecodecamp.org/u/system)\ **Post date:** [October 5, 2023, 1:36am UTC](https://forum.freecodecamp.org/t/relational-database-courses-persistent-issues/600035/10 "2023-10-05T01:36:36Z")
Closed on October 5, 2023, 1:36am UTC This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.