e-mail Notifications error

[AndyD.]

Hello,

i get the following error :

Fehler: Unable to create notification: Unable to create Note object: Note: unable to select: no such row in the table
and
Fehler: Benachrichtigung kann nicht aktualisiert werden: Unable to create Note object: Note: unable to select: no such row in the table

in tools&settings -> Email Notifications

i run plesk 12.00.18#7 and i have upgrade from 11.5.30

how can i fix this error

regards

Andy

 

[IgorG]

Looks like uncompleted successfully upgrade. Try to use bootstrapper repair procedure.

 

[AndyD.]

Hello,
this don't fix the Problem

Trying to find psa database... version is 012000018
Version is OK, no need to create psa database.

....

Trying to set psa database version to 012000018... done
===> Cumulative upgrade and repair of Plesk database (revertable stage) has been completed.
Database is up-to-date
===> Cumulative Plesk upgrade and repair (final stage) has been started.
Upgrade or repair for 'core' (stage 'post') is not required
===> Preparing Plesk upgrade (final stage).

regards

Andy

 

[IgorG]

Be sure that you have the same structure of Notifications table in Plesk database:

mysql> desc Notifications;
+---------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| status | varchar(1) | NO | | NULL | |
| send2admin | varchar(1) | NO | | NULL | |
| send2reseller | varchar(1) | NO | | NULL | |
| send2client | varchar(1) | NO | | NULL | |
| send2dlu | varchar(1) | NO | | NULL | |
| send2email | varchar(1) | NO | | NULL | |
| email | varchar(255) | NO | | NULL | |
| subj | varchar(255) | NO | | NULL | |
| note_id | int(10) unsigned | YES | MUL | NULL | |
+---------------+------------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

And Notes table:

mysql> desc Notes;
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| text | text | NO | | NULL | |
+-------+------------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)

 

[AndyD.]

Hello,

it's the same structure

mysql> desc Notifications;
+---------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| status | varchar(1) | NO | | NULL | |
| send2admin | varchar(1) | NO | | NULL | |
| send2reseller | varchar(1) | NO | | NULL | |
| send2client | varchar(1) | NO | | NULL | |
| send2dlu | varchar(1) | NO | | NULL | |
| send2email | varchar(1) | NO | | NULL | |
| email | varchar(255) | NO | | NULL | |
| subj | varchar(255) | NO | | NULL | |
| note_id | int(10) unsigned | YES | MUL | NULL | |
+---------------+------------------+------+-----+---------+----------------+
10 rows in set (0.01 sec)

mysql> desc Notes;
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| text | text | NO | | NULL | |
+-------+------------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)

 

[IgorG]

Ask help here - http://www.parallels.com/products/plesk/free-assistance/

 

[wurzelpete]

The contents of these tables had been filled with wrong input during upgrade for me, I had to replace them with the default values (though some events still fail to show up in the setup page of plesk, even though they are present in the database).

My answer to this was posted in another thread:
http://talk.plesk.com/threads/notifications.312627/