Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Keld Graugaard 13 posts 34 karma points
    Jul 22, 2013 @ 11:29
    Keld Graugaard
    0

    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

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Jul 22, 2013 @ 14:36
    Markus Johansson
    0

    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 

  • Keld Graugaard 13 posts 34 karma points
    Jul 22, 2013 @ 15:29
    Keld Graugaard
    0

    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

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Jul 22, 2013 @ 17:44
    Markus Johansson
    0

    Okey...

    How does your /config/newsletterStudio.config look? There is a subscriptionProvider-section. Does it have any child elements?

  • Keld Graugaard 13 posts 34 karma points
    Jul 22, 2013 @ 20:12
    Keld Graugaard
    0

    Both subscriptionProvider and emailRenderingTasks were empty. Added section from other fresh install and it worked. So thanks for your help :)

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Jul 23, 2013 @ 11:32
    Markus Johansson
    0

    No problem Keld! =D

  • Keld Graugaard 13 posts 34 karma points
    Jul 25, 2013 @ 12:27
    Keld Graugaard
    0

    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.

  • Keld Graugaard 13 posts 34 karma points
    Jul 25, 2013 @ 13:59
    Keld Graugaard
    0

    And just tested on fresh install. Same issue, and newsletterStudio.config is blank with SMTP Server and subscriptionProvider +  emailRenderingTasks

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Jul 25, 2013 @ 15:53
    Markus Johansson
    0

    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

  • Keld Graugaard 13 posts 34 karma points
    Jul 25, 2013 @ 15:57
    Keld Graugaard
    0

    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.

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Jul 25, 2013 @ 16:02
    Markus Johansson
    0

    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?

  • Keld Graugaard 13 posts 34 karma points
    Jul 25, 2013 @ 16:06
    Keld Graugaard
    0

    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

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Jul 25, 2013 @ 17:30
    Markus Johansson
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft