Copied to clipboard

Flag this post as spam?

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


  • serhio 22 posts 82 karma points
    Jul 20, 2015 @ 14:50
    serhio
    0

    What to do if installed Newsletter Studio before installing the SQL update?

    What to do if installed Newsletter Studio before installing the SQL update?

    I installed the trial version of the newsletter studio on our umbraco (v 4.7.2).

    Initially, I didn't install the "SQL kit"... but then read that it needs to be installed... but now I can't uninstall the Newsletter Studio Package.... I press to uninstall and nothing happens...

    As i try it locally, I dropped the local site database and then imported a backup copy of it...

    Then I installed the "SQL kit" (added the "mysql.data.dll" to the same folder in that the "NewsLetterStudio.dll" is located...)

    Then I added the <bindingRedirect oldVersion="0.0.0.0-6.5.4.0" newVersion="6.5.4.0" /> to the web.config...

    After that I (re)installed the NewsLetterStudio package but when navigating to "/umbraco.aspx#newsletterstudio" page I have

    Server Error in '/' Application.

    Object reference not set to an instance of an object.

    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: System.NullReferenceException: Object reference not set to an instance of an object.

    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:

    [NullReferenceException: Object reference not set to an instance of an object.]
    NewsletterStudio.Infrastucture.Data.PetaPoco.Database.OpenSharedConnection() +19 NewsletterStudio.Infrastucture.Data.PetaPoco.

    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34248

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Jul 21, 2015 @ 13:38
    Markus Johansson
    1

    Hi!

    Are you running MySQL?

    Do you have any tables in the db starting with "ns"? Ie. nsNewsletters, ns_TrackingItems?

    If you have them, delete all these tables, delete all files in the /umbraco/newsletterstudio-folder and delete the config-file in /config/.

    After this you should be able to run the installer again.

  • serhio 22 posts 82 karma points
    Aug 04, 2015 @ 09:56
    serhio
    0

    Thanks.

    I found and deleted in my sql databse all tables starting with "ns". (Finally dropped the database and reimported from the production a fresh version of it)

    Then I deleted all files in the /umbraco/newsletterstudio-folder and delete the newsteter's config-file in /config/ directory...

    After that I get to the developer tools in the umbraco backoffice and installed the local package of the newsletter (newsletter-studio-1451.zip).

    The page was reloaded after the install and I had at the address umbraco/umbraco.aspx#newsletterstudio the following content:

    Server Error in '/' Application.

    Object reference not set to an instance of an object.

    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: System.NullReferenceException: Object reference not set to an instance of an object.

    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:

    [NullReferenceException: Object reference not set to an instance of an object.]
    NewsletterStudio.Infrastucture.Data.PetaPoco.Database.OpenSharedConnection() +19 NewsletterStudio.Infrastucture.Data.PetaPoco.

    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34248

    PS.
    I would like to add that unistalling the newsletter studio via the developper umbraco tab does not drop the "ns" tables from the database. I tried with a new version of the database, after reinstalling or removing by hand, does not, anyway, so I need always to drop tables manually...
    Nor it deletes the /config/newsletterStudio.config file, so I need to delete it by hand...

    PPS.

    I tried on another machine in same package versions this time doing things in the right order.... The same result!

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Aug 05, 2015 @ 12:09
    Markus Johansson
    0

    Hi!

    1. Thats right - we don't drop the tables as we're seen people uninstall during updates without thinking about that the database are dropped. Umbraco don't have any option to show dialogs etc. so "better safe than sorry" was our way to go with thing issue.

    2. When you say "the same result" do you mean that you've followed all the steps and getting the error that you posted last time? This:

    [NullReferenceException: Object reference not set to an instance of an object.] NewsletterStudio.Infrastucture.Data.PetaPoco.Database.OpenSharedConnection() +19

  • serhio 22 posts 82 karma points
    Aug 05, 2015 @ 12:49
    serhio
    0

    Yes. I obtained the same error OpenShareConnection after installing the SQL patch and then the package "Newsletter Studio Version: 1.4.5.1" (My umbraco version is 4.7.2):

    [NullReferenceException: Object reference not set to an instance of an object.]
    NewsletterStudio.Infrastucture.Data.PetaPoco.Database.OpenSharedConnection() +19
        NewsletterStudio.Infrastucture.Data.PetaPoco.<Query>d__8'1.MoveNext() +207
        System.Collections.Generic.List`1..ctor(IEnumerable'1 collection) +535
    

    I have 6(six) "ns_" tables in the DB, also the IHM with a new "tab" "Nesletter studio", but when I try to access any content of the newsletter "tab"'s treeView I have this OpenSharedConnection error...

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Aug 05, 2015 @ 13:16
    Markus Johansson
    0

    Hi!

    Okey - I need to look closer at this - its not a known bug atm.

    // m

  • serhio 22 posts 82 karma points
    Aug 06, 2015 @ 08:30
    serhio
    0

    If you need any other information don't hesitate to ask ;)

Please Sign in or register to post replies

Write your reply to:

Draft