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 in Complete Switching to the Panel 10 Business Model

Discussion in 'Plesk 10.x for Windows Issues, Fixes, How-To' started by AliZ, Jan 23, 2011.

  1. AliZ

    AliZ Basic Pleskian

    17
    85%
    Joined:
    Jun 28, 2010
    Messages:
    33
    Likes Received:
    0
    Hello,

    I upgraded my plesk 9.5.2 on Windows 2003 X86 to Plesk 10.0.1

    Now, I'm going to Switch to the Panel 10 Business Model,

    [​IMG]




    but when i apply the transition, it retrieves an error:

    [​IMG]

    Also when I try to Apply the transition for each individual clint,
    [​IMG]




    The following error appears:

    [​IMG]




    Internal error: <b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Cannot insert the value NULL into column 'limits_id', table 'PSA10.dbo.clients'; column does not allow nulls. UPDATE fails.


    Message <b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Cannot insert the value NULL into column 'limits_id', table 'PSA10.dbo.clients'; column does not allow nulls. UPDATE fails.
    File common_func.php3
    Line 119
    Type com_exception
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,543
    Likes Received:
    1,239
    Location:
    Novosibirsk, Russia
    The cause of the issue in the following DB query:

    update [clients] set [limits_id]=NULL......

    The column limits_id in psa.clients table is defined as not nullable, so the update query failed. This issue is actual for MSSQL DB only. You can try to set this column nullable for fixing this problem.
    Contact support team if you can't do it by yourself.
     
Loading...