Hello,
I have not added a website recently and now I had to install wordpress. However I noticed that the old option is not longer availavble when you click on Website -> Add site -> Deploy Wordpress. Then I tried adding from wp-toolkit butI got an error no such table databases and another error now on the home page of the panel after running fix
Traceback (most recent call last):
File "/www/server/panel/pyenv/lib/python3.12/site-packages/flask/app.py", line 1823, in full_dispatch_request
rv = self.dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/panel/pyenv/lib/python3.12/site-packages/flask/app.py", line 1799, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/panel/BTPanel/__init__.py", line 4618, in domain_v2
from ssl_domainModelV2.api import DomainObject
File "/www/server/panel/class/public/hook_import.py", line 25, in _aap__import__
return old__import__(name, globals, locals, fromlist, level)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/panel/class_v2/ssl_domainModelV2/api.py", line 1415, in
sync_site_ssl()
File "/www/server/panel/class_v2/ssl_domainModelV2/service.py", line 948, in sync_site_ssl
F6sB81JoKkHaj4jvXPj8cmJtTL5QGc7J8yb6ZzVGFYJsbufg7Uue6KSfuPM/Vq9mD9tLW+CL1joebLp+Nz/mrzmmwYCHMgT00fNhx2LYjjw=
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^~~~~~~
File "/www/server/panel/class/public/sqlite_easy.py", line 2560, in select
return self.query(raw_sql, bind_params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/panel/class/public/sqlite_easy.py", line 2199, in query
ret = self.__DB.client().query(raw_sql, _to_tuple(params), take_first)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/panel/class/public/sqlite_easy.py", line 1059, in query
ret = self.__sqlite_retry_help(self.__query_help, sql, params, take_first)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/www/server/panel/class/public/sqlite_easy.py", line 1029, in __sqlite_retry_help
raise e
File "/www/server/panel/class/public/sqlite_easy.py", line 1023, in __sqlite_retry_help
return fn(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^
File "/www/server/panel/class/public/sqlite_easy.py", line 1075, in __query_help
cur = self.__CONN.execute(sql, _to_tuple(params))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: no such table: sites
The issue started with this particular website that I tried to add. It had some data left after I tried deleting it and whenever I click on Website -> The site in question -> I get the above error.
No sure where this table sites should be . I removed the site previously from
data/default.db
delete from domain where name='imoti3d.com';
delete from sites where name='imoti3d.com';
Because I was having another error site already exists
The issue might be with this site that glitched during importing it.
How can I fix that? Any help would be great