Error message: Error while executing query: INSERT INTO cmsGoogleSiteMapItems (id,idObject,ObjectType,Priority,Frequency,Images,DateUpdated) SELECT Convert(int, Convert(varbinary(36), NewID())),ecmProducts.id,N'Product',N'0.8',N'monthly',Stuff((Select '‡' + CONVERT(VARCHAR(255), ot.Path) FROM cmsAttachments ot WHERE ot.idobject = ecmProducts.id AND ot.objecttype = N'Product' For Xml Path('')), 1, 1, '' ),'2025-09-21 04:46:39' FROM ecmProducts LEFT OUTER JOIN cmsGoogleSiteMapItems ON cmsGoogleSiteMapItems.idObject=ecmProducts.id WHERE ecmProducts.SiteMap=1 AND ecmProducts.published=1 AND cmsGoogleSiteMapItems.id IS NULL
Url: https://allforoffice.gr/skin.aspx?lang=el&action=googlesitemap&exportlang=el
Message: Error while executing query: INSERT INTO cmsGoogleSiteMapItems (id,idObject,ObjectType,Priority,Frequency,Images,DateUpdated) SELECT Convert(int, Convert(varbinary(36), NewID())),ecmProducts.id,N'Product',N'0.8',N'monthly',Stuff((Select '‡' + CONVERT(VARCHAR(255), ot.Path) FROM cmsAttachments ot WHERE ot.idobject = ecmProducts.id AND ot.objecttype = N'Product' For Xml Path('')), 1, 1, '' ),'2025-09-21 04:46:39' FROM ecmProducts LEFT OUTER JOIN cmsGoogleSiteMapItems ON cmsGoogleSiteMapItems.idObject=ecmProducts.id WHERE ecmProducts.SiteMap=1 AND ecmProducts.published=1 AND cmsGoogleSiteMapItems.id IS NULL
at Bone.DBConnection.ExecuteUpdate(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 139
at Bone.BONE.ExecuteUpdate(String sql) in C:\Bone\Bone\src\BONE.cs:line 1681
at Cms.ActionGoogleSitemapSettings.UpdateSiteMapType(String type, Boolean updateall, List`1 log) in C:\Bone\Cms\src\DBItems\GoogleSiteMapItem\ActionGoogleSitemapSettings.cs:line 222
at Cms.ActionGoogleSitemapSettings.UpdateSiteMap(Boolean updateall, List`1 log) in C:\Bone\Cms\src\DBItems\GoogleSiteMapItem\ActionGoogleSitemapSettings.cs:line 151
at Cms.ActionGoogleSitemapSettings.UpdateSiteMap(Boolean updateall) in C:\Bone\Cms\src\DBItems\GoogleSiteMapItem\ActionGoogleSitemapSettings.cs:line 143
at Cms.ActionGoogleSitemap.Render(TextWriter w) in C:\Bone\Cms\src\DBItems\GoogleSiteMapItem\ActionGoogleSitemap.cs:line 98
at Bone.Action.RenderContent(TextWriter w) in C:\Bone\Bone\src\Actions\_Action.cs:line 404
at Bone.EmptyAction.RenderPage(TextWriter w) in C:\Bone\Bone\src\Actions\Empty.cs:line 65
at Bone.Asp.Render(HtmlTextWriter w) in C:\Bone\Bone\src\Classes\Asp.cs:line 82
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Message: Violation of PRIMARY KEY constraint 'PK__cmsGoogl__3213E83FCB772338'. Cannot insert duplicate key in object 'dbo.cmsGoogleSiteMapItems'. The duplicate key value is (-224678956).
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Bone.DBConnection.ExecuteUpdate(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 126