CoderJim Posted September 24, 2021 Share Posted September 24, 2021 This error pops up on open... at a loss Coder Jim Quote Link to comment Share on other sites More sharing options...
bsmither Posted September 24, 2021 Share Posted September 24, 2021 You will not be able to fix this from CubeCart. Using a third-party database manager, or phpMyAdmin from your hosting account's control panel, have the utility scan and repair as necessary this database. Quote Link to comment Share on other sites More sharing options...
CoderJim Posted September 24, 2021 Author Share Posted September 24, 2021 Thanks for the tip, forgot what to do. Running now. Quote Link to comment Share on other sites More sharing options...
Weldon451 Posted May 14 Share Posted May 14 Anyone got a thought? Quote Link to comment Share on other sites More sharing options...
Amber098 Posted June 22 Share Posted June 22 (edited) On 5/14/2022 at 2:33 PM, Weldon451 said: Anyone got a thought? MyCCPay This issue occurs because SQL Server limits the number of identifiers and constants that can be contained in a single expression of a query. The limit is 65,535. The test for the number of identifiers and constants is performed after SQL Server expands all referenced identifiers and constants. In SQL Server 2005 and above, queries are internally normalized and simplified. And that includes *(asterisk), computed columns etc. In order to work around this issue, rewrite your query. Reference fewer identifiers and constants in the largest expression in the query. You must make sure that the number of identifiers and constants in each expression of the query does not exceed the limit. To do this, you may have to break down a query into more than one single query. Then, create a temporary intermediate result. Edited June 23 by Amber098 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.