Thanks Roger.
It was obvious once I looked at the correct web.config file....
The behaviour has changed a bit now (it had changed before the change to the web.config file).
Compacting the database runs without error now.
Sync'ing now runs, but new folders and photos don't come up on the photo server. They are however being indexed, as the compressed images and thumbnails are now present in the database folders if I go and view them in Windows Explorer. But they are not visible in the set of photos in GSP, nor are the folders in the list which comes up when you select 'This role applies to the following albums:' under Add a New Role.
Sorry, but I can't work out how to paste the error as HTML, so I have only posted a limited bit of it. The error which now comes up when I do a sync, or try to look at the list of folders in an album is posted below.
Thanks for your help Roger - appreciate it.
Dave
Error: String was not recognized as a valid DateTime.Couldn't store <30/10/2011 08:05:33> in TimeStamp Column. Expected type is DateTime.
Error Summary
Url http://localhost/Davidsmediagallery/default.aspx?g=admin_errorlog&aid=4
Timestamp 30/10/2011 08:20:26
Exception Type
System.ArgumentException
Message
String was not recognized as a valid DateTime.Couldn't store <30/10/2011 08:05:33> in TimeStamp Column. Expected type is DateTime.
Source
System.Data
Target Site
Void set_Item(Int32, System.Object)
Stack Trace
at System.Data.DataColumn.set_Item(Int32 record, Object value)
at System.Data.DataRow.set_Item(DataColumn column, Object value)
at GalleryServerPro.Web.Controller.AppErrorController.GetAppErrorsDataSet(Int32 galleryId, Boolean includeSystemErrors)
at GalleryServerPro.Web.Pages.Admin.errorlog.BindGrid()
at GalleryServerPro.Web.Pages.Admin.errorlog.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.EventHandler.Invoke(Object sender, 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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Inner Ex Type
System.FormatException
Inner Ex Message
String was not recognized as a valid DateTime.
Inner Ex Source
mscorlib
Inner Ex Target Site
System.DateTime Parse(System.String, System.IFormatProvider)
Inner Ex Stack Trace
at System.DateTime.Parse(String s, IFormatProvider provider)
at System.Convert.ToDateTime(String value, IFormatProvider provider)
at System.Data.Common.DateTimeStorage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)
App Error ID
-2147483648
Gallery ID
1
HTTP User Agent
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0.2) Gecko/20100101 Firefox/6.0.2