MySqlStorage Throwing Error

question
1

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

2

I have the same problem, but this happening when I’m trying to migrate to the production server. In developing this mysql worked.

Mysql Development: 5.7.10-log
Mysql Production: 5.5.22-log

I tried to create the tables manually but still with the error.

If you find the solution, please share.

Thank you

3

There is a issue with newer mysql versions. Format which is mysqlstorage using DATETIME(6) is not supported.

DATETIME without (6) is proper syntax.