I am using .NetCore 3.1 and Angular AspnetZero project/
I was able to integrate hangfire partially, however when i click any link in Hangfire dashboard I get the below error "
An unhandled exception occurred while processing the request.
MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
from Set,
(select @rownum := 0) r
where `Key' at line 3
MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in ResultSet.cs, line 49
MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
from Set,
(select @rownum := 0) r
where `Key' at line 3
MySql.Data.MySqlClient.MySqlDataReader.ActivateResultSet() in MySqlDataReader.cs, line 116
Am i doing something wrong ?
4 Answer(s)
-
0
What is the hangfire mysql integration you use? Is it Hangfire.MySqlStorage?
Maybe your mysql version is too low.
-
0
Yes I am using Hangfire.MySqlStorage.
MySql version is 8.0>
-
0
MySql8.0 is not available
see https://github.com/arnoldasgudas/Hangfire.MySqlStorage/issues/48
-
0
This issue is closed because of no recent activity. Please create a new issue if you are still having this problem.
