Msg 156, Level 15, State 1 / Incorrect syntax near the keyword 'COMPUTE'.

Your website might display the following error if you're using an MS SQL database:

Msg 156, Level 15, State 1, Line LineNumber
Incorrect syntax near the keyword 'COMPUTE'.

Solution

This issue is caused by using COMPUTE or COMPUTE BY.

To resolve this issue, use ROLLUP instead.

More info

This issue was caused by your account being upgraded to MS SQL 2012, which doesn't support COMPUTE and COMPUTE BY. You can find more information in HostingDude.com upgrading databases to MS SQL 2012.