Fehler beim Löschen einer Datenbank

**oekowalti** · Mar 29th 2016

Beim Löschen einer Datenbank erhalte ich den folgenden Fehler:

Code

Dear admin,
An exception has been thrown in file/var/www/imscp/gui/library/Functions/Shared.php at line 2724:
=================================================================
SQLSTATE[42000]: Syntax error or access violation: 1141 There is no such grant defined for user 't3_alb_user' on host 'localhost'
Query was:
REVOKE ALL PRIVILEGES ON `t3_alb_neu`.* FROM 't3_alb_user'@'localhost'
=================================================================
Debug backtrace:---------------
File: /var/www/imscp/gui/library/Functions/Shared.php at line 686Function: exec_query()File: /var/www/imscp/gui/library/Functions/Shared.php at line 731Function: sql_delete_user()File: /var/www/imscp/gui/public/client/sql_database_delete.php at line44Function: delete_sql_database()
Additional information:----------------------
Http User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0)Gecko/20100101 Firefox/45.0Request Uri: /client/sql_database_delete.php?id=78Http Referer: https://91.214.168.30:4443/client/sql_manage.phpRemote Addr: 178.199.5.228Server Addr: 91.214.168.30
____________________________________________________________i-MSCP Exception Mail Writer
Note: You will not receive further emails for this exception in the next 24 hours.

Display More

Offenbar geht es um fehlende Privilegien.
Dieses Problem eilt nicht, ich wollte einfach nicht mehr benötigte Datenbank löschen.

Was ist zu tun?

**Nuxwin** · Mar 29th 2016

Distro, codename?
SQL server in use?

**oekowalti** · Mar 29th 2016

@Nuxwin:
Distro is Jessie, all packages updatet.
SQL-Server is working. But what do you mean with 'in use'?

May be this constallation is responsible fo the error:

**Nuxwin** · Mar 29th 2016

I'll investigate

**Nuxwin** · Mar 30th 2016

A fix has been added in 1.2.x branch. See https://github.com/i-MSCP/imsc…85bb14d84657ff7c65fd2cfc9
This fix will be part of version 1.2.18.

Thanks you for your report.

**oekowalti** · Mar 30th 2016

Hello @Nuxwin:
I still has the following error after having changed the file 'Shared.php':

Code

Dear admin,
An exception has been thrown in file/var/www/imscp/gui/library/Functions/Shared.php at line 2724:
=================================================================
SQLSTATE[42000]: Syntax error or access violation: 1141 There is no such grant defined for user 't3_alb_user' on host 'localhost'
Query was:
REVOKE ALL PRIVILEGES ON `t3_alb_neu`.* FROM 't3_alb_user'@'localhost'
=================================================================
Debug backtrace:---------------
File: /var/www/imscp/gui/library/Functions/Shared.php at line 686Function: exec_query()File: /var/www/imscp/gui/library/Functions/Shared.php at line 731Function: sql_delete_user()File: /var/www/imscp/gui/public/client/sql_database_delete.php at line44Function: delete_sql_database()
Additional information:----------------------
Http User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0)Gecko/20100101 Firefox/45.0Request Uri: /client/sql_database_delete.php?id=78Http Referer: https://91.214.168.30:4443/client/sql_manage.phpRemote Addr: 178.199.5.228Server Addr: 91.214.168.30
____________________________________________________________i-MSCP Exception Mail Writer
Note: You will not receive further emails for this exception in the next 24 hours.

Display More

**Nuxwin** · Mar 30th 2016

after changing the file, you must not forgot to restart the imscp_panel service.

**oekowalti** · Mar 31st 2016

@Nuxwin
After new update process with changed Shared.php all works fine.
Thanks very much!
Have a good time.

Share