DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
  • Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Using DNN Platform Modules and Other Extensions

Issue In Sql Scripts Exceution

 2 Replies
 1 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Author
Messages
Tarunjit
Growing Member Send Private Message
Posts: 49
Growing Member
11/1/2023 8:52 AM

Hi All,

I have DNN 9.11.0 installed in my local. I have already deployed version “00.00.01” version on my DNN. All the sql scripts available in file “Providers > DataProviders > SqlDataProvider > 00.00.01.SqlDataProvider” have run successfully.

Now I have done following changes

  1. Changes in “Properties > AssemblyInfo.cs” file

              [assembly: AssemblyVersion("00.00.02.*")]

              [assembly: AssemblyFileVersion("00.00.02.*")]

  1. Changes in manifest file “ModuleName.dnn”

 

But I have noticed that sql scripts written in file “Providers > DataProviders > SqlDataProvider > 00.00.02.SqlDataProvider” are some how are not getting executed. How ever our module have been upgraded to version “0.0.2” in DNN.

Please let me know if I am missing anything.

Regards

Tarunjit Singh

Tarunjit
Growing Member Send Private Message
Posts: 49
Growing Member
11/2/2023 2:46 AM

Hi All,

In continuation to my previous comment i have today added scripts for file "00.00.02.SqlDataProvider" under (scripts > script type="install" section) in manifest file "ThirdPOCForModule.dnn" as i noticed that under following path C:\Websites\dnndev.me\DesktopModules\MVC\ThirdPOCForModule\Providers\DataProviders\SqlDataProvider there is no file with name "00.00.02.SqlDataProvider" exists but even after adding above mentioned section and repairing my module still no success.



Regards
Tarunjit Singh

Will Strohl
Senior Member Send Private Message
Posts: 1575
Senior Member
11/2/2023 12:37 PM

I'm afraid you need to spend some time taking a look at how the DNN manifest works.  That, along with the naming conventions you're working with all help to ensure that SQL runs.  Please note that it will only run on the first install/upgrade.  If you choose to reinstall the module again, the SQL script will not be executed over again, depending on how you're running it. 

DNN Manifest Documentation - Everything in the linked documentation is important to what you're trying to do, but especially the Script component.  

These Forums are dedicated to the discussion of DNN Platform.

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

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy. 
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. 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.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved