search

kylej26 / boardgame-directory

0 stars 0 forks source link

Doesn't seem connected to a database #1

Closed dcornewell closed 11 months ago

dcornewell commented 11 months ago

You mentioned just running npm start in your email. I tried just that and it did start but when I browse to it, I get errors.

It seemed like it wasn't actually getting any data from a database so I followed our instructions in the Readme to load a database using your schema.sql but that also had errors. I am using MariaDB 10.3. Does this need something else for a database? I'll start with the SQL error since it is smaller.

Let me know what I'm missing and I can try again.

Error from SQL load

mysql devchallenge_$APPLICANT_USER < schema.sql
ERROR 1064 (42000) at line 19: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 11

Error from loading a page

npm start

> miechallenge@1.0.0 start /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master
> node .

Server running on port: 3421
Connected to database

TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)

TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)
TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)
TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10                                                                       [91/1979]
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)
TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)
TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)
TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)
TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)
TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)
TypeError: /storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/views/index.ejs:10
    8|
    9|   <ul>
 >> 10|     <% game.forEach(game => { %>
    11|       <li>
    12|         <span class="gamename"><%= game.Name %></span></li> -
    13|         <li> <span class="played">Times played: <%= game.times_played %></span></li>

Cannot read property 'forEach' of undefined
    at eval (eval at compile (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:673:12), <anonymous>:19:13)
    at index (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:703:17)
    at tryHandleCache (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:274:36)
    at View.exports.renderFile [as engine] (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/ejs/lib/ejs.js:491:10)
    at View.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/view.js:135:8)
    at tryRender (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:657:10)
    at Function.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/application.js:609:3)
    at ServerResponse.render (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/express/lib/response.js:1039:7)
    at Query.db.query (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/routes/index.js:13:11)
    at Query.<anonymous> (/storage/home/dcornewell/notbackedup/devchallenges/kylejenkins/MIE-challenge-Kyle-Jenkins-master/node_modules/mysql/lib/Connection.js:526:10)
kylej26 commented 11 months ago

This should be fixed and I committed the code back to the branch. The error on the schema.sql was a missing DELIMETER wrapper. Ran it in mariadb and was able to run without error.

The other error looks like it was from fetching the game data from the database which I think would work now with the sql fix. I added a check in that file as well to return no game data if it is not fetching the database correctly or there is no games in the table. Hopefully it should run properly now with the SQL fix