Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

DotNetNuke Marketplace
  Ads  
Aspose - The .NET & Java component publisher
 


  Sponsors  

Meet Our Sponsors

OnyakTech
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  Installing module does not execute previous SQL scripts
Previous Previous
 
Next Next
New Post 8/23/2006 3:26 AM
User is offline Rodney Joyce
1641 posts
www.smart-thinker.com
5th Ranked




Installing module does not execute previous SQL scripts 
Hello,

I am working on the latest release of my UserProfile module, and a user reported some strange errors that were down to a missing table (created in version 1.0.0). From his install log, it looks like only script 4.3.1 is firing (the newest one). It's definitely a new install (I know on upgrades this would be the expected behaviour).

Has anyone seen this before? Is it a caching issue of sorts? What tells the Installer to run previous scripts - does it just do a version check? Here is in the install file - you can see it is missing the other SQL executes: (There where no errors reported)during the install here is the Install log... it's long:

Install Module:: Smart-Thinker - UserProfile
Info:: Starting Installation
Info:: Reading files
Info:: Loading SmartThinker.DNN.Modules.UserProfile.dll
Info:: File SmartThinker.DNN.Modules.UserProfile.dll read successfully
Info:: Loading SmartThinker.DNN.Modules.UserProfile.SqlDataProvider.dll
Info:: File SmartThinker.DNN.Modules.UserProfile.SqlDataProvider.dll read successfully
Info:: Loading module.css
Info:: File module.css read successfully
Info:: Loading Settings.ascx
Info:: File Settings.ascx read successfully
Info:: Loading SettingsBirthdaysView.ascx
Info:: File SettingsBirthdaysView.ascx read successfully
Info:: Loading SettingsUserProfile.ascx
Info:: File SettingsUserProfile.ascx read successfully
Info:: Loading UserProfile.ascx
Info:: File UserProfile.ascx read successfully
Info:: Loading UserProfileBirthdaysView.ascx
Info:: File UserProfileBirthdaysView.ascx read successfully
Info:: Loading UserProfileEdit.ascx
Info:: File UserProfileEdit.ascx read successfully
Info:: Loading UserProfilePersonalInfo.ascx
Info:: File UserProfilePersonalInfo.ascx read successfully
Info:: Loading UserProfileProfile.ascx
Info:: File UserProfileProfile.ascx read successfully
Info:: Loading UserProfileValidator.ascx
Info:: File UserProfileValidator.ascx read successfully
Info:: Loading Smart-Thinker - UserProfile.dnn
Info:: File Smart-Thinker - UserProfile.dnn read successfully
Info:: Loading Version History.txt
Info:: File Version History.txt read successfully
Info:: Loading Installation.txt
Info:: File Installation.txt read successfully
Info:: Loading License.txt
Info:: File License.txt read successfully
Info:: Loading NoPhoto.jpg
Info:: File NoPhoto.jpg read successfully
Info:: Loading Uninstall.SqlDataProvider
Info:: File Uninstall.SqlDataProvider read successfully
Info:: Loading 01.00.00.SqlDataProvider
Info:: File 01.00.00.SqlDataProvider read successfully
Info:: Loading 01.00.01.SqlDataProvider
Info:: File 01.00.01.SqlDataProvider read successfully
Info:: Loading UserProfileDirectory.ascx
Info:: File UserProfileDirectory.ascx read successfully
Info:: Loading UserProfileDirectory.ascx.resx
Info:: File UserProfileDirectory.ascx.resx read successfully
Info:: Loading 01.00.02.SqlDataProvider
Info:: File 01.00.02.SqlDataProvider read successfully
Info:: Loading UserProfileEdit.ascx.resx
Info:: File UserProfileEdit.ascx.resx read successfully
Info:: Loading UserProfile.ascx.resx
Info:: File UserProfile.ascx.resx read successfully
Info:: Loading Settings.ascx.resx
Info:: File Settings.ascx.resx read successfully
Info:: Loading UserProfileValidator.ascx.resx
Info:: File UserProfileValidator.ascx.resx read successfully
Info:: Loading UserProfileProfile.ascx.resx
Info:: File UserProfileProfile.ascx.resx read successfully
Info:: Loading UserProfilePersonalInfo.ascx.resx
Info:: File UserProfilePersonalInfo.ascx.resx read successfully
Info:: Loading UserProfileBirthdaysView.ascx.resx
Info:: File UserProfileBirthdaysView.ascx.resx read successfully
Info:: Loading SettingsUserProfile.ascx.resx
Info:: File SettingsUserProfile.ascx.resx read successfully
Info:: Loading SettingsBirthdaysView.ascx.resx
Info:: File SettingsBirthdaysView.ascx.resx read successfully
Info:: Loading UserDataBirthdayEmail.ascx.resx
Info:: File UserDataBirthdayEmail.ascx.resx read successfully
Info:: Loading 01.00.04.SqlDataProvider
Info:: File 01.00.04.SqlDataProvider read successfully
Info:: Loading 04.03.01.SqlDataProvider
Info:: File 04.03.01.SqlDataProvider read successfully
Info:: Loading SmartThinker.DNN.Modules.UserProfile.UserProfile.LIC
Info:: File SmartThinker.DNN.Modules.UserProfile.UserProfile.LIC read successfully
Info:: Loading Module Config Guide.doc
Info:: File Module Config Guide.doc read successfully
Info:: Loading SmartThinker.DNN.Modules.ModuleSecurity.dll
Info:: File SmartThinker.DNN.Modules.ModuleSecurity.dll read successfully
Info:: Loading SettingsDirectoryView.ascx
Info:: File SettingsDirectoryView.ascx read successfully
Info:: Loading SettingsDirectoryView.ascx.resx
Info:: File SettingsDirectoryView.ascx.resx read successfully
Info:: Reading files done.
Info:: Reading DNN file
Info:: DNN file is in valid 3.0 format.
Info:: xml loaded.
Info:: Loading files info
Info:: Found valid path (Documentation) for Installation.txt.
Info:: Found valid path (Documentation) for License.txt.
Info:: Found valid path (Documentation) for Module Config Guide.doc.
Info:: Found valid path (Documentation) for Version History.txt.
Info:: Found valid path (Images) for NoPhoto.jpg.
Info:: Found valid path (App_LocalResources) for Settings.ascx.resx.
Info:: Found valid path (App_LocalResources) for UserProfile.ascx.resx.
Info:: Found valid path (App_LocalResources) for UserProfileEdit.ascx.resx.
Info:: Found valid path (App_LocalResources) for UserProfilePersonalInfo.ascx.resx.
Info:: Found valid path (App_LocalResources) for UserProfileValidator.ascx.resx.
Info:: Found valid path (Licenses\04.03.01\) for SmartThinker.DNN.Modules.UserProfile.UserProfile.LIC.
Info:: Loading Modules info
Info:: Loading Control info for 'Smart-Thinker - UserProfile Validator' module
Info:: Loading Control info for 'Smart-Thinker - UserProfile PersonalInfo' module
Info:: Loading Control info for 'Smart-Thinker - UserProfile' module
Info:: Loading files info
Info:: Found valid path (App_LocalResources) for UserProfileDirectory.ascx.resx.
Info:: Loading Modules info
Info:: Loading Control info for 'Smart-Thinker - UserProfile - Directory' module
Info:: Loading files info
Info:: Found valid path (App_LocalResources) for SettingsBirthdaysView.ascx.resx.
Info:: Found valid path (App_LocalResources) for UserProfileBirthdaysView.ascx.resx.
Info:: Found valid path (App_LocalResources) for UserDataBirthdayEmail.ascx.resx.
Info:: Loading Modules info
Info:: Loading Control info for 'Smart-Thinker - UserProfile - Birthdays' module
Info:: Loading files info
Info:: Found valid path (App_LocalResources) for SettingsUserProfile.ascx.resx.
Info:: Found valid path (App_LocalResources) for UserProfileProfile.ascx.resx.
Info:: Loading Modules info
Info:: Loading Control info for 'Smart-Thinker - UserProfile - Profile' module
Info:: Dnn load finished successfully
Info:: Begin Sql execution
Info:: Executing 04.03.01.SqlDataProvider
Info:: Start Sql execution: 04.03.01.SqlDataProvider file
Info:: End Sql execution: 04.03.01.SqlDataProvider file
Info:: Finished Sql execution
Info:: Creating files
Info:: Created D:\inetpub\DomainID117155\bin\SmartThinker.DNN.Modules.UserProfile.dll
Info:: Created D:\inetpub\DomainID117155\bin\SmartThinker.DNN.Modules.UserProfile.SqlDataProvider.dll
Info:: Created D:\inetpub\DomainID117155\bin\SmartThinker.DNN.Modules.ModuleSecurity.dll
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Providers\DataProviders\SqlDataProvider\01.00.01.SqlDataProvider
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Providers\DataProviders\SqlDataProvider\01.00.02.SqlDataProvider
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Providers\DataProviders\SqlDataProvider\01.00.04.SqlDataProvider
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Providers\DataProviders\SqlDataProvider\04.03.01.SqlDataProvider
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Uninstall.SqlDataProvider
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Documentation\Installation.txt
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Documentation\License.txt
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Documentation\Module Config Guide.doc
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Documentation\Version History.txt
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\module.css
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Images\NoPhoto.jpg
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Settings.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\UserProfile.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\UserProfileEdit.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\UserProfilePersonalInfo.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\UserProfileValidator.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\Settings.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\UserProfile.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\UserProfileEdit.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\UserProfilePersonalInfo.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\UserProfileValidator.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Licenses\04.03.01\SmartThinker.DNN.Modules.UserProfile.UserProfile.LIC
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Smart-Thinker - UserProfile.dnn.config
Info:: Files created
Info:: Registering DesktopModule
Info:: Registering Definitions
Info:: Registering Controls
Info:: Registering finished
Info:: Begin Sql execution
Info:: Finished Sql execution
Info:: Creating files
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\UserProfileDirectory.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\UserProfileDirectory.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Smart-Thinker - UserProfile.dnn.config
Info:: Files created
Info:: Registering DesktopModule
Info:: Registering Definitions
Info:: Registering Controls
Info:: Registering finished
Info:: Begin Sql execution
Info:: Finished Sql execution
Info:: Creating files
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\SettingsBirthdaysView.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\UserProfileBirthdaysView.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\UserDataBirthdayEmail.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\UserProfileBirthdaysView.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\SettingsBirthdaysView.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Smart-Thinker - UserProfile.dnn.config
Info:: Files created
Info:: Registering DesktopModule
Info:: Registering Definitions
Info:: Registering Controls
Info:: Registering finished
Info:: Begin Sql execution
Info:: Finished Sql execution
Info:: Creating files
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\UserProfileProfile.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\SettingsUserProfile.ascx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\SettingsUserProfile.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\App_LocalResources\UserProfileProfile.ascx.resx
Info:: Created D:\inetpub\DomainID117155\DesktopModules\Smart-Thinker - UserProfile\Smart-Thinker - UserProfile.dnn.config
Info:: Files created
Info:: Registering DesktopModule
Info:: Registering Definitions
Info:: Registering Controls
Info:: Registering finished
Info:: Installation successful.
Server Name: WEBC8

Muchappreciated for any pointers!
Thanks,
Rodney
Smart-Thinker - Social Networking modules for DotNetNuke
The DotNetNuke Directory - Are you listed?
PokerDIY - Example Implementation of DNN Social Network
Do use DNN a lot? Try the DotNetNuke Toolbar to save you time!
 
New Post 8/25/2006 5:04 AM
User is offline Rodney Joyce
1641 posts
www.smart-thinker.com
5th Ranked




Re: Installing module does not execute previous SQL scripts 
Anyone got any theories?

Thanks,
Rodney
Smart-Thinker - Social Networking modules for DotNetNuke
The DotNetNuke Directory - Are you listed?
PokerDIY - Example Implementation of DNN Social Network
Do use DNN a lot? Try the DotNetNuke Toolbar to save you time!
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  Installing module does not execute previous SQL scripts
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


Swirlhost Inc.
Affordable DotNetNuke Hosting, Skin Development, Custom Module Development, and DotNetNuke Consulting. We will install your preference of DNN and now host with us and get a free license for the Swirl AJAX Chatroom Module.
www.swirlhost.com 		Active Modules, Inc.
Creators of Active Forums, the best forum module for DotNetNuke
www.activemodules.com 		DNNCovered.com - Your Offshore Dotnetnuke Partner
Dnncovered.com is the only Dotnetnuke offshore outsourcing center specializes in DNN skinning and module development with lowest pricing and quality service. Our staff is dedicated to websites based on DNN and our graphic designers are creative and imaginative well enough to provide customers the complete set of skinning solutions and packages
www.dnncovered.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP