ERROR: PleskMainDBException MySQL query failed: Error on rename of './psa/#sql-1ca0_53b' to './psa/anon_ftp' (errno: 121) 0: /usr/local/psa/admin/plib/common_func.php3:211 db_query(string 'ALTER TABLE `anon_ftp` ENGINE = InnoDB') 1: /usr/local/psa/admin/plib/MySQL5FixBinaryColumns.php:59 MySQL5FixBinaryColumns->_handleTableBegin(string 'anon_ftp') 2: /usr/local/psa/admin/plib/SQLParser.php:63 SQLParser->_parseLineDefault(string 'CREATE TABLE `anon_ftp` (') 3: /usr/local/psa/admin/plib/SQLParser.php:46 SQLParser->parseLine(string 'CREATE TABLE `anon_ftp` (', integer '0') 4: : array_walk(array, array) 5: /usr/local/psa/admin/plib/SQLParser.php:23 SQLParser->getArray(array) 6: /usr/local/psa/admin/plib/SQLParser.php:30 SQLParser->handleDatabase() 7: /usr/local/psa/admin/plib/MySQL5FixBinaryColumns.php:36 MySQL5FixBinaryColumns::run() 8: /usr/local/psa/admin/auto_prepend/auth.php3:93 describe custom_buttons; +----------+----------------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+----------------------------------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | sort_key | int(10) unsigned | NO | | 100 | | | level | int(10) unsigned | NO | | 0 | | | level_id | int(10) unsigned | NO | | 0 | | | place | enum('domain','client','admin','navigation') | NO | | domain | | | text | varchar(255) | NO | | | | | url | varchar(255) | YES | | NULL | | | conhelp | text | YES | | NULL | | | options | int(10) unsigned | NO | | 0 | | | file | varchar(245) | NO | | | | +----------+----------------------------------------------+------+-----+---------+----------------+ 10 rows in set (0.00 sec) describe anon_ftp; +-------------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+----------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | dom_id | int(10) unsigned | NO | UNI | 0 | | | max_conn | int(10) unsigned | YES | | NULL | | | bandwidth | int(10) unsigned | YES | | NULL | | | incoming | enum('false','true') | NO | | false | | | incoming_readable | enum('false','true') | NO | | false | | | incoming_subdirs | enum('false','true') | NO | | false | | | status | enum('false','true') | NO | | false | | | quota | bigint(20) unsigned | YES | | 1048576 | | | display_login | enum('false','true') | NO | | false | | | login_text | text | YES | | NULL | | +-------------------+----------------------+------+-----+---------+----------------+ 11 rows in set (0.00 sec) SHOW CREATE TABLE anon_ftp; +----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | anon_ftp | CREATE TABLE `anon_ftp` ( `id` int(10) unsigned NOT NULL auto_increment, `dom_id` int(10) unsigned NOT NULL default '0', `max_conn` int(10) unsigned default NULL, `bandwidth` int(10) unsigned default NULL, `incoming` enum('false','true') NOT NULL default 'false', `incoming_readable` enum('false','true') NOT NULL default 'false', `incoming_subdirs` enum('false','true') NOT NULL default 'false', `status` enum('false','true') NOT NULL default 'false', `quota` bigint(20) unsigned default '1048576', `display_login` enum('false','true') NOT NULL default 'false', `login_text` text character set utf8, PRIMARY KEY (`id`), UNIQUE KEY `dom_id` (`dom_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) SHOW CREATE TABLE custom_buttons; +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | custom_buttons | CREATE TABLE `custom_buttons` ( `id` int(10) unsigned NOT NULL auto_increment, `sort_key` int(10) unsigned NOT NULL default '100', `level` int(10) unsigned NOT NULL default '0', `level_id` int(10) unsigned NOT NULL default '0', `place` enum('domain','client','admin','navigation') NOT NULL default 'domain', `text` varchar(255) character set utf8 NOT NULL default '', `url` varchar(255) character set utf8 default NULL, `conhelp` text character set utf8, `options` int(10) unsigned NOT NULL default '0', `file` varchar(245) character set ascii collate ascii_bin NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) 070401 9:50:43 InnoDB: Error; possible reasons: InnoDB: 1) Table rename would cause two FOREIGN KEY constraints InnoDB: to have the same internal name in case-insensitive comparison. InnoDB: 2) table `psa/itmpl_data` exists in the InnoDB internal data InnoDB: dictionary though MySQL is trying rename table `psa/#sql-1ca0_1fbc` to it. InnoDB: Have you deleted the .frm file and not used DROP TABLE? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html InnoDB: If table `psa/itmpl_data` is a temporary table #sql..., then it can be that InnoDB: there are still queries running on the table, and it will be InnoDB: dropped automatically when the queries end. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another InnoDB: database and copying the .frm file to the current database. InnoDB: Then MySQL thinks the table exists, and DROP TABLE will InnoDB: succeed.