Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Dynamic Forms 2.7 to 3.1 Upgrade Issue
Last Post 10-09-2009 10:38 AM by David To. 5 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
BrantUser is Offline
new to the springs
new to the springs
Posts:1
Avatar

--
10-07-2009 05:43 AM

    I have a client that we are currently running Dynamic Forms 2.7 on a DNN 3.1.1 installation.  I purchased the latest Dynamic Forms 3.1 module.  I did an in place upgrade.  The upgrade completed without errors.  When I go to an existing form that we had, none of the fields show up. 

    However, when I go into the field manager, all my previous field values are there.  I've tried updating the fields and they still don't show up.  I created a new page with a brand new Dynamic Forms module.  I went through the wizard to add a couple questions and they still dont' show up.  I've also tried to import content from a existing module without success.

    Any help would be greatly appreciated.
    patrick blackburnUser is Offline
    going with the flow
    going with the flow
    Posts:37
    Avatar

    --
    10-07-2009 05:52 AM

    I am seeing the same issue.  I have also tried creating a new DF module and then importing my 3.0 content into it, the fields show up in the management ui, but the form itself is empty - here's what I get with debug=true (notice that the general settings - header text is present, but nothing beyond that):

    ***DYNAMIC FORMS DEBUG MODE ON***
    Dynamic Forms Version: 3.1.0.17786

    DotNetNuke Version: 4.9.2

    [...] Please provide the requested information for each GS Daisy in your troop who sold 100 or more packages of cookies.  [...]

    Error Painting Questions!Girl Scout TCM's Name - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Girl Scout TCM's Email - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Girl Scout TCM's Phone - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Girl Scout Troop # - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Girl Scout Service Unit # - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!HR01 - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Number of Packages Sold - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Girl Scout's First Name - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Girl Scout's Last Name - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Street Address - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!City - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Zip Code - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Girl Scout's Email - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!Girl Scout's Phone - Invalid object name 'dbo.DynamicForms_QuestionEventHiddenFields'.
    Initial Javascript:
     
    patrick blackburnUser is Offline
    going with the flow
    going with the flow
    Posts:37
    Avatar

    --
    10-07-2009 06:04 AM

    Looking at the trace, I do notice that our db uses a object qualifier, so all tables are misreferenced (saw something like this in the 2.7 upgrade, I seem to remember, Chad?)
     

    Debug complains:

    'dbo.DynamicForms_QuestionEventHiddenFields'.Error Painting Questions!City - Invalid object name


    Where our tables are actually named:

    'dbo.PREFIX_DynamicForms_QuestionEventHiddenFields'


    Do you have a script/patch that we can run to update all the table references when an object qualifier is used?

    Thanks!
    patrick blackburnUser is Offline
    going with the flow
    going with the flow
    Posts:37
    Avatar

    --
    10-07-2009 06:07 AM

    REFERENCE POST to the same object qualifier issue:


    http://www.datasprings.com/Products/Product-Forums/tabid/727/forumid/5/tpage/1/view/topic/postid/503/Default.aspx#509


    Chad - looks like it's the same issue, again.  Can we get a patch asap?
    Allan EUser is Offline
    wading in the water
    wading in the water
    Posts:19
    Avatar

    --
    10-09-2009 10:12 AM
    I have the same problem.
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    10-09-2009 10:38 AM
    HI, for a quick fix to this issue, please go to Host / SQL and type in:

    ALTER PROCEDURE {databaseOwner}[{objectQualifier}DynamicForms_GetDynamicQuestionEventByAffectedQuestion]
    @DynamicQuestionID as uniqueidentifier

    AS

    select * from {databaseOwner}{objectQualifier}DynamicForms_DynamicQuestionEvent

    Where (DynamicQuestionEventID In (Select DynamicQuestionEventID from {databaseOwner}{objectQualifier}DynamicForms_QuestionEventHiddenFields Where DynamicQuestionID = @DynamicQuestionID)
    OR DynamicAffectedQuestionID = @DynamicQuestionID) AND InActive=0
    AND IsDisabled =0

    -- David

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi