error trying to create subscriptions

[moop]

I am completely new to this and really thick apparently.

While slowly working thro the documentation for Plesk o my shiny new virtual server with easyspace, it mentions that I have to set up my own subscription first.

I tried this and it gave me the following error

Error: Unable to load object of type Notification with id=1: Notification: unable to select: no such row in the table

Same thing happened trying to set up a trial customer account too.

My hosts have provided Plesk 10.1.1 on a Linux/Ubuntu server

Now if anyone could talk to me in a pleasant but simplistic manner (imagine explaining it to your granny) on how I can rectify the problem I'd be grateful. I'd also knit you a thank you note but reckon my fingers may be bleeding by the end of the night with the constant nibbling.

Thank you in advance.

 

[IgorG]

It looks like that psa database was not completely upgraded. Check that Notifications table has following structure:

mysql> show create table Notifications\G
*************************** 1. row ***************************
Table: Notifications
Create Table: CREATE TABLE `Notifications` (
`id` int(10) unsigned NOT NULL auto_increment,
`status` varchar(1) character set ascii collate ascii_bin NOT NULL,
`send2admin` varchar(1) character set ascii collate ascii_bin NOT NULL,
`send2reseller` varchar(1) character set ascii collate ascii_bin NOT NULL,
`send2client` varchar(1) character set ascii collate ascii_bin NOT NULL,
`send2dlu` varchar(1) character set ascii collate ascii_bin NOT NULL,
`send2email` varchar(1) character set ascii collate ascii_bin NOT NULL,
`email` varchar(255) character set utf8 NOT NULL,
`subj` varchar(255) character set utf8 NOT NULL,
`note_id` int(10) unsigned default NULL,
PRIMARY KEY (`id`),
KEY `note_id` (`note_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1

 

[Seolin]

I have the same problem and cannot add a subscription to a user (Plesk 10.1.1 on a Linux/Ubuntu 10.04 LTS) and the table looks this:

Notifications | CREATE TABLE `Notifications` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`status` varchar(1) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`send2admin` varchar(1) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`send2reseller` varchar(1) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`send2client` varchar(1) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`send2dlu` varchar(1) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`send2email` varchar(1) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`email` varchar(255) CHARACTER SET utf8 NOT NULL,
`subj` varchar(255) CHARACTER SET utf8 NOT NULL,
`note_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `note_id` (`note_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Dont know what is here going wrong. Can somebody help me?

 

[IgorG]

Try to complete upgrade with bootstraper repair as it is described in http://kb.odin.com/en/9266

 

[moop]

Thank you. In the end Plesk had to be completely reinstalled. No errors so far