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
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 tabdoes 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!
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.
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
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...
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
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.
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: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!
Hi!
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.
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
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):
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...
Hi!
Okey - I need to look closer at this - its not a known bug atm.
// m
If you need any other information don't hesitate to ask ;)
is working on a reply...