Unable to create mailbox: Specified column "endDate" is not in the row

Created:

2016-11-16 12:53:29 UTC

Modified:

2017-08-08 13:32:30 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create mailbox: Specified column "endDate" is not in the row

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

Unable to create new mailbox. The following error is shown:

    Internal error: Specified column "endDate" is not in the row
Message Specified column "endDate" is not in the row
File Abstract.php
Line 179
Type Zend_Db_Table_Row_Exception

Another error can be found in /usr/local/psa/admin/logs/panel.log :

    Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'endDate' in 'where clause'
file: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php
line: 30
code: 0
trace: #0 /usr/local/psa/admin/externals/Zend/Db/Table/Abstract.php(1534): Db_Adapter_Pdo_Mysql->query(object of type Zend_Db_Table_Select)
#1 /usr/local/psa/admin/externals/Zend/Db/Table/Abstract.php(1349): Zend_Db_Table_Abstract->_fetch(object of type Zend_Db_Table_Select)
#2 /usr/local/psa/admin/plib/DailyMaintainance/Task/AutoresponderEndDate.php(17): Zend_Db_Table_Abstract->fetchAll(object of type Zend_Db_Table_Select)
#3 /usr/local/psa/admin/plib/DailyMaintainance/Runner/Task.php(26): DailyMaintainance_Task_AutoresponderEndDate->run(array)
#4 /usr/local/psa/admin/plib/DailyMaintainance/task-script.php(14): DailyMaintainance_Runner_Task->run()

[2016-02-10 03:45:15] ERR [panel] Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'endDate' in 'where clause`

In /var/log/plesk/install/plesk_12.5.30_installation.log similar error may be found errors:

    ===> Preparing Plesk database upgrade (revertable stage).
ERROR 3 (HY000) at line 1: Error writing file './psa/#sql-1b6d_36f275.frm' (Errcode: 28)

# perror 28
OS error code 28: No space left on device

Cause

psa database was not properly modified during Plesk upgrade due to the lack of disk space.

Resolution

  1. Make sure it is enough disk space.

  2. Fix psa database issues running:

    # plesk repair db
Have more questions? Submit a request
Please sign in to leave a comment.