Yep...a clean install of Newsletterstudio. Umbraco is a couple of years old, and recently being updated.
The issue is the same on test and production server. Everything works fine except in sendout. I've created 2 mailinglist, and can add and delete recipients. But can't choose wich one to use.
It looks like there is an issue with the MySQL-version that you are running. We support MySQL using the entity frameworks provider. If you are on a very new version of mysql this may mean that the providers is old.
What version of mysql are you running? Did you download and read the mysql kit on the our-page? There are some special actions that you need to take in order for this to work.
Okey - I guess that there is something wrong with the provider. We have been testing on older versions of mysql. I'm sorry but since 99% of the users are running MS SQL Server - thats where the focus will be but.
Maillist not available in sendout section
I got the following issue on a system running with MySQL as DB. All tables are available and data is present.
Newsletterstudio is version 1.3.5
Hi!
Hmm, a clean install?
Did you change anything in the configuration files? Is there any mailing list added? Any errors in the log files?
// m
Yep...a clean install of Newsletterstudio. Umbraco is a couple of years old, and recently being updated.
The issue is the same on test and production server. Everything works fine except in sendout. I've created 2 mailinglist, and can add and delete recipients. But can't choose wich one to use.
BTW. Umbraco is 4.11.8 and nothing in logfiles
Okey...
How does your /config/newsletterStudio.config look? There is a subscriptionProvider-section. Does it have any child elements?
Both subscriptionProvider and emailRenderingTasks were empty. Added section from other fresh install and it worked. So thanks for your help :)
No problem Keld! =D
But now on sendout an error occur:
'NewsletterStudio, SendNewsletterService: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery : MySql.Data.MySqlClient.MySqlException (0x80004005): Table ''_db.NS_EMAILTRACKINGITEMS'' doesn''t exist
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters)
at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms)
at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)'
And the table is present.
And just tested on fresh install. Same issue, and newsletterStudio.config is blank with SMTP Server and subscriptionProvider + emailRenderingTasks
Hi!
It looks like there is an issue with the MySQL-version that you are running. We support MySQL using the entity frameworks provider. If you are on a very new version of mysql this may mean that the providers is old.
What version of mysql are you running? Did you download and read the mysql kit on the our-page? There are some special actions that you need to take in order for this to work.
// m
MySQL version 5.1.61 on Unix
Dll files replaced as instructed in MySQL kit 1.3.
No problem in creating Newsletter, adding subscribers from backend.
Hmm looks like that error comes from the umbraco sql helper... what version of Umbraco are you on? And the table _db.NS_EMAILTRACKINGITEMS exsists?
any more information in the logs?
Tested on version 4.11.8 and a fresh install on 4.11.10.
The table exist but NS_EMAILTRACKINGITEMS is in lowercase wich rest off the Umbraco tables is in Uppercase. Tried a uppercase rename with no succes
Hi!
Okey - I guess that there is something wrong with the provider. We have been testing on older versions of mysql. I'm sorry but since 99% of the users are running MS SQL Server - thats where the focus will be but.
/ m
is working on a reply...