Solved

Dotnetnuke 4.6.2 Un-installing sql script does not executes delete statements.

Posted on 2010-11-15
3
257 Views
Last Modified: 2012-06-21
Hi,

I am developing modules on dotnetnuke 4.6.2. Every thing is fine, but there is strange thing happening in un-installing module in un-installation SQL Script.

The script is only executing Drop statements not the Delete statements. The module uses existing tables which are shared among more then one module. Hence i cannot drop tables but required to delete any existing data in those tables. I had created delete script but this never executes when module is deleted (un-installed), but yes drop tables successfully executes.

Thanks in advance.

Pradip
0
Comment
Question by:pradipkkoli
  • 2
3 Comments
 
LVL 6

Expert Comment

by:ErikVB
Comment Utility
are your statements property seperated by GO statements?

did you check wether the delete statements execute propertly when you execute them manually? (through Host > SQL)

0
 

Author Comment

by:pradipkkoli
Comment Utility
Yes Go Statements are there in my queries.

Also when this queries are run from Host->SQL or directly in database query windows, in both case the statements are executed successfully.

Please help.

Thanks
Pradip
0
 
LVL 6

Accepted Solution

by:
ErikVB earned 500 total points
Comment Utility
i can't help you any further with this, as conflicting things seem to be going on. If the uninstall script fully executes through host > sql, but only partially through module uninstall, something weird must be going on with this specific installation. Did you test whether or not this behaviour also manifests itself on different (clean) installations, on newer dnn versions etc.

What you could do is to contact a DNN expert from the community and have him analyze your installation
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo‚Ķ
This video teaches users how to migrate an existing Wordpress website to a new domain.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now