DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
Prev
Next

Issue In Sql Scripts Exceution

Forums > Modules and Other Extensions
Sort:
You are not authorized to post a reply.





Tarunjit

Growing Member



Posts:49
Growing Member




11/1/2023 7: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”

      <package name="ThirdPOCForModule" type="Module" version="00.00.02">

    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



    Posts:49
    Growing Member




    11/2/2023 1: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

      Veteran Member



      Posts:1262
      Veteran Member




      11/2/2023 11:37 AM

        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.  

        Will Strohl

        Upendo Ventures Was my answer helpful to you? Please... Sponsor Us On GitHub ;)
        DNN experts since 2003 | We Build LOTS of DNN stuff...
        DNN-based E-Commerce w/ Hotcakes Commerce
        You are not authorized to post a reply.

        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