Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsXMLXMLInstall  damaged exiting ModuleInstall damaged exiting Module
Previous
 
Next
New Post
2/9/2010 8:23 PM
 

Hi, I have developed a module called XMLdb based on a version of XML module from V2.0 of DNN.  When the Core XML/XSL module is install on DNN 3.3 or better, the Modules setting values for the XMLdb module is impacted. 

In the 03.03.00.SqlDataProvider file of the install exists the following SQL commands

UPDATE {databaseOwner}[{objectQualifier}ModuleSettings]
SET    SettingName = N'XML_XmlSourceUrl'
WHERE  SettingName = N'xmlsrc'

UPDATE {databaseOwner}[{objectQualifier}ModuleSettings]
SET    SettingName = N'XML_XslTrans'
WHERE  SettingName = N'xslsrc'

These commands rename all modulesettings records where the SettingName is ether xmlsrc or xslsrc regardless of the module's type.  So any XMLdb modules will also have the SettingName changed.

The correct for this is to add an additional where clause to the above commands as follows

UPDATE {databaseOwner}[{objectQualifier}ModuleSettings]
SET    SettingName = N'XML_XslTrans'
WHERE  SettingName = N'xslsrc'
AND ModuleID in (Select ModuleID
 from {databaseOwner}[{objectQualifier}Modules] M
 join {databaseOwner}[{objectQualifier}ModuleDefinitions] D on M.ModuleDefID = D.ModuleDefID
 where FriendlyName = 'XML/XSL')

This additional clause will ensure that only the XML/XSL modules are updated in the ModuleSettings

I will post this issue on the DotNetNuke Support WebSite.

If anyone encounters this problem with XMLdb, please contact me at XMLdb [at] Tressleworks {dot} ca. Also, I would like to thank Vinenc Masanas who orignially reported this issue to me

Hope this helps 
Paul.

 
New Post
3/20/2010 8:50 AM
 

Paul, thank you for reporting, fix will be included in XML4.3.5

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsXMLXMLInstall  damaged exiting ModuleInstall damaged exiting Module


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out