Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsupgrade issue upgrade issue
Previous
 
Next
New Post
4/4/2007 10:01 PM
 
Team Bound


Joined: 6/17/2004
Posts: 183

Just upgraded from 3.02 to 3.3.7 . there were sql errors on the install. the module does not allow me to view details or other views

need help quick - site down

uninstalled, attempted reinstall of 3.2 got following errors then upgrade again to 3.37 still no luck. whats wrong?

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'EventTimeBegin' in table 'dbo.EventsSignups' is specified more than once. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* Database Tables */ ALTER TABLE dbo.EventsSignups ADD EventTimeBegin DateTime NULL System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'TimezoneOffset' in table 'dbo.EventsSignups' is specified more than once. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.EventsSignups ADD TimezoneOffset int NULL
EndJob End Sql execution: 03.03.02.SqlDataProvider file
 
Info Executing 03.03.03.SqlDataProvider
StartJob Start Sql execution: 03.03.03.SqlDataProvider file
EndJob End Sql execution: 03.03.03.SqlDataProvider file
 
Info Executing 03.03.05.SqlDataProvider
StartJob Start Sql execution: 03.03.05.SqlDataProvider file
EndJob End Sql execution: 03.03.05.SqlDataProvider file
 
Info Executing 03.03.07.SqlDataProvider
StartJob Start Sql execution: 03.03.07.SqlDataProvider file
EndJob End Sql execution: 03.03.07.SqlDataProvider file
 
EndJob Finished Sql execution
 
StartJob Creating files
Info Created c:\websites\787dw7\bin\DotNetNuke.Modules.Events.dll
Info Created c:\websites\787dw7\bin\DotNetNuke.Events.ScheduleControl.dll
Info Created c:\websites\787dw7\bin\DotNetNuke.Events.WebControls.dll
Info Created c:\websites\787dw7\DesktopModules\Events\EditEvents.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventDay.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventDetails.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventEditCategories.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventEditLocations.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventIPN.aspx
Info Created c:\websites\787dw7\DesktopModules\Events\EventList.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventModerate.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventMonth.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventMyEnrollments.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventPPEnroll.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\Events.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventTZUpdate.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\EventVCal.aspx
Info Created c:\websites\787dw7\DesktopModules\Events\EventWeek.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\ImportAVCalendar.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\module.css
Info Created c:\websites\787dw7\DesktopModules\Events\SelectCategory.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\Settings.ascx
Info Created c:\websites\787dw7\DesktopModules\Events\Tooltip.js
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EditEvents.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventDay.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventDetails.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventEdit.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventEditCategories.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventEditLocations.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventEventImport.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventList.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventModerate.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventMonth.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventMyEnrollments.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventNotification.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventPPEnroll.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\Events.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventTZUpdate.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\EventWeek.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\ImportAVCalendar.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\SelectCategory.ascx.resx
Info Created c:\websites\787dw7\DesktopModules\Events\App_LocalResources\Settings.ascx.resx
Info Created c:\websites\787dw7\bin\DotNetNuke.Modules.Events.SqlDataProvider.dll
Info Created c:\websites\787dw7\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Created c:\websites\787dw7\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.02.00.SqlDataProvider
Info Created c:\websites\787dw7\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.00.SqlDataProvider
Info Created c:\websites\787dw7\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.02.SqlDataProvider
Info Created c:\websites\787dw7\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.03.SqlDataProvider
Info Created c:\websites\787dw7\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.05.SqlDataProvider
Info Created c:\websites\787dw7\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.07.SqlDataProvider
Info Created c:\websites\787dw7\DesktopModules\Events\Uninstall.SqlDataProvider
Info Created c:\websites\787dw7\DesktopModules\Events\bgcolor.gif
Info Created c:\websites\787dw7\DesktopModules\Events\dn-curve.gif
Info Created c:\websites\787dw7\DesktopModules\Events\navlink.gif
Info Created c:\websites\787dw7\DesktopModules\Events\SmallCalendar.gif
Info Created c:\websites\787dw7\DesktopModules\Events\Themes\Default\gradient_Default.jpg
Info Created c:\websites\787dw7\DesktopModules\Events\Themes\Default\Default.css
Info Created c:\websites\787dw7\DesktopModules\Events\Themes\Small\gradient_Small.jpg
Info Created c:\websites\787dw7\DesktopModules\Events\Themes\Small\Small.css
Info Created c:\websites\787dw7\DesktopModules\Events\Themes\FixedBlue\gradient_LtBlue.jpg
Info Created c:\websites\787dw7\DesktopModules\Events\Themes\FixedBlue\FixedBlue.css
Info Created c:\websites\787dw7\DesktopModules\Events\Themes\Gray\gradient_Gray.jpg
Info Created c:\websites\787dw7\DesktopModules\Events\Themes\Gray\Gray.css
Info Created c:\websites\787dw7\DesktopModules\Events\DNN_Events.dnn.config
EndJob Files created
 
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
 
EndJob Installation successful.
 
 
Return

Carl
 
New Post
4/5/2007 7:36 AM
 
Van Vangor


www.linkedin.com/pub/van-vangor/7/810/34
Joined: 4/14/2005
Posts: 109

Teambound:

I apologize but I don't have any suggestions about your specific error.  However, you mentioned that you need help quick because your site is down.  Hopefully, you backed up your site before installing the update.  If so, restore the original while waiting for help from others.  You did a backup, right?

I wanted to throw out some backup advice for others, too, because issue comes up regularly.  I host my own DNN sites, so I'll share what I do before I install any updates (especially betas).

  • First, I shut down the SQL Server and IIS services.
  • Then I backup the following trees to another location:
    • ..\Program Files\Microsoft SQL Server\*.* (including all subfolders)
    • ..\DNNSite\*.* (including all subfolders) (This would be the main folder of your DNN site)
  • Then I turn on the SQL Server and IIS Services again.

Yes, it's overkill, but I'm pretty anal-retentive, so it works for me.  When something strange happens during an installation (such as the problem you described above), I perform the reverse procedure to restore the original site. 

Folks that are using an external host for their DNN Site, may not be able use the procedure above.  Someone else can probably share some insight about what to do that case.

 

Good Luck!
Van

See Ya! Van
 
New Post
4/5/2007 8:22 AM
 
Alan Vance

Alan Vance's Avatar

www.avanced.net
Joined: 5/7/2003
Posts: 552

OK...take a deep breath.  The upgrade DOES NOT DELETE DATA.   However, the instance of the Event Module may be causing problems on your page.  Either 1) you had an old version of the Events module that we did not test with that caused the SQL Upgrade errors or 2) a version of DNN running that we did not test with.  There are many versions of the module and dnn... so we need this to help...So,what versions of everything are/were you running:?

Like others have said...this is somewhat of a lesson everyone that runs DNN needs to be aware of....backup the site and the database whenever you upgrade anything.  If you have not done so, I would strongly recommend you do that now, as uninstalling and re-installing may cause more issues...I repeat, the upgrade to Events 3.3.7 did not delete data!
 
New Post
4/5/2007 8:46 AM
 
Team Bound


Joined: 6/17/2004
Posts: 183

Thanks for the reply!!  and the advice on backups. Yes I do have a backup -- I was just panicing as the events modules is a core module on my site. the site supports my communities sports programs and I have about 20 event modules on the site where teams manage their schedules. It just about season time and the coaches are scrambling to get the schedules loaded.

In any event, I was running the very last beta  of events prior to this release. I did not uninstall the beta but just installed 337. After that, I can no longer view details, switch modes (list) etc. I can add, delete ok. I am also running dnn 441.

Unfortunately, I did uninstall and reinstall a couple of times. reloaded an older version  which did install and work ok.

What do you recommend  I do. Id hate to restore since there has been a lot of activity on the site.

thx

 
 
New Post
4/5/2007 8:53 AM
 
Alan Vance

Alan Vance's Avatar

www.avanced.net
Joined: 5/7/2003
Posts: 552
I'm not sure I have a good recommendation.  I too have been upgrading my site (www.avanced.net), with all the versions, including beta...  I have not tried to install the released version yet, as their may be issues with the release process...Did you use the Release version from the DNN site?  Source or PA version:?
 
 Page 1 of 3
123Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsupgrade issue upgrade issue


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