Error: Incorrect syntax near the keyword 'SELECT'. Incorrect syntax near ')'.

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
5 năm cách đây
Hi Andrei,
Do you think there will be any work around or fix for this ?

Thanks,
Varun
0
5 năm cách đây
We've "fixed" it by upgrading to a newer version of SQL Server.
Interested in the dedicated Premium support services provided by core developers? Please visit https://www.nopcommerce.com/nopcommerce-premium-support-services

Regards,
Andrei Mazulnitsyn
nopCommerce team
0
5 năm cách đây
a.m. wrote:
We've "fixed" it by upgrading to a newer version of SQL Server.


Can you specify the versions or the oldest one ?

Thank you
0
5 năm cách đây
We had SQL Server R2 with "UseRowNumberForPaging" enabled (EF doesn't work well with it). Now upgraded to the next version SQL Server 2012
Interested in the dedicated Premium support services provided by core developers? Please visit https://www.nopcommerce.com/nopcommerce-premium-support-services

Regards,
Andrei Mazulnitsyn
nopCommerce team
1
5 năm cách đây
I am getting similar error.

SQL: SQL Server 2016(13.05026)
Version: Nopcommerce 4.1
Host: A2 Host

https://www.nopcommerce.com/boards/t/57206/google-search-bot-error-systemdatasqlclientsqlexception-0x80131904-timeout-expired.aspx
ibrahim
0
5 năm cách đây
itamturk wrote:
I am getting similar error

it's absolutely another error. It's timeout
Interested in the dedicated Premium support services provided by core developers? Please visit https://www.nopcommerce.com/nopcommerce-premium-support-services

Regards,
Andrei Mazulnitsyn
nopCommerce team
0
5 năm cách đây
Thanks
What is the cause and the solution of this error?
ibrahim
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.