I am just wondering - is uSycn supposed to work correctly with MySQL database?
I get a simple error: mysql is complaining that 'UMBRACONODE' table doesn't exist when doing full import. The table is named 'umbracoNode' in database and on linux server it is case sensitive.
uSync 'should' work with mySQL, although i've never tested it.
As it's written uSync doesn't do anything directly with the DB - it only works via the Umbrao APIs, so if your getting an error it's somewhere inside of the API.
What version of umbraco are you running ? I've had a quick look through the Umbraco-CMS code, and can't spot an uppercase reference to the table.
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.
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.
Besides that, I am also getting this one, right after installation if there is some content in uSync folder (import on start is disabled) and umbraco site was not loaded before (renaming usync folder to something else, logging in and renaming it back helps)
Hello guys. I would like to share how I solved this. The problem is using a MySQL installed on linux. The lowercasetable_names setting is case-insensitive and windows is not. An alternative is to configure your MySQL. However it is not possible to do this in the hosting, generating these errors.
I discovered in the source code of umbraco that what makes the query Uppercase is this method in SqlParser.cs
This solution involves you downloading the source code corresponding to your version, changing and recompiling and updating the dlls in your installation
Compatibility with mysql db
Hi,
I am just wondering - is uSycn supposed to work correctly with MySQL database?
I get a simple error: mysql is complaining that 'UMBRACONODE' table doesn't exist when doing full import. The table is named 'umbracoNode' in database and on linux server it is case sensitive.
Hi
uSync 'should' work with mySQL, although i've never tested it.
As it's written uSync doesn't do anything directly with the DB - it only works via the Umbrao APIs, so if your getting an error it's somewhere inside of the API.
What version of umbraco are you running ? I've had a quick look through the Umbraco-CMS code, and can't spot an uppercase reference to the table.
https://github.com/umbraco/Umbraco-CMS/search?q=UMBRACONODE&type=Code&utf8=%E2%9C%93
but it may be more subtle that this
Kevin
Hi,
I am running 7.2 and my guess that it is some sort other issue in umbraco - I've got a similar error elsewhere too.
Anyway here is the stack trace for the one I mentioned before:
Server Error in '/' Application.
Table 'restaurantmatreshka_dk_db.UMBRACONODE' doesn't exist
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: Table 'restaurantmatreshka_dk_db.UMBRACONODE' doesn't exist
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:
Besides that, I am also getting this one, right after installation if there is some content in uSync folder (import on start is disabled) and umbraco site was not loaded before (renaming usync folder to something else, logging in and renaming it back helps)
Hello guys. I would like to share how I solved this. The problem is using a MySQL installed on linux. The lowercasetable_names setting is case-insensitive and windows is not. An alternative is to configure your MySQL. However it is not possible to do this in the hosting, generating these errors.
I discovered in the source code of umbraco that what makes the query Uppercase is this method in SqlParser.cs
Https://github.com/umbraco/Umbraco-CMS/blob/dev-v7/src/umbraco.datalayer/SqlParser.cs#L214
What I did was override the method UppercaseIdentifiers in the MySqlParser without ToUpper. It was strange the name of the method being for uppercase without doing this. But due to the urgency of the situation it was working. https://github.com/umbraco/Umbraco-CMS/blob/dev-v7/src/umbraco.datalayer/SqlHelpers/MySql/MySqlParser.cs
Another way would be to remove the call from the method on that line. Https://github.com/umbraco/Umbraco-CMS/blob/dev-v7/src/umbraco.datalayer/SqlHelpers/MySql/MySqlParser.cs#L37
But I did not measure the impact of it.
This solution involves you downloading the source code corresponding to your version, changing and recompiling and updating the dlls in your installation
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
is working on a reply...