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

HomeHomeDevelopment and...Development and...Building ExtensionsBuilding ExtensionsModulesModulesSQL Error when installingSQL Error when installing
Previous
 
Next
New Post
1/24/2010 10:13 AM
 

Hi,

one of my users has reported this in version 04.09.04, but I was not able to reproduce until today (using version 05.02.01 and 05.02.02). When the install script runs, the following error appears:

StartJob Starting Installation
Info Starting Installation - helferlein Form
Info Starting Installation - Script
Info Begin Sql execution
Info Folder Created - D:\WebSites\Cambrian\DesktopModules\helferlein_Form\Providers\DataProviders\SqlDataProvider
Info Created - Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider
Info Executing 01.00.00.SqlDataProvider
Info Start Sql execution: 01.00.00.SqlDataProvider file
Info End Sql execution: 01.00.00.SqlDataProvider file
Info Created - Providers\DataProviders\SqlDataProvider\01.01.00.SqlDataProvider
Info Executing 01.01.00.SqlDataProvider
Info Start Sql execution: 01.01.00.SqlDataProvider file
Info End Sql execution: 01.01.00.SqlDataProvider file
Info Created - Providers\DataProviders\SqlDataProvider\01.02.00.SqlDataProvider
Info Executing 01.02.00.SqlDataProvider
Info Start Sql execution: 01.02.00.SqlDataProvider file
Info End Sql execution: 01.02.00.SqlDataProvider file
Info Created - Providers\DataProviders\SqlDataProvider\01.04.00.SqlDataProvider
Info Executing 01.04.00.SqlDataProvider
Info Start Sql execution: 01.04.00.SqlDataProvider file
Info End Sql execution: 01.04.00.SqlDataProvider file
Info Created - Providers\DataProviders\SqlDataProvider\01.04.01.SqlDataProvider
Info Executing 01.04.01.SqlDataProvider
Info Start Sql execution: 01.04.01.SqlDataProvider file
Info End Sql execution: 01.04.01.SqlDataProvider file
Info Created - Providers\DataProviders\SqlDataProvider\01.04.02.SqlDataProvider
Info Executing 01.04.02.SqlDataProvider
Info Start Sql execution: 01.04.02.SqlDataProvider file
Info End Sql execution: 01.04.02.SqlDataProvider file
Info Created - Providers\DataProviders\SqlDataProvider\01.05.00.SqlDataProvider
Info Executing 01.05.00.SqlDataProvider
Info Start Sql execution: 01.05.00.SqlDataProvider file
Info End Sql execution: 01.05.00.SqlDataProvider file
Info Created - Providers\DataProviders\SqlDataProvider\02.00.00.SqlDataProvider
Info Executing 02.00.00.SqlDataProvider
Info Start Sql execution: 02.00.00.SqlDataProvider file
Info End Sql execution: 02.00.00.SqlDataProvider file
Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\02.00.00.SqlDataProvider
Info Created - Providers\DataProviders\SqlDataProvider\02.00.00.SqlDataProvider
Info Executing 02.00.00.SqlDataProvider
Info Start Sql execution: 02.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Der @objname-Parameter ist mehrdeutig, oder der beanspruchte Wert von '@objtype' (COLUMN) ist falsch. (etc...)

Looking closer at it, after ecexuting the 02.00.00.SqlDataProvider script for the first time, it says "Creating backup of previous version...", and then starts the same script again - which leads into the error.

Can someone explain what's going on here? Why is the script executed twice?

Best wishes
Michael


Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
1/28/2010 1:57 PM
 

No one any idea? Really?

Michael


Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
2/1/2010 2:30 PM
 

I cannot believe it... no ideas about this around here? More information needed?

Here is the manifest file:

<dotnetnuke type="Package" version="5.0">
   <packages>
      <package name="helferlein Form" type="Module" version="2.0.2">
         <friendlyName>helferlein Form</friendlyName>
         <description>Create simple forms and optionally display transmissions.</description>
         <owner>
            <name>Michael Tobisch</name>
            <organization>helferlein.com</organization>
            <url>http://www.helferlein.com</url>
            <email>noreply@helferlein.com</email>
         </owner>
         <license>
            <![CDATA[
            <p>
            helferlein.com ( <a href="http://www.helferlein.com" target="_blank">www.helferlein.com</a> )<br />
            &copy; Michael Tobisch 2007 - 2011<br />
            </p><p>
            Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
            documentation files (the "Software"), to deal in the Software without restriction, including without limitation
            the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and
            to permit persons to whom the Software is furnished to do so, subject to the following conditions:
            </p><p>
            The above copyright notice and this permission notice shall be included in all copies or substantial portions
            of the Software.
            </p><p>
            THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED
            TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
            THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF
            CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
            DEALINGS IN THE SOFTWARE.
            </p>
            ]]>
         </license>
         <releaseNotes>
            <![CDATA[
            For detailed history information see <a href="http://www.helferlein.com/helferlein_FormHelp/tabid/224/TID/1/cid/1/Default.aspx" target="_blank">helferlein.com - Help</a>.
            ]]>
         </releaseNotes>
         <dependencies>
            <dependency type="Type">helferlein.DNN.Modules.BabelFish.Business.BabelFishController</dependency>
         </dependencies>
         <components>
            <component type="Script">
               <scripts>
                  <basePath>DesktopModules\helferlein_Form</basePath>
                  <script type="Install">
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.00.00.SqlDataProvider</name>
                     <version>01.00.00</version>
                  </script>
                  <script type="Install">
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.01.00.SqlDataProvider</name>
                     <version>01.01.00</version>
                  </script>
                  <script type="Install">
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.02.00.SqlDataProvider</name>
                     <version>01.02.00</version>
                  </script>
                  <script type="Install">
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.04.00.SqlDataProvider</name>
                     <version>01.04.00</version>
                  </script>
                  <script type="Install">
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.04.01.SqlDataProvider</name>
                     <version>01.04.01</version>
                  </script>
                  <script type="Install">
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>02.00.00.SqlDataProvider</name>
                     <version>02.00.00</version>
                  </script>
                  <script type="Install">
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>02.00.00.SqlDataProvider</name>
                     <version>02.00.02</version>
                  </script>
                  <script type="UnInstall">
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>Uninstall.SqlDataProvider</name>
                     <version>02.00.02</version>
                  </script>
               </scripts>
            </component>
            <component type="Module">
               <desktopModule>
                  <moduleName>helferlein Form</moduleName>
                  <foldername>helferlein_Form</foldername>
                  <businessControllerClass>helferlein.DNN.Modules.Form.Business.FormSubmissionController</businessControllerClass>
                  <supportedFeatures>
                     <supportedFeature type="Portable" />
                     <supportedFeature type="Searchable" />
                     <supportedFeature type="Upgradeable" />
                  </supportedFeatures>
                  <moduleDefinitions>
                     <moduleDefinition>
                        <friendlyName>helferlein Form</friendlyName>
                        <defaultCacheTime>0</defaultCacheTime>
                        <moduleControls>
                           <moduleControl>
                              <controlKey />
                              <controlSrc>DesktopModules/helferlein_Form/Form.ascx</controlSrc>
                              <supportsPartialRendering>True</supportsPartialRendering>
                              <controlTitle />
                              <controlType>View</controlType>
                              <iconFile />
                              <helpUrl>http://www.helferlein.com/DotNetNuke/helferlein_FormHelp/tabid/224/TID/6/cid/1/Default.aspx</helpUrl>
                              <viewOrder>0</viewOrder>
                           </moduleControl>
                           <moduleControl>
                              <controlKey>Edit</controlKey>
                              <controlSrc>DesktopModules/helferlein_Form/FormEdit.ascx</controlSrc>
                              <supportsPartialRendering>True</supportsPartialRendering>
                              <controlTitle>Edit form</controlTitle>
                              <controlType>Edit</controlType>
                              <iconFile />
                              <helpUrl>http://www.helferlein.com/DotNetNuke/helferlein_FormHelp/tabid/224/TID/4/cid/1/Default.aspx</helpUrl>
                              <viewOrder>0</viewOrder>
                           </moduleControl>
                           <moduleControl>
                              <controlKey>EditSubmissions</controlKey>
                              <controlSrc>DesktopModules/helferlein_Form/FormSubmissionsEdit.ascx</controlSrc>
                              <supportsPartialRendering>True</supportsPartialRendering>
                              <controlTitle>Edit form submissions</controlTitle>
                              <controlType>Edit</controlType>
                              <iconFile />
                              <helpUrl>http://www.helferlein.com/DotNetNuke/helferlein_FormHelp/tabid/224/TID/5/cid/1/Default.aspx</helpUrl>
                              <viewOrder>0</viewOrder>
                           </moduleControl>
                           <moduleControl>
                              <controlKey>Settings</controlKey>
                              <controlSrc>DesktopModules/helferlein_Form/Settings.ascx</controlSrc>
                              <supportsPartialRendering>True</supportsPartialRendering>
                              <controlTitle>Form Settings</controlTitle>
                              <controlType>Edit</controlType>
                              <iconFile />
                              <helpUrl>http://www.helferlein.com/DotNetNuke/helferlein_FormHelp/tabid/224/TID/3/cid/1/Default.aspx</helpUrl>
                              <viewOrder>0</viewOrder>
                           </moduleControl>
                        </moduleControls>
                     </moduleDefinition>
                  </moduleDefinitions>
               </desktopModule>
               <eventMessage>
                  <processorType>DotNetNuke.Entities.Modules.EventMessageProcessor, DotNetNuke</processorType>
                  <processorCommand>UpgradeModule</processorCommand>
                  <attributes>
                     <businessControllerClass>helferlein.DNN.Modules.Form.Business.FormSubmissionController</businessControllerClass>
                     <desktopModuleID>[DESKTOPMODULEID]</desktopModuleID>
                     <upgradeVersionsList>01.00.00,01.01.00,01.02.00,01.04.00,01.04.01,02.00.00,02.00.02</upgradeVersionsList>
                  </attributes>
               </eventMessage>
            </component>
            <component type="File">
               <files>
                  <basePath>DesktopModules\helferlein_Form</basePath>
                  <file>
                     <path>App_LocalResources</path>
                     <name>Form.ascx.resx</name>
                  </file>
                  <file>
                     <path>App_LocalResources</path>
                     <name>FormEdit.ascx.resx</name>
                  </file>
                  <file>
                     <path>App_LocalResources</path>
                     <name>FormSubmissionsEdit.ascx.resx</name>
                  </file>
                  <file>
                     <path>App_LocalResources</path>
                     <name>Settings.ascx.resx</name>
                  </file>
                  <file>
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.00.00.SqlDataProvider</name>
                  </file>
                  <file>
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.01.00.SqlDataProvider</name>
                  </file>
                  <file>
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.02.00.SqlDataProvider</name>
                  </file>
                  <file>
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.04.00.SqlDataProvider</name>
                  </file>
                  <file>
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>01.04.01.SqlDataProvider</name>
                  </file>
                  <file>
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>02.00.00.SqlDataProvider</name>
                  </file>
                  <file>
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>02.00.02.SqlDataProvider</name>
                  </file>
                  <file>
                     <path>Providers\DataProviders\SqlDataProvider</path>
                     <name>Uninstall.SqlDataProvider</name>
                  </file>
                  <file>
                     <path>Themes\Default</path>
                     <name>Default.css</name>
                  </file>
                  <file>
                     <path>Themes\DNN_Feedback</path>
                     <name>DNN_Feedback.css</name>
                  </file>
                  <file>
                     <path>Themes\Fancy</path>
                     <name>Fancy.css</name>
                  </file>
                  <file>
                     <name>01.04.02.txt</name>
                  </file>
                  <file>
                     <name>01.05.00.txt</name>
                  </file>
                  <file>
                     <name>Form.ascx</name>
                  </file>
                  <file>
                     <name>FormEdit.ascx</name>
                  </file>
                  <file>
                     <name>FormSubmissionsEdit.ascx</name>
                  </file>
                  <file>
                     <name>helferlein_Form.dnn</name>
                  </file>
                  <file>
                     <name>Mail.css</name>
                  </file>
                  <file>
                     <name>Settings.ascx</name>
                  </file>
               </files>
            </component>
            <component type="Assembly">
               <basePath>bin</basePath>
               <assembly>
                  <name>helferlein_Form.dll</name>
               </assembly>
            </component>
         </components>
      </package>
   </packages>
</dotnetnuke>

Best wishes
Michael


Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
2/1/2010 6:55 PM
 

 Hi Michael,

does it matter that you have two SQLDataProvider scripts named 02.00.00 but they have different version numbers?

                   <script type="Install">
<path>Providers\DataProviders\SqlDataProvider</path>
<name>02.00.00.SqlDataProvider</name>
<version>02.00.00</version>
</script>
<script type="Install">
<path>Providers\DataProviders\SqlDataProvider</path>
<name>02.00.00.SqlDataProvider</name>
<version>02.00.02</version>
</script>
   
 
New Post
2/2/2010 10:59 AM
 

Barry,

shame on me. I checked this damn thing I don't know how often - and always missed that, even if I checked exactly that part....

Thanks a lot!
Michael


Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
Previous
 
Next
HomeHomeDevelopment and...Development and...Building ExtensionsBuilding ExtensionsModulesModulesSQL Error when installingSQL Error when installing


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