All pastes #419586 Raw Edit

Someone

public text v1 · immutable
·published 2007-04-01 13:21 UTC
rendered paste body
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)