Error in db account creation

[Naman794]

Client table is missing, which is not letting the user create account

[jaypey]

Hi,

The bot requires an sqlite3 database with the Client table to work.

In the command line in the same directory as confi.py, type sqlite3 coin.db, it will create the database.

Then, copy the following sql script in a .txt file (same directory):

CREATE TABLE "Clients" (
	"id"	INTEGER NOT NULL,
	"client_name"	varchar(255) NOT NULL,
	"balance"	int,
	"last_daily"	varchar(255),
	PRIMARY KEY("id")
)

To add the table to the database, just type .read <yourtextfile>.txt while in sqlite3.

It should work after that, you can also confirm the table has been created by using .tables which lists all the existing tables from the database.

[Naman794]

understood thanks for the reply!✌

…

On Thu, 6 Jan 2022 at 23:44, JP Belval ***@***.***> wrote: Hi, The bot requires an sqlite3 database with the Client table to work. In the command line in the same directory as confi.py, type sqlite3 coin.db, it will create the database. Then, copy the following sql script in a .txt file (same directory): CREATE TABLE "Clients" ( "id" INTEGER NOT NULL, "client_name" varchar(255) NOT NULL, "balance" int, "last_daily" varchar(255), PRIMARY KEY("id") ) To add the table to the database, just type .read <yourtextfile>.txt while in sqlite3. It should work after that, you can also confirm the table has been created by using .tables which lists all the existing tables from the database. — Reply to this email directly, view it on GitHub <#5 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/APTTFAJJKMZFLGM25Y7EBQTUUXLZBANCNFSM5LMAINHA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>