Forum Discussion

Post Patron

4 years ago

Solved

DataSource.Error: MySQL: We cannot convert a value of type System.String to type System.Guid.

DataSource.Error: MySQL: We cannot convert a value of type System.String to type System.Guid. how to fix?

Kletzy
4 years ago
Digger this solved if for me = MySQL.Database("xxxxxxx", "xxxxxxx", [ReturnSingleDatabase=true, OldGuids=true])

Advocate III

4 years ago

Digger this solved if for me = MySQL.Database("xxxxxxx", "xxxxxxx", [ReturnSingleDatabase=true, OldGuids=true])

Frequent Visitor

2 years ago

Kletzy using OldGuids=true solved my problem, i have no more errors in my table.

Thank you!

Adding some information I have searched about what this means

OldGuids: A logical (true/false) that sets whether char(36) columns (if false) or binary(16) columns (if true) will be treated as GUIDs. The default value is false. Link Here