Can not delete a domain / add a domain.

[IgorR]

I am having problems deleting/adding domains to my Plesk Panel

ERROR: PleskFatalException

Unable to create LogRotation object: LogRotation: unable to select: no such row in the table
0: common_func.php3:146
psaerror(string 'Unable to create LogRotation object: LogRotation: unable to select: no such row in the table')
1: log_rotation.php:30
require(string '/usr/local/psa/admin/htdocs/domains/logs/log_rotation.php')
2: plesk.php:51

I checked the database, and psa.log_rotation table exists, but is empty.

I am running Plesk 9.5.2

Any sugestions?

 

[IgorG]

Do you have the same structure of this table?

mysql> show create table log_rotation\G
*************************** 1. row ***************************
Table: log_rotation
Create Table: CREATE TABLE `log_rotation` (
`id` int(10) unsigned NOT NULL auto_increment,
`period_type` enum('by_time','by_size') NOT NULL default 'by_time',
`period` varchar(50) character set ascii collate ascii_bin default NULL,
`max_number_of_logfiles` bigint(20) unsigned default '0',
`compress_enable` enum('false','true') NOT NULL default 'false',
`email` varchar(255) character set utf8 default NULL,
`turned_on` enum('false','true') NOT NULL default 'false',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> desc log_rotation;
+------------------------+---------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+---------------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| period_type | enum('by_time','by_size') | NO | | by_time | |
| period | varchar(50) | YES | | NULL | |
| max_number_of_logfiles | bigint(20) unsigned | YES | | 0 | |
| compress_enable | enum('false','true') | NO | | false | |
| email | varchar(255) | YES | | NULL | |
| turned_on | enum('false','true') | NO | | false | |
+------------------------+---------------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

 

[IgorR]

This is what I have:

mysql> show create table log_rotation\G
*************************** 1. row ***************************
Table: log_rotation
Create Table: CREATE TABLE `log_rotation` (
`id` int(10) unsigned NOT NULL auto_increment,
`period_type` enum('by_time','by_size') NOT NULL default 'by_time',
`period` varchar(50) character set ascii collate ascii_bin default NULL,
`max_number_of_logfiles` bigint(20) unsigned default '0',
`compress_enable` enum('false','true') NOT NULL default 'false',
`email` varchar(255) character set utf8 default NULL,
`turned_on` enum('false','true') NOT NULL default 'false',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> desc log_rotation;
+------------------------+---------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+---------------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| period_type | enum('by_time','by_size') | NO | | by_time | |
| period | varchar(50) | YES | | NULL | |
| max_number_of_logfiles | bigint(20) unsigned | YES | | 0 | |
| compress_enable | enum('false','true') | NO | | false | |
| email | varchar(255) | YES | | NULL | |
| turned_on | enum('false','true') | NO | | false | |
+------------------------+---------------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

Looks right to me

--Igor

 

[IgorG]

Did you tried to remove it with

# /usr/local/psa/bin/domain -r domain.com

?

 

[IgorR]

This is what I get

/usr/local/psa/bin/domain -r flakymodels.com
ERROR: PleskFatalException
Unable to remove hosting: Unable to init LogRotation object:LogRotation: unable to select: no such row in the table

0: class.PhDomain.php:278
PhDomain->reset(integer '0', boolean true, boolean false)
1: class.BsDomain.php:330
BsDomain->reset(integer '0')
2: class.BsDomain.php:302
BsDomain->delete()
3: cuDomain.php:1751
cuDomain->cmdRemove(string 'flakymodels.com')
4: cuDomain.php:718
cuDomain->cuDomain()
5: domain.php:17
PHP Warning: Releasing semaphore 20 in request cleanup in Unknown on line 0

 

[IgorR]

Anyone got any other suggestions?

I see many references to this problem through this forum, but NONE have solutions. Has anyone ever got this problem solved?

 

[IgorG]

It looks like there is database inconsistency and it can be fixed only by support team with direct access to your server.