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

Upgrade Problem

Discussion in 'Plesk for Linux - 8.x and Older' started by SimonSchmitz, Mar 29, 2007.

  1. SimonSchmitz

    SimonSchmitz Guest

    0
     
    We have Big Problems


    ERROR while trying to execute SQL query, the query was: UPDATE Permissions SET permission='manage_virusfilter'
    WHERE permission='manage_drweb'

    Aborting...
     
  2. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    It seems this issue related to psa.Permissions table and 'manage_drweb' parameter which during upgrade should be replaced with 'manage_virusfilter'. Could you check 'Permissions' table. Fro example, give me output for:

    mysql> desc Permissions;

    and

    mysql> select * from Permissions where permission='manage_drweb';

    Probably some values can't be updated or something like this.
     
  3. SimonSchmitz

    SimonSchmitz Guest

    0
     
    I found a double entry on Permissions Table.

    Problem is SOLVED
     
Loading...