[Bug]: "Error found!"

[DynamicDave]

Contact Details

No response

What happened?

A bug happened! I installed astroboard on Umbraco 13.5.2 and all I is "Error found!".

Umbraco

13

Version

1.0.3

What browsers are you seeing the problem on?

Chrome

Relevant log output

Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'LIMIT'.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at NPoco.Database.ExecuteScalarHelper(DbCommand cmd)
   at NPoco.Database.ExecuteScalar[T](String sql, CommandType commandType, Object[] args)
ClientConnectionId:692a3f85-c5a7-4396-bf60-99acab4e6455
Error Number:102,State:1,Class:15

Code of Conduct

• I agree to follow this project's Code of Conduct

[wpplumber]

I find that you're using an old version 1.0.3! I invite you to install the latest version 1.0.9.

Thank you for reporting this bug, @DynamicDave.

[DynamicDave]

Hi,
I am actually using 1.0.9.

[wpplumber]

Welcome,

Yes, can I know where you got the log error below?

Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'LIMIT'.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.ExecuteScalar() at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)
at NPoco.Database.ExecuteScalarHelper(DbCommand cmd)
at NPoco.Database.ExecuteScalar[T](String sql, CommandType commandType, Object[] args)
ClientConnectionId:692a3f85-c5a7-4396-bf60-99acab4e6455
Error Number:102,State:1,Class:15

Did you get any console log error on the browser?

[DynamicDave]

Hi Tarik,

I got this error from the default Umbraco log.

And the console errors I get are:

Dashboard.BZkuV08f.js:3877 GET https://*****.*****.local/umbraco/backoffice/api/astroboard/getactivecomputername 500 (Internal Server Error)

And:

Uncaught (in promise) Error: Element not found
    at Dashboard.BZkuV08f.js:792:403
    at new Promise (<anonymous>)
    at B.value (Dashboard.BZkuV08f.js:104:40401)
    at Dashboard.BZkuV08f.js:792:75947

[wpplumber]

Welcome Dave,

Thanks, I'll check that soon.

[wpplumber]

Which database provider is used in your installation? I'm using sqlite and it is working as below.

[DynamicDave]

Hi Tarik,

I'm using SQL server (2016) and IIS. But I also get the error on IIS Express. So I'm guessing that it has something to do with SQL server?

Do you want a copy of the project? It's just a test/demo project in with a starter kit in which I imported 60.000 fake members to test the performance. That's it.

Kind regards,
Dave

[wpplumber]

Welcome Dave,

Yes, that is better with a DB script.

Best intents

[DynamicDave]

I can give you a DB backup if you want. A script with 60.000 members will be quite long.
Is that allright?

[wpplumber]

Yes no problem, I'm working on Mac OS and Linux and I plan to test your project using Docker.

[wpplumber]

I can give you a DB backup if you want. A script with 60.000 members will be quite long.
Is that allright?

Any problem in providing the DB backup?

[DynamicDave]

Yes the files are too large to send in a comment.
I will place them somewhere online and e-mail you the location so you can download them.