anselal / antminer-monitor

Cryptocurrency ASIC mining hardware monitor using a simple web interface
GNU General Public License v3.0
228 stars 145 forks source link

sqlalchemy.exc.OperationalError (no such table: user ) #150

Closed georgi-id closed 4 years ago

georgi-id commented 4 years ago

I'm getting an error after I try and login with the default user admin/antminermonitor sqlalchemy.exc.OperationalError OperationalError: (sqlite3.OperationalError) no such table: user [SQL: SELECT user.id AS user_id, user.username AS user_username, user.email AS user_email, user.password_hash AS user_password_hash, user.surname AS user_surname, user.firstname AS user_firstname, user.active AS user_active FROM user WHERE user.username = ? LIMIT ? OFFSET ?] [parameters: (u'admin', 1, 0)] (Background on this error at: http://sqlalche.me/e/e3q8)

anselal commented 4 years ago

Please read the readme.

You have to create the tables first.

https://github.com/anselal/antminer-monitor/blob/master/README.md#login-page

georgi-id commented 4 years ago

I have used python manage.py create-db to create the DB and if I try again it returns [INFO] Database already exists.

By the way in the latest version commands for manage.py are with a dash instead of underscore as stated in the readme.

anselal commented 4 years ago

My friend, again, read the readme.

Follow the link i just sent you. You have to create the admin account.

anselal commented 4 years ago

@Omgthehorror did you eventually run python manage.py create-admin to create the admin user ?

georgi-id commented 4 years ago

@anselal I did it the first time as well. In the end, had to delete everything, re-download the files and go through the procedure from scratch and now it works as intended.