Hi,
I confirm this as a bug, the stored procedure does not have the Heading column.
I have moved away from using stored procs on pgsql except in rare cases where its needed.
To solve this look in the DBBlog.cs find the GetEntriesByCategory method. Comment out the existing implementation.
Paste this in:
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("SELECT * ");
sqlCommand.Append("FROM mp_blogs ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("moduleid = :moduleid ");
sqlCommand.Append("AND itemid IN (SELECT itemid FROM mp_blogitemcategories WHERE categoryid = :categoryid ) ");
sqlCommand.Append("ORDER BY ");
sqlCommand.Append("startdate DESC ");
sqlCommand.Append(";");
NpgsqlParameter[] arParams = new NpgsqlParameter[2];
arParams[0] = new NpgsqlParameter("moduleid", NpgsqlTypes.NpgsqlDbType.Integer);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = moduleId;
arParams[1] = new NpgsqlParameter("categoryid", NpgsqlTypes.NpgsqlDbType.Integer);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = categoryId;
return NpgsqlHelper.ExecuteReader(
GetConnectionString(),
CommandType.Text,
sqlCommand.ToString(),
arParams);
rebuild and redeploy the mojoPortal.Features.Data.dll
I have made the same change here to fix this for the next release.
Thanks,
Joe