Hi, I’m trying to log on my installation and got the user incorrect, so I searched for some errors and found this topic [Preformatted text](https://forum2.seatable.io/t/reset-user-and-or-admin-password/1985)
so I went to this database and found these ‘users’
None of them are users from my system, so I tried to log in with the last user that I created using the email from the table and the password and ok, works, but I got this page
so, for more tests, I tried to generate a new super user with
seatable.sh superuser
and got this error
root@2def993fda0c:/opt/seatable/scripts# seatable.sh superuser
2024-05-01 13:02:06 [INFO] xmlschema[1234] - Resource 'XMLSchema.xsd' is already loaded
System check identified some issues:
WARNINGS:
?: (staticfiles.W004) The directory '/opt/seatable/seatable-server-4.3.0/dtable-web/seahub/../frontend/build' in the STATICFILES_DIRS setting does not exist.
E-mail address: email@email.com
Password:
Password (again):
Traceback (most recent call last):
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/mysql/base.py", line 75, in execute
return self.cursor.execute(query, args)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/connections.py", line 254, in query
_mysql.connection.query(self, query)
MySQLdb.OperationalError: (1054, "Unknown column 'profile_profile.is_manually_set_contact_email' in 'field list'")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/management/__init__.py", line 442, in execute_from_command_line
utility.execute()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/management/__init__.py", line 436, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/management/base.py", line 412, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/management/base.py", line 458, in execute
output = self.handle(*args, **options)
File "/opt/seatable/seatable-server-4.3.0/dtable-web/seahub/base/management/commands/createsuperuser.py", line 150, in handle
User.objects.create_superuser(email, password)
File "/opt/seatable/seatable-server-4.3.0/dtable-web/seahub/base/accounts.py", line 170, in create_superuser
u = self.create_user(email, password, is_staff=True, is_active=True)
File "/opt/seatable/seatable-server-4.3.0/dtable-web/seahub/base/accounts.py", line 101, in create_user
Profile.objects.add_or_update(username=virtual_id, contact_email=email, need_show_video=True)
File "/opt/seatable/seatable-server-4.3.0/dtable-web/seahub/profile/models.py", line 29, in add_or_update
profile = self.get(user=username)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/manager.py", line 87, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/query.py", line 633, in get
num = len(clone)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/query.py", line 380, in __len__
self._fetch_all()
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/query.py", line 91, in __iter__
results = compiler.execute_sql(
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/sql/compiler.py", line 1562, in execute_sql
cursor.execute(sql, params)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/mysql/base.py", line 75, in execute
return self.cursor.execute(query, args)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/connections.py", line 254, in query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1054, "Unknown column 'profile_profile.is_manually_set_contact_email' in 'field list'")
So, my database changed? Missing tables, the user’s email changed, I can log in but the page after login gives me an error, I’m lost in debugging this.
Thanks for any help on this.
