I just installed Umbraco 7.0.4 via NuGet in Visual Studio 2012 and I set it up to use a MySQL 5.6.13 database. No problem installing and the site runs in IIS Express and I can log in to the admin interface. But when I try to do something like add a document template or a user or anything related to clicking "+ Create" I get an error message saying that the SQL syntax is wrong. Is this a common problem?
This is the error message I get:
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 '[user] = 0' at line 1
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: MySql.Data.MySqlClient.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 '[user] = 0' at line 1
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[MySqlException (0x80004005): 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 '[user] = 0' at line 1]
Possible MySQL syntax bug?
I just installed Umbraco 7.0.4 via NuGet in Visual Studio 2012 and I set it up to use a MySQL 5.6.13 database. No problem installing and the site runs in IIS Express and I can log in to the admin interface. But when I try to do something like add a document template or a user or anything related to clicking "+ Create" I get an error message saying that the SQL syntax is wrong. Is this a common problem?
This is the error message I get:
Just found out it actually is a bug that is fixed in 7.1.
is working on a reply...