Mail
SalarO skin design
Donnerstag, 09. September 2010 Forum   Suchen
registrieren

anmelden

English
Deutsch
Forum
 
ForumForumhelferlein_Supp...helferlein_Supp...helferlein_Form...helferlein_Form...Cannot add form itemsCannot add form items
vorherige vorherige
 
Nächste Nächste
neuer Beitrag
 22.01.2010 04:30
 
Re: Cannot add form items  (United States)

I am also running 5.02 and when I installed the form module I get a A critical error has occurred.The stored procedure 'dbo.helferlein_FormItemGetByModuleID' doesn't exist.. Not sure this is related to this. I will also try going backwards and see if that fixs it.

neuer Beitrag
 22.01.2010 16:19
 

Jason,

no, this has nothing to do with it...

Please do the following:

Go to Host:: SQL

Enter the following command:

SELECT COUNT(*) FROM sys.objects WHERE object_id = OBJECT_ID(N'{databaseOwner}{objectQualifier}helferlein_FormItemGetByModuleID') AND type in (N'P', N'PC')

If the result is 1: Enter the following command (just copy and paste...):

ALTER PROCEDURE {databaseOwner}{objectQualifier}helferlein_FormItemGetByPortalIDAndModuleID
   @ModuleID int
AS
BEGIN
   SET NOCOUNT ON;
   SELECT
      (SELECT PortalID FROM {databaseOwner}{objectQualifier}Modules WHERE {databaseOwner}{objectQualifier}Modules.ModuleID = {databaseOwner}{objectQualifier}helferlein_FormItem.ModuleID) AS PortalID,
      ModuleID,
      FormItemID,
      FormItemType,
      FormItemRepeatColumns,
      SortValue,
      FormItemRequired,
      Width,
      Height,
      FormItemLinkTarget
   FROM
      {databaseOwner}{objectQualifier}helferlein_FormItem
   WHERE
      (ModuleID = @ModuleID)
   ORDER BY
      SortValue
END
GO

EXEC sp_rename '{objectQualifier}helferlein_FormItemGetByPortalIDAndModuleID', '{objectQualifier}helferlein_FormItemGetByModuleID'
GO

Don't forget to check "Run as script", and then execute.

If the result is "0", let me know...

Let me know if that did help...

Best wishes,
Michael


Michael Tobisch
neuer Beitrag
 05.02.2010 03:41
 
Re: Cannot add form items  (United States)
 bearbeitet durch Jason Hutchison  am 05.02.2010 04:58:51

Sorry it took so long to reply. I ran the first script and get a value of "0". Not sure what to do next.

neuer Beitrag
 05.02.2010 19:11
 

Jason,

then please tell me the result of this:

SELECT COUNT(*) FROM sys.objects WHERE object_id = OBJECT_ID(N'{databaseOwner}{objectQualifier}helferlein_FormItemGetByPortalIDAndModuleID') AND type in (N'P', N'PC')

Best wishes
Michael


Michael Tobisch
neuer Beitrag
 05.02.2010 19:18
 
Re: Cannot add form items  (United States)

I get the results column 1 = 1.

vorherige vorherige
 
Nächste Nächste
ForumForumhelferlein_Supp...helferlein_Supp...helferlein_Form...helferlein_Form...Cannot add form itemsCannot add form items

Modulinhalt drucken  
Spenden

Wenn Sie die hier verfügbare Software für nützlich halten und einsetzen möchten, bitten wir Sie, sich beim Programmierer mit einer Spende zu bedanken. Spenden werden verwendet, um die Software weiterzuentwickeln und in das DNN Review-Programm einzureichen.

If you find any of the free software on this web site useful we encourage you to make a donation to the programmer. Donations will be used to to further develop the software and to join the DNN Review Program.

Copyright © 2007 by Michael Tobisch   Nutzungsbedingungen  Datenschutzerklärung