Backend Error

[dwi4122]

Deploy the mysql database to the vercel project. No players are showing in the deployed project.

[TharunKumarrA]

ok @dwi4122, the backend repo for now is missing the schema.sql file that will create all the tables for storing player details. The file will be pushed by eod and then you can run the backend locally. With my vercel plan I cant have the backend running in deployment. Hope you understand

[TharunKumarrA]

There was an issue created to address the same issue in the backend repo, in the mean time if you are comfortable replicating the database locally in the machine I am attaching the snaps of the table structure

[TharunKumarrA]

and @dwi4122 if you are willing you can take up the issue in the backend repo for database initialization and grab that bounty ;)

[thecodingvivek]

@dwi4122 I have got the same issue. After going through the code finally i understood that :

1)No need to deploy the sql database on vercel because as we are working on this project locally just try to install mysql . you can checkout this link to install : https://www.youtube.com/watch?v=BxdSUGBs0gM

2)create tables with schemas
example in mysql command line

3)add database credentials in sqlconnect.js

4)Create an account in ngrok. https://ngrok.com/ and copy the authtoken and add it your .env file
in server.js

5)Try running the server You should should see Something like this in your terminal

6)Now add the url shown in the terminal to your constants.js file

7)You will now get a cors error so add header to allow requests from all origins: res.header("Access-Control-Allow-Origin", "*");

8)Your fine to go now.HOPE THIS HELPS :)

[TharunKumarrA]

Yeah for now this is how to access backend. Great explanation @thecodingvivek

[thecodingvivek]

@TharunKumarrA Anna can i share this comment on backed repo for database initialisation to solve this issue ..?

[TharunKumarrA]

Yeah sure that would help