1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Problem with Notifications.

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by cpet, Dec 12, 2008.

  1. cpet

    cpet Guest

    0
     
    Hello,

    I have just upgraded to Plesk 9 and I am wanting to send all notification to my gmail account. But once I click the Notifications link "Home -> Notifications" I get these errors

    Error: Unable to create notification: Notification: unable to select: no such row in the table
    Error: Unable to create notification: Notification: unable to select: no such row in the table
    Error: Unable to create notification: Notification: unable to select: no such row in the table
    Error: Unable to create notification: Notification: unable to select: no such row in the table
    Error: Unable to create notification: Notification: unable to select: no such row in the table
    Error: Unable to create notification: Notification: unable to select: no such row in the table
    Error: Unable to create notification: Notification: unable to select: no such row in the table

    Trying to modify the Notifications will only allow me to change the first two, the rest get reset to the default. ANy help will be appreciated.
     
  2. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    Hi

    Did you find a solution please as this also happens on mine :(, its been in beta so long I am surprised this got through lol

    Thanks for any help, it is much appreciated.
    Terry
     
  3. cpet

    cpet Guest

    0
     
    Not my dedicated server provider or parallels have been helpfull with this. Plesk doesnt have any tools to reset the DB like with cpanel
     
  4. ElviCities

    ElviCities Guest

    0
     
  5. cpet

    cpet Guest

    0
     
    Champion, thank you !
     
  6. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    Hi

    Any chance you can export your working settings for the Notification mysql section as for some reason mine still wont work after creating the extra 10 rows :(

    Thanks, any help appreciated.
    Terry
     
  7. 105547111

    105547111 Silver Pleskian

    32
    30%
    Joined:
    Jul 13, 2006
    Messages:
    643
    Likes Received:
    2
    You should have now have 22 lines. Make sure they all have id 1 to 22 and note id 1 to 22. Just blank wont work follow the sequence there.
     
  8. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    Hi I did but I think I messed up 12 :( can you tell me what settings are for 12 please so I can reset that one

    Cheers
     
  9. 105547111

    105547111 Silver Pleskian

    32
    30%
    Joined:
    Jul 13, 2006
    Messages:
    643
    Likes Received:
    2
    Sure :) - Yes 12 is screwy was that way but it works...



    Full Texts id status send2admin send2client send2dlu send2email email subj note_id send2reseller

    Edit Delete 1 1 1 1 email@domain.com 1 0
    Edit Delete 2 1 1 1 email@domain.com 2 0
    Edit Delete 3 1 1 1 1 email@domain.com 3 0
    Edit Delete 4 1 1 1 email@domain.com 4 0
    Edit Delete 5 1 1 1 email@domain.com 5 0
    Edit Delete 6 1 1 1 1 email@domain.com 6 0
    Edit Delete 7 1 1 1 1 email@domain.com 7 0
    Edit Delete 8 1 1 1 1 email@domain.com 8 0
    Edit Delete 9 1 1 1 1 email@domain.com 9 0
    Edit Delete 10 1 1 1 1 email@domain.com 10 0
    Edit Delete 11 1 1 1 1 email@domain.com 11 0
    Edit Delete 12 1 0 12
    Edit Delete 13 1 1 email@domain.com 13 1
    Edit Delete 14 1 1 email@domain.com 14 1
    Edit Delete 15 1 1 email@domain.com 15 1
    Edit Delete 16 1 1 email@domain.com 16 1
    Edit Delete 17 1 1 0 1 email@domain.com 17 0
    Edit Delete 18 1 1 1 1 email@domain.com 19 0
    Edit Delete 19 1 1 0 1 email@domain.com 18 0
    Edit Delete 20 1 0 0 1 email@domain.com 20 1
    Edit Delete 21 1 1 0 1 email@domain.com 21 0
    Edit Delete 22 1 0 0 1 email@domain.com 22 1
     
  10. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    Can you tell me what the subj was for 12 please as I deleted it :( could you paste it here as then at least that subject is correct.

    Thanks
     
  11. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    Just tried this and still no luck, any chance you can export the notifications table using phpMyAdmin and then send me the sql dump as I can then add this which should work :(

    Thanks and sorry for so many requests
    Terry
     
  12. 105547111

    105547111 Silver Pleskian

    32
    30%
    Joined:
    Jul 13, 2006
    Messages:
    643
    Likes Received:
    2
    I found the table notes that this refers to:

    Edit Delete 1 A new client account has been created in Plesk.
    Cl...
    Edit Delete 2 A new domain has been created in Plesk.
    Domain nam...
    Edit Delete 3 Limit has been exceeded on domain '<domain_name>' ...
    Edit Delete 4 The validity period of the client account '<client...
    Edit Delete 5 The validity period of the client account '<client...
    Edit Delete 6 The validity period of the '<domain_name>' domain ...
    Edit Delete 7 The validity period of the '<domain_name>' domain ...
    Edit Delete 8 A new ticket with ID <ticket_id> has been submitte...
    Edit Delete 9 Ticket <ticket_id> has been commented by <reporter...
    Edit Delete 10 Ticket <ticket_id> has been closed by <reporter> f...
    Edit Delete 11 Ticket <ticket_id> has been reopened by <reporter>...
    Edit Delete 12 The Application Manager reports error: <error_name...
    Edit Delete 13 A new reseller account has been created in Plesk.
    ...
    Edit Delete 14 The validity period of reseller account '<reseller...
    Edit Delete 15 The validity period of reseller account '<reseller...
    Edit Delete 16 The '<reseller_contact_name>' account is approachi...
    Edit Delete 17 The '<client_contact_name>' account is approaching...
    Edit Delete 18 The following resource limits were exceeded by cli...
    Edit Delete 19 The following resource limits were exceeded on dom...
    Edit Delete 20 The following resource limits were exceeded by res...
    Edit Delete 21 User account under client '<client_contact_name>' ...
    Edit Delete 22 User account under reseller '<reseller_contact_nam...


    So from this parallels messed up! Look at entry 12:

    The Application Manager reports error: <error_name...

    Now in notifications there are only 21 shown but database has 22. They forgot to put in the notification about applications errors!

    Here are 11 and 12 out of Notifications:

    Edit Delete 11 1 1 1 1 email@address 11 0
    Edit Delete 12 1 0 12

    12 - send to admin 1, send to client 0, rest are empty except note id which is 12

    That is why I said add 10, dont go deleting what looks like errors :(
     
  13. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    Oh yeah, it amazes me how they did this :( and if I call them they'd want $75.00 to fix it lmao.

    Do you have the full text entries so I can add them properly as you have ... at end of some :( sorry

    Thanks
    Terry

    PS: My MSN Messenger email is sales@my-software.co.uk if it is easier.
     
  14. 105547111

    105547111 Silver Pleskian

    32
    30%
    Joined:
    Jul 13, 2006
    Messages:
    643
    Likes Received:
    2
    12 - send2admin 1, send2client 0, rest are empty except note id which is 12

    I just paid 75 to get bloody spamassassin fixed. I noticed huge spam and in mailboxes you can see the spam, but its not being processed. Look at the headers on emails and no spam headers - great!
     
  15. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    Sorry I mean do you have the subj lines as some end with . . . and I cant see what to add. How do you get those subj strings, as I cant seem to find them :) in the mysql anywhere, did you just guess them

    Thanks
    Terry
     
  16. 105547111

    105547111 Silver Pleskian

    32
    30%
    Joined:
    Jul 13, 2006
    Messages:
    643
    Likes Received:
    2
    Yes that is the table Notes (the very one above)...

    Hey do you notice that if you sort stuff in plesk (say domains by expiration or 100 per page), after you log out and come back its back to default? Also I found watchdog statistics is always 24h in the graph and you cant get anhything else, this happen on yours?
     
  17. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    It sure does happen on mine and many others and other day parallels charged me $75 to fix a problem the installer did to my server :( its a joke as I pay enough monthly as it is.

    Surely they should fix these things straight away with a quick patch as they are bugging :(

    It should not have left beta yet, with these bugs

    Thanks
    Terry

    PS: Does your say there are updated to v9.0.0 when you have already installed all updates lol as mine does
     
  18. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    My notes table only has 15 entries? How many does yours have please?
     
  19. 105547111

    105547111 Silver Pleskian

    32
    30%
    Joined:
    Jul 13, 2006
    Messages:
    643
    Likes Received:
    2
    ah 22. Let me put them here for you.

    Ah the every going upgrade I found a fix :)

    Download the installer for your OS, run it on the server. Dont tick anything, just run as is. Afterwards you log in and presto up to date :)



    -- phpMyAdmin SQL Dump
    -- version 2.8.2.4
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost:3306
    -- Generation Time: Dec 13, 2008 at 09:28 AM
    -- Server version: 5.0.67
    -- PHP Version: 5.2.6
    --
    -- Database: `psa`
    --

    -- --------------------------------------------------------

    --
    -- Table structure for table `Notes`
    --

    CREATE TABLE `Notes` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `text` text character set utf8 NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

    --
    -- Dumping data for table `Notes`
    --

    INSERT INTO `Notes` (`id`, `text`) VALUES (1, 'A new client account has been created in Plesk.\nClient''s contact name: <client_contact_name>\nClient''s login: <client_login>\nClient''s password: <password>\nPlesk entry point: https://<hostname>:8443'),
    (2, 'A new domain has been created in Plesk.\nDomain name: <domain>\nClient owner: <client_contact_name>\nDomain IP: <ip>'),
    (3, 'Limit has been exceeded on domain ''<domain_name>'' owned by client ''<client_login>'' (Contact name ''<client_contact_name>''):\nDisk space usage: <disk_usage>\nDisk space limit: <disk_space_limit>\nTraffic: <traffic>\nTraffic limit: <traffic_limit>\n'),
    (4, 'The validity period of the client account ''<client_login>'' (Contact Name ''<client_contact_name>'') has expired.\nThe client account and all related domains were deactivated on <expiration_date>.'),
    (5, 'The validity period of the client account ''<client_login>'' (Contact Name ''<client_contact_name>'') is about to expire.\nThe client account and all of related domains will be deactivated by <expiration_date> unless the validity period is prolonged.'),
    (6, 'The validity period of the ''<domain_name>'' domain owned by client ''<client_login>'' (Contact name ''<client_contact_name>'') has expired.\nThe domain and all of its services were deactivated on <expiration_date>.'),
    (7, 'The validity period of the ''<domain_name>'' domain owned by client ''<client_login>'' (Contact name ''<client_contact_name>'') is about to expire.\nThe domain and all of its services will be deactivated by <expiration_date> unless the validity period is prolonged.'),
    (8, 'A new ticket with ID <ticket_id> has been submitted to the Help Desk by <reporter> from <server>.\nPlease retain the ticket identification number for future references. Below is a copy of the ticket.\n-----\n<ticket_comment>\n-----'),
    (9, 'Ticket <ticket_id> has been commented by <reporter> from <server>.\nBelow is the comment.\n-----\n<ticket_comment>\n-----'),
    (10, 'Ticket <ticket_id> has been closed by <reporter> from <server>.\nBelow is the comment.\n-----\n<ticket_comment>\n-----'),
    (11, 'Ticket <ticket_id> has been reopened by <reporter> from <server>.\nBelow is the comment.\n-----\n<ticket_comment>\n-----'),
    (12, 'The Application Manager reports error: <error_name>.\nBelow is details of the error:\n-----\n<error_details>\n-----'),
    (13, 'A new reseller account has been created in Plesk.\nReseller''s contact name: <reseller_contact_name>\nReseller''s login: <reseller_login>\nReseller''s password: <password>\nPlesk entry point: https://<hostname>:8443'),
    (14, 'The validity period of reseller account ''<reseller_login>'' (Contact Name ''<reseller_contact_name>'') has expired.\nThe reseller account and all related client accounts and domains were deactivated on <reseller_expiration_date>.'),
    (15, 'The validity period of reseller account ''<reseller_login>'' (Contact Name ''<reseller_contact_name>'') is about to expire.\nThe reseller account and all of related client accounts and domains will be deactivated by <reseller_expiration_date> unless the validity period is prolonged.'),
    (16, 'The ''<reseller_contact_name>'' account is approaching or already exceeded the limits:\n<resource_table>\n'),
    (17, 'The ''<client_contact_name>'' account is approaching or already exceeded the limits:\n<resource_table>\n'),
    (18, 'The following resource limits were exceeded by client <client_contact_name>:\n<resource_table>\nThe client account was suspended.\n'),
    (19, 'The following resource limits were exceeded on domain ''<domain_name>'', owned by user account ''<user_contact_name>'':\n<resource_table>\nThe domain was suspended.\n'),
    (20, 'The following resource limits were exceeded by reseller ''<reseller_contact_name>''):\n<resource_table>\nThe reseller account was suspended.\n'),
    (21, 'User account under client ''<client_contact_name>'' tried to use more ''<limit_name>'' resource than can be provided by the client account. The operation that tried to use more resources was blocked.\n'),
    (22, 'User account under reseller ''<reseller_contact_name>'' tried to use more ''<limit_name>'' resource than can be provided by the reseller account. The operation that tried to use more resources was blocked.\n');
     
  20. TerryM

    TerryM Regular Pleskian

    25
     
    Joined:
    Dec 12, 2008
    Messages:
    103
    Likes Received:
    0
    perfect for the notes table could you do same for notifications table :)

    please

    Also you say run installer I have fedoracore 6 x64 do you know which one and where I can get, thanks, linux command prompt would be great also.

    Again, thanks
     
Loading...