Product:
Search Type:

[FIX] Switching of Plesk database provider from MySQL to MSSQL fails

Article ID: 1797 
Last Review: Jul,17 2007
APPLIES TO:
  • Plesk 8.1.0 for Windows
  • Plesk 8.1.1 for Windows
  • Plesk 8.1 for Windows
  • Plesk 8.1.1.2 for Windows
  • Plesk 8.2 for Windows

SYMPTOMS

When attempting to switch Plesk database provider from MySQL to MSSQL, the process fails and the following error message is displayed:

Error converting data type nvarchar to bigint.

CAUSE

The issue can occur because of incorrect records in the “limits” table.

RESOLUTION

Remove the incorrect records from the “limits” table using the following query:
delete from limits where concat( '', value + 0 ) != value;

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields