get5loader icon indicating copy to clipboard operation
get5loader copied to clipboard

[BUG] Error #01: Error 1146: Table 'get5.user' doesn't exist

Open tydaytygx opened this issue 4 years ago • 6 comments

Is there any guide to setup/modify the database?

Error #01: Error 1146: Table 'get5.user' doesn't exist

tydaytygx avatar Mar 22 '21 08:03 tydaytygx

Should I need to follow the python version database guide to create a database? Or I just need to create a database called get5 on mysql? Thanks for your apply!

tydaytygx avatar Mar 22 '21 09:03 tydaytygx

Hi, If you have get5 database from Python' version, you should migrate it for go by using this : https://github.com/FlowingSPDG/get5-web-go/tree/master/migration (build) : https://github.com/FlowingSPDG/get5-web-go/releases/tag/v0.1.2-migration or you can create new "get5" and migrate it.

btw, I recommend you to make a backup of original python get5-web table just in case you want to use Py's get5 again!

FlowingSPDG avatar Mar 22 '21 09:03 FlowingSPDG

Hi, If you have get5 database from Python' version, you should migrate it for go by using this : https://github.com/FlowingSPDG/get5-web-go/tree/master/migration (build) : https://github.com/FlowingSPDG/get5-web-go/releases/tag/v0.1.2-migration or you can create new "get5" and migrate it.

btw, I recommend you to make a backup of original python get5-web table just in case you want to use Py's get5 again!

Thanks for your apply! But now I consider to make a brand new database, is the database creating steps included in the get5-web-go version? By the way, I use Mysql and root with a new database called get5 with no tables. Should I need to create the tables manually? Thank you!

tydaytygx avatar Mar 22 '21 09:03 tydaytygx

Yes, its included inside of migration binary : https://github.com/FlowingSPDG/get5-web-go/releases/tag/v0.1.2-migration description : https://github.com/FlowingSPDG/get5-web-go/tree/master/migration

you should be able to use that new get5 DB without any changes!

FlowingSPDG avatar Mar 22 '21 09:03 FlowingSPDG

Yes, its included inside of migration binary : https://github.com/FlowingSPDG/get5-web-go/releases/tag/v0.1.2-migration description : https://github.com/FlowingSPDG/get5-web-go/tree/master/migration

you should be able to use that new get5 DB without any changes!

Seems I missed a whole step of creating the tables, thank you! I followed the schema and manually created the table. The description : https://github.com/FlowingSPDG/get5-web-go/tree/master/migration could be placed to the Readme#How to use But there is another error, the web told me that the team has registered successfully, but switching to the teams tag telling no teams found, no data changes in the database(the database has tables just like the schema), is there something wrong? (the 200 POST is successful)

2021/03/22 19:58:26 CreateTeam
[GIN] 2021/03/22 - 19:58:26 | 200 |    80.01108ms |       127.0.0.1 | POST     /api/v1/team/create

tydaytygx avatar Mar 22 '21 12:03 tydaytygx

Oh I notice that you change the ./migrate to ./migration in the binary. The team function work like a charm using your migration. Thank you! I shutdown all my scrds, but the adding the server seems still not working?

Error #01: JSON Format invalid

tydaytygx avatar Mar 22 '21 15:03 tydaytygx

Will be fixed with Got5 refactored version

FlowingSPDG avatar Aug 04 '23 12:08 FlowingSPDG