I am getting this error when trying to use the mysqlstorage to set the global config.
“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
'(6) NOT NULL,
ExpireAt
datetime(6) DEFAULT NULL,
PRIMARY KEY (Id
),
’ at line 10”
Here is my OWIN file. I am yes using VB.net.
GlobalConfiguration.Configuration.UseStorage(New MySqlStorage("ConnectionString"))
app.UseHangfireDashboard()
app.UseHangfireServer()
Added notes:
The reason I am using Mysql is because I have a wordpress installation, and my own ASP.net app running.
any insight would be amazing. Im sure im doing something silly or missing something.
Thanks
rob