DNN Forums

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

Issue In Sql Scripts Exceution

You are not authorized to post a reply.

Growing Member

    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.


    Tarunjit Singh

    Growing Member

      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.

      Tarunjit Singh

      Senior Member

        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.  

        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