Unknown error

[StayAllive]

Hey All,

I saw the following errors in my plesk logs and am very curious on what this could cause because I suspect it is related to a previous issue which is still not resolved.

Error:

ERR [panel] Specified column "isAllowed" is not in the row

Log file:

/usr/local/psa/admin/logs/panel.log

Plesk:

12.0.18 Update #25 CentOS 6.6 (Final)

Would be great to hear what this means and how to fix!

 

[IgorG]

It looks like that psa database was not completely upgraded. Try to fox it with bootstrapper repair procedure or add this field in smb_roleGeneralPermissions table manually if you familiar with SQL:

mysql> desc smb_roleGeneralPermissions;
+---------------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| roleId | int(11) | NO | MUL | NULL | |
| generalPermissionId | int(11) | NO | | NULL | |
| isAllowed | int(11) | YES | | NULL | |
+---------------------+---------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

 

[StayAllive]

Well I did that but the error persists.

The table smb_roleGeneralPermissions is identical to yours.

Any clue where to look further?

 

[IgorG]

Field isAllowed is defined only in this table.
I can only recommend to create a request to support team to do in-depth investigation to find the reason and to fix it. Please create a ticket to support at https://odin.com/hcap/support/request/ .
You may have free support, please check what kind of Plesk license you use for available support options at http://kb.odin.com/en/121580 .
If there’s no free support in your case, you can order Plesk per-incident support at http://odin.com/hcap/support/buy-support/. Support team will contact you as soon as purchase is processed, and they will do the best to resolve it.
If it is found that your problem was caused by product bug w/o available solution or workaround from Parallels, then your purchase will be re-funded.

 

[danliker]

we see the same on our servers, any news for this?

 

[Groell_Guillaume]

I have the same error and since yesterday 4 of my websites stopped working (showing the Plesk Default page). Any news ?