SqlException: Incorrect syntax near 'OFFSET'.

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
4 years ago
hii..

unable to install the application...showing this error...
4 years ago
What is the version of your SQL server?  Offset and fetch syntax is supported by SQL Server's 2012 and onwards versions.
4 years ago
Hello,

If you are using nopCommerce 4.1 and higher you will either need to use SQL Server 2012 or edit the appsettings.json  file in the root directory of nopCommerce and set the UseRowNumberForPaging to true and then try to start your application.

Hope that helps!

Regards,
Anton
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.