Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Error creating new Gallery
ambasador
#1 Posted : Wednesday, 14 September 2011 4:57:47 AM(UTC)
Rank: Advanced Member

Joined: 28/06/2010(UTC)
Posts: 30
Location: Cork

Hi all,

anyone knows how to eliminate that error. thx

Quote:


We are sorry, but Gallery Server Pro encountered an error. It has been logged and, if error reporting is enabled, an email describing the problem has been sent to the administrator.

Error: Violation of UNIQUE KEY constraint 'UC_gs_GallerySetting_FKGalleryId_SettingName'. Cannot insert duplicate key in object 'dbo.gs_GallerySetting'. The duplicate key value is (7, AutoSyncIntervalMinutes).

Error Summary

Timestamp


9/14/2011 12:49:25 PM

Exception Type


System.Data.SqlClient.SqlException

Message


Violation of UNIQUE KEY constraint 'UC_gs_GallerySetting_FKGalleryId_SettingName'. Cannot insert duplicate key in object 'dbo.gs_GallerySetting'. The duplicate key value is (7, AutoSyncIntervalMinutes).

Source


.Net SqlClient Data Provider

Target Site


Void OnError(System.Data.SqlClient.SqlException, Boolean)

Stack Trace


at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at GalleryServerPro.Data.SqlServer.GalleryData.ConfigureGallery(Int32 galleryId)
at GalleryServerPro.Data.SqlServer.SqlDataProvider.Gallery_Configure(IGallery gallery)
at GalleryServerPro.Business.Gallery.Save()
at GalleryServerPro.Web.Pages.Admin.galleries.CreateGallery(String description)
at GalleryServerPro.Web.Pages.Admin.galleries.gvGalleries_RowCommand(Object sender, GridViewCommandEventArgs e)
at System.Web.UI.WebControls.GridView.OnRowCommand(GridViewCommandEventArgs e)
at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup)
at System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs 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)

Exception Data


HelpLink.ProdName: Microsoft SQL Server

HelpLink.ProdVer: 10.00.4064

HelpLink.EvtSrc: MSSQLServer

HelpLink.EvtID: 2627

HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink

HelpLink.LinkId: 20476

Error Handling Exception: The function HandleGalleryException experienced the following error while trying to log an error: System.Xml.XmlException - Unexpected end of file while parsing Name has occurred. Line 80, position 12. Stack trace: at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String arg)
at System.Xml.XmlTextReaderImpl.ParseQName(Boolean isQName, Int32 startOffset, Int32& colonPos)
at System.Xml.XmlTextReaderImpl.ParseElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlTextReader.Read()
at System.Data.DataTextReader.Read()
at System.Data.XmlDataLoader.LoadTable(DataTable table, Boolean isNested)
at System.Data.XmlDataLoader.LoadData(XmlReader reader)
at System.Data.DataTable.ReadXmlDiffgram(XmlReader reader)
at System.Data.DataTable.ReadXml(XmlReader reader, Boolean denyResolving)
at System.Data.DataTable.ReadXml(TextReader reader)
at GalleryServerPro.ErrorHandler.Error.Deserialize(String xmlToDeserialize)
at GalleryServerPro.ErrorHandler.Error.GetAppErrorsFromDataReader(IEnumerab le`1 appErrorDtos)
at GalleryServerPro.ErrorHandler.Error.GetAppErrors()
at GalleryServerPro.ErrorHandler.Error.ValidateLogSize(Int32 maxNumberErrorItems)
at GalleryServerPro.ErrorHandler.Error.Record(Exception ex, Int32 galleryId, IGallerySettingsCollection gallerySettingsCollection, IAppSetting appSettings)
at GalleryServerPro.Web.Controller.AppErrorController.LogError(Exception ex, Int32 galleryId)
at GalleryServerPro.Web.Controller.AppErrorController.HandleGalleryExceptio n(Exception ex, Int32 galleryId)
Roger Martin
#2 Posted : Wednesday, 14 September 2011 6:32:24 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI

The error says that the system is trying to create a new gallery with an ID of 7, but a record already exists in the gs_GallerySetting table with gallery ID=7 and setting=AutoSyncIntervalMinutes.

I can't imagine the circumstances that would createto this error, so I am not sure what to suggest. Have you manually edited the records of any tables, especially gs_GallerySetting?

Also, what version of GSP are you using?
Roger Martin
Creator and Lead Developer of Gallery Server Pro
ambasador
#3 Posted : Wednesday, 14 September 2011 8:16:29 AM(UTC)
Rank: Advanced Member

Joined: 28/06/2010(UTC)
Posts: 30
Location: Cork

Im using latest version of gps, win2003 (32) and SQL server 2008.

Problem is that query running fine for gs_Gallery on, but GallerySettings is empty.

Even if i will delete those rec and create new one, ive got the same error.

Ok will create all records for GallerySettings manualy.
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.