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

Cannot change user details after upgrade to 10.x

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by Stefan Becker, Nov 30, 2011.

  1. Stefan Becker

    Stefan Becker Basic Pleskian

    22
     
    Joined:
    May 19, 2009
    Messages:
    69
    Likes Received:
    0
    Hi,

    i have found this KB, http://kb.parallels.com/en/112032 , for my problem. But i when i start the sql , mysql> select login,contactName,email from smb_users where email in (select email from smb_users group by email having count(email)>1);, i get this error:

    bash: Syntaxfehler beim unerwarteten Wort `('

    Should I start it normally via the bash??

    Best regards,

    Stefan
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,564
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Before running this SQL query you should login to Plesk database psa. You can do it with help of following KB article - http://kb.parallels.com/170
     
  3. Stefan Becker

    Stefan Becker Basic Pleskian

    22
     
    Joined:
    May 19, 2009
    Messages:
    69
    Likes Received:
    0
    Thank you, for the fast response!
     
Loading...