Hello

Recently i noticed that my page management in admin settings doesnt save any changes i make.

Whatever i do even as small as changing the name of a page is not saved. And i dont get any error.

I didnt update to the latest version. It says i have a critical update to do. My version at the moment is 07.03.04 (45). Am suspecting that this mght be the issue but am not sure.

And last time i upgrade i had many issues so i dont want to risk it for now.

Here is the Log i get:

AssemblyVersion:7.3.4

PortalID:0

PortalName:Petrolina

UserID:1

UserName:host

ActiveTabID:63

ActiveTabName:Pages

RawURL:/en-gb/Admin/Pages

AbsoluteURL:/Default.aspx

AbsoluteURLReferrer:http://www.petrolina.com.cy/en-gb/Admin/Pages

UserAgent:Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.157 Safari/537.36

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:759584b4-ee3d-4e82-932a-abdbef273086

InnerException:Procedure or function 'UpdateTab' expects parameter '@IsSystem', which was not supplied.

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:System.Data.SqlClient.SqlConnection.

StackTrace:

Message:

DotNetNuke.Services.Exceptions.PageLoadException: Procedure or function 'UpdateTab' expects parameter '@IsSystem', which was not supplied. ---> System.Data.SqlClient.SqlException: Procedure or function 'UpdateTab' expects parameter '@IsSystem', which was not supplied.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at PetaPoco.Database.Execute(String sql, Object[] args)
   at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, Int32 timeout, String sql, Object[] args)
   at DotNetNuke.Data.SqlDataProvider.ExecuteNonQuery(String procedureName, Object[] commandParameters)
   at DotNetNuke.Data.DataProvider.UpdateTab(Int32 tabId, Int32 contentItemId, Int32 portalId, Guid versionGuid, Guid defaultLanguageGuid, Guid localizedVersionGuid, String tabName, Boolean isVisible, Boolean disableLink, Int32 parentId, String iconFile, String iconFileLarge, String title, String description, String keyWords, Boolean isDeleted, String url, String skinSrc, String containerSrc, DateTime startDate, DateTime endDate, Int32 refreshInterval, String pageHeadText, Boolean isSecure, Boolean permanentRedirect, Single siteMapPriority, Int32 lastModifiedByuserID, String cultureCode)
   at DotNetNuke.Entities.Tabs.TabController.UpdateTab(TabInfo updatedTab)
   at DesktopModules.Admin.Tabs.View.CmdUpdateClick(Object sender, EventArgs e)
   at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
   at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---

Source:

Server Name: webgeneral

No i didnt try anything to resolve it yet.

I dont want to upgrade at least for now, because it might damage anything from the website like before.

How did this procedure entered my database? I didnt install anything new to the website. 

Is there another way to resolve this without upgrading and rollback? Like removing the procedure (and ofcourse if it doesnt affect anything from the website)