iFinity

Hello Bruce,

I have DotNetNuke 5.2.1 installation. I tried to install URLMaster 1.15.1 to this instance however, something went wrong i guess. The installation documentation at C:\Users\id\Desktop\iFinity.UrlMaster_01.15.01_Instructions\Url Master Install Instructions.htm states that i should have following pages upon installation.

Host > Friendly URL Settings

Admin > Page URLs

None of these pages created after installation. I tried to restart application from Host Settings with no luck. Then added extra space to web.config to manually recycle application pool with no luck again.

Then checked Host > Module Definitions page and saw that ifinity URL Master entry was there.

Then decided to add ifinity URL Master module to a page to check whether it would work or not. After placing module i received following error msg.

The stored procedure 'dbo.ifty_GetTabRedirectsForTab' doesn't exist.

Here is the detailed error log:

AssemblyVersion: 5.2.1
PortalID: 0
PortalName: Hidden..
UserID: 1
UserName: host
ActiveTabID: 70
ActiveTabName: URL Yönetimi
RawURL: /Admin/URLYönetimi.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://hiddenweb.info/Admin/URLY%C3%B6netimi.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: c344abd2-d350-4ef4-8fe2-0ca44dabde55
InnerException: The stored procedure 'dbo.ifty_GetTabRedirectsForTab' doesn't exist.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlCommand.DeriveParameters
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: The stored procedure 'dbo.ifty_GetTabRedirectsForTab' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.ifty_GetTabRedirectsForTab' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at iFinity.DNN.Modules.UrlMaster.Data.SqlDataProvider.GetTab(Int32 tabId) at iFinity.DNN.Modules.UrlMaster.UrlMasterController.GetTab(Int32 tabId, Boolean addStdUrls, PortalSettings portalSettings, FriendlyUrlSettings settings) at iFinity.DNN.Modules.UrlMaster.UI.Controls.PageList.GetTab(Int32 portalId, Int32 tabId) at iFinity.DNN.Modules.UrlMaster.UI.Controls.PageList.GetSelectedTab() at iFinity.DNN.Modules.UrlMaster.UI.Controls.PageList.TabsToScreen(Int32 portalId) at iFinity.DNN.Modules.UrlMaster.UI.Controls.PageList.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:

I tried a few times with restore and reinstall but it didn't work. I was about to purchase this module for a client, which wants to have news website online before December 28th.

Some of my server info: Windows Server 2008 - SQL Server 2008

Server collation: Latin1_General_CI_AS

Database collation: Latin1_General_CI_AS

Used locales: English (en-us) and Turkish (tr-tr) Turkish localization files can be downloaded from DotNetNuke Offical website...

Can you help me to debug and fix it quickly?

I'm still not able to get a valid 5.2.1 install and I've wasted about 20 hours trying to do this.  After reading of the numerous problems of this release on the dnn forums, I'm going to wait a couple of days and see if they put out a new release to fix the problems with the install scripts, then I'll test out the compatibilty on the new release.

OK, I have a working dnn 5.2.1 install now.  I did this by installing a 5.1.4 install and then upgrading to 5.2.1 from there, putting a manual change in the Sql Data Provider file to get around the bug in the default release.

After testing out the install and running of the Url Master module, I can't find any compatibility problems.

The error you've reported is because the module is missing one of the stored procedures that it creates.  Therefore, the install of the module must have failed on your machine.  I recommend uninstalling the module,  then doing a re-install again.  When you re-install, check carefully the install log on the page to make sure that all the .sqldataprovider files run correctly.  If you do this and find an error on the install, then report back here with the error.