Article ID: 1797, created on Apr 16, 2007, last review on May 10, 2014

  • Applies to:
  • Plesk 8.2 for Windows
  • Plesk 8.1 for Windows


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.


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


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

7000fbc03a7e92b93bc676a7c04a4ce6 b23c51a6195823476e308cc12db2be0e 85a92ca67f2200d36506862eaa6ed6b8 a914db3fdc7a53ddcfd1b2db8f5a1b9c c45acecf540ecd42a4bbfb242ce02b1d 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF