search

arnoldasgudas / Hangfire.MySqlStorage

MySql storage for Hangfire - fire-and-forget, delayed and recurring tasks runner
GNU Lesser General Public License v3.0
174 stars 114 forks source link

MySqlException: Parameter '@rownum' must be defined #89

Open PaulatElf opened 2 years ago

PaulatElf commented 2 years ago

I have this issue too but only on my live website, when running from Visual Studio (localhost) don't have any problems but when using Hangfire (1.8.0) Dashboard on the live published site I can access a few pages (/hangfire, /hangfire/servers, /hangfire/jobs) but for all the other pages (such as hangfire/recurring, hangfire/retries, hangfire/jobs/succeeded ect.) I always get that same message: 'MySqlException: Parameter '@rownum' must be defined. To use this as a variable, set 'Allow User Variables=true' in the connection string.'

Even though I already do have 'Allow User Variables=true' in the connection string.

If anyone has any ideas how to fix this it would be very helpful.

mtholen commented 2 years ago

Did you set the 'AllowUserVariables=true' correctly?

https://www.connectionstrings.com/mysql-connector-net-mysqlconnection/allow-user-variables/