Gallery Error in pgsql version
I was testing the VS 2005/2.0 version and found an error in the Gallery using the pgsql data layer that also turned out to be in the current 1.0 release.
Unchecking the Module Setting "Compact Mode"
and then clicking a thumbail image when in non-compact mode it takes you to GalleryBrowse.aspx and this error occurs.
Turns out it is also an error in the current release.
Note to my self to fix this stored procedure for pgsql: mp_galleryimages_selectwebimagebypage
System.Exception: Unhandled Exception while processing NeatUpload child request ---> Npgsql.NpgsqlException:
invalid input syntax for integer: "totalpages"
Severity: ERROR
Code: 22P02
in <0x00054> Npgsql.NpgsqlConnector:CheckErrors ()
in <0x0001c> Npgsql.NpgsqlConnector:CheckErrorsAndNotifications ()
in <0x0005a> Npgsql.NpgsqlCommand:ExecuteCommand ()
in <0x0003e> Npgsql.NpgsqlCommand:ExecuteReader (CommandBehavior cb)
in <0x00036> Npgsql.NpgsqlCommand:System.Data.IDbCommand.ExecuteReader (CommandBehavior cb)
in <0x000a7> System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet dataSet, Int32 startRecord, Int32 maxRecords, System.String srcTable, IDbCommand command, CommandBehavior behavior)
in <0x00032> System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet dataSet)
in <0x000a5> mojoPortal.Data.NpgsqlHelper:ExecuteDataset (Npgsql.NpgsqlConnection connection, CommandType commandType, System.String commandText, Npgsql.NpgsqlParameter[] commandParameters)
in <0x00063> mojoPortal.Data.NpgsqlHelper:ExecuteDataset (System.String connectionString, CommandType commandType, System.String commandText, Npgsql.NpgsqlParameter[] commandParameters)
in <0x0023f> mojoPortal.Data.dbPortal:Gallery_GetWebImageByPage (Int32 ModuleID, Int32 PageNumber)
in <0x00010> mojoPortal.Business.Gallery:GetWebImageByPage (Int32 pageNumber)
in <0x00614> mojoPortal.Web.GalleryBrowse:Page_Load (System.Object sender, System.EventArgs e)
in (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs)
in <0x00117> System.Web.UI.Control:OnLoad (System.EventArgs e)
in <0x000e5> System.Web.UI.Control:LoadRecursive ()
in <0x0011e> System.Web.UI.Page:InternalProcessRequest ()
in <0x000a4> System.Web.UI.Page:ProcessRequest (System.Web.HttpContext context)--- End of inner exception stack trace ---
in <0x004a3> Brettle.Web.NeatUpload.UploadHttpModule:Application_BeginRequest (System.Object sender, System.EventArgs e)
in (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs)
in <0x0046f> System.Web.HttpApplication+<RunHooks>__0:MoveNext ()