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

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Installing module does not execute previous SQL scriptsInstalling module does not execute previous SQL scripts
Previous
 
Next
New Post
8/23/2006 5:26 AM
 
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!

Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

 
New Post
8/25/2006 7:04 AM
 
Anyone got any theories?


Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Installing module does not execute previous SQL scriptsInstalling module does not execute previous SQL scripts


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