I can't delete a database in aaPanel

micholas

The database is MySQL MariaDB_10.7.
When I try to delete the database, I get an error message like this:

Traceback (most recent call last):
File "/www/server/panel/BTPanel/init.py", line 1814, in publicObject
return run_exec().run(toObject, defs, get)
File "/www/server/panel/BTPanel/init.py", line 1766, in run
result is gotten from getattr(toObject, get.action)(get)
File "class/database.py", line 598, in DeleteDatabase
for us in users:
TypeError: 'InternalError' object is not iterable

How can I fix this issue?
Please help me.

aaPanel_Kern

Hello, what version is your panel?
Check whether mysql is running and whether mysql has a related database?

micholas

aaPanel Version: 6.8.32
My MySQL is running.

The database has been deleted in phpMyAdmin, but the database name cannot be removed from the dashboard panel. When attempting to delete it from the aaPanel dashboard, I receive an error message as follows:

Traceback (most recent call last):
File "/www/server/panel/BTPanel/init.py", line 1814, in publicObject
return run_exec().run(toObject, defs, get)
File "/www/server/panel/BTPanel/init.py", line 1766, in run
result is obtained from getattr(toObject, get.action)(get)
File "class/database.py", line 598, in DeleteDatabase
for us in users:
TypeError: 'InternalError' object is not iterable

aaPanel_Kern

micholas
Hello, it is recommended that you re-synchronize the database in the database interface.

micholas

Hi,
I have resynchronized the database and still encounter the same issue

aaPanel_Kern

Is it possible to try to add a new database that does not exist? Is it normal if I can add it and synchronize it again?

micholas

Yes, I can add a new database and synchronize it. However, after that, I am unable to delete the database name from the panel, even though the data tables have been deleted.

aaPanel_Kern

It is recommended that you use phpmyadmin to add a database with the same name and then delete it from the panel

micholas

aaPanel_Kern I will try it.

micholas

aaPanel_Kern I have attempted to create a database with the same name in phpMyAdmin and subsequently delete it. However, I continue to face the same issue.

micholas

When opening the panel, an additional error popup appears as follows:

Traceback (most recent call last):
File "/www/server/panel/pyenv/lib/python3.7/site-packages/requests/models.py", line 971, in json
return complexjson.loads(self.text, **kwargs)
File "/www/server/panel/pyenv/lib/python3.7/json/init.py", line 348, in loads
return default_decoder.decode(s)
File "/www/server/panel/pyenv/lib/python3.7/json/decoder.py", line 337, in decode
obj, end = self.raw_decode(s, idx=w(s, 0).end())
File "/www/server/panel/pyenv/lib/python3.7/json/decoder.py", line 355, in raw_decode
raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1, column 1 (char 0)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/www/server/panel/BTPanel/init.py", line 1814, in publicObject
return run_exec().run(toObject, defs, get)
File "/www/server/panel/BTPanel/init.py", line 1766, in run
result = getattr(toObject, get.action)(get)
File "class/panelPlugin.py", line 725, in get_index_list
softList = self.get_cloud_list(get)['list']
File "class/panelPlugin.py", line 367, in get_cloud_list
listTmp = listTmp.json()
File "/www/server/panel/pyenv/lib/python3.7/site-packages/requests/models.py", line 975, in json
raise RequestsJSONDecodeError(e.msg, e.doc, e.pos)
requests.exceptions.JSONDecodeError: Expecting value: line 1, column 1 (char 0)

aaPanel_Kern

Hello, can you give us your aapanel information? Make a snapshot backup of the server first. If possible, please send it to kern@aapanel.com.
It is recommended to fill in the following content
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:
Database name:

If there is no post link, it will be impossible to know which user's information it is, and the problem will not be processed.

micholas

aaPanel_Kern

Hello, please confirm whether the user and password are correct. It prompts that the password is incorrect.

micholas