1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Unable to Delete Database

Discussion in 'Plesk for Windows - 8.x and Older' started by ballubro, May 8, 2008.

  1. ballubro

    ballubro Guest

    0
     
    Hi,

    We have created database in pleask. Now we wanted to delete that. We removed it from SQL server because we were unable to delete it from plesk. Now after deleting from sql server ,still we are unable to delete from Plesk.It Gives Following Error:

    Delete database user failed: Could not locate entry in sysdatabases for database 'abc'. No entry found with that name. Make sure that the name is entered correctly.
    ---------------------- Debug Info -------------------------------
    0: C:\Program Files\SWsoft\Plesk\admin\plib\DatabaseManagerMSSQL.php:52
    DatabaseManagerMSSQL->dropUserImpl(string 'abc', string 'abc')
    1: C:\Program Files\SWsoft\Plesk\admin\plib\DatabaseManager.php:175
    DatabaseManager->deleteUser(object of type dbUser)
    2: C:\Program Files\SWsoft\Plesk\admin\plib\class.DataBaseUsersList.php:126
    DataBaseUsersList->remove(array)
    3: C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\db_edit.php3:101

    Since we are allowed to create only 4 database,whichwe have created and we want to delete 2 .But unable to do so.
     
  2. ally@

    ally@ Guest

    0
     
    in this case it is only possible to delete the entries from Plesk database

    delete from data_bases where name= "databasename"
    delete from db_users where db_id=X

    where X is the id of the database in the table data_bases
     
  3. arisd

    arisd Basic Pleskian

    23
    90%
    Joined:
    Jan 31, 2007
    Messages:
    60
    Likes Received:
    0
    Delete database...

    ally was right - manualy delete databases from data folder and than go in plesk database and delete databasename in data_bases table - since user does not exist that's enough - but if user exists than also delete user from db_users.
     
Loading...