I'm playing around with CMSImport as it looks like a great solution for an Umbraco site I'm working on. However, I'm having major issues when importing data into my Umbraco site. On import I receive the error message within Umbraco:
Error during load, check the logfile for details Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
And in my Umbraco log file there is a lot of "you have an error in your SQL syntax..." messages when creating the CMSImport tables, usually something along the lines of:
MySql.Data.MySqlClient.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 'ALTER TABLE DBO.CMSIMPORTSCHEDULEDTASK ADD IMPORTASUSER INT NULL' at line 1
I'm by no means an expert at SQL but this error looks like my MySQL version (5.1) is incompatible with CMSImport, does this sound like it's the cause of the issue to anyone? Does anyone know how I can fix these issues?
CMSImport is indeed not compatible with MySql. It's written fro SQL Server (Express). What you can do is take the create sql from the package file and see if it can be modified to work with MySql. But I don't know if you will run into issues during import.
Issues with importing data: Error during load
Hi Everyone,
I'm playing around with CMSImport as it looks like a great solution for an Umbraco site I'm working on. However, I'm having major issues when importing data into my Umbraco site. On import I receive the error message within Umbraco:
Error during load, check the logfile for details Umbraco Exception (DataLayer): SQL helper exception in ExecuteReaderAnd in my Umbraco log file there is a lot of "you have an error in your SQL syntax..." messages when creating the CMSImport tables, usually something along the lines of:
I'm by no means an expert at SQL but this error looks like my MySQL version (5.1) is incompatible with CMSImport, does this sound like it's the cause of the issue to anyone? Does anyone know how I can fix these issues?
Hi,
CMSImport is indeed not compatible with MySql. It's written fro SQL Server (Express). What you can do is take the create sql from the package file and see if it can be modified to work with MySql. But I don't know if you will run into issues during import.
Thanks,
Richard
Hi Richard,
Thanks for the heads-up; that's a shame as it looks like an awesome project! Thanks anyway!
Sorry, quick bump. Does anyone know if this would run on MS SQL as well as SQL Server Express? Can it run on both versions?
Hi,
Yes both SQL Server as SQL Server express is supported.
Cheers,
Richard
Is sql server express 2012 supported?
Yes should work as expected.
is working on a reply...