SqlException: Incorrect syntax near 'OFFSET'.

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

unable to install the application...showing this error...
0
4 年 前
What is the version of your SQL server?  Offset and fetch syntax is supported by SQL Server's 2012 and onwards versions.
Feel free to contact me if you need any help/suggestions. I will be more than happy to assist you.
mail: [email protected]
0
4 年 前
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
www.Nop-Templates.com - the best place for nopCommerce themes and plugins

Follow us on
Facebook: http://www.facebook.com/NopTemplates
Blog: http://www.nop-templates.com/blog

www.Nop-Templates.com
nopCommerce Solution Partners
1
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.