I've used the NPetstore as jumping off point for an
application that I'm writing as the moment. The issue occurs when I move it from
my local development environment to the live machines. Although there are no
issues in connecting to the database, and performing queries normally, there is
one page that is throwing an exception......
| Exception : | at
NLogic.Brewtopia.Service.CatalogService.GetItemListByStatus(Int32 status, Int32
pageSize) in
c:\projects\brewtopia\nlogic.brewtopia.service\catalogservice.cs:line 114 at
NLogic.Brewtopia.Presentation.UserActions.CatalogAction.ShowItemsByStatus(Int32
status, Int32 pageSize) in
c:\projects\brewtopia\nlogic.brewtopia.presentation\useractions\catalogaction.cs:line
85 at NLogic.Brewtopia.Presentation.UserActions.GeneralAction.NextView(String
ContentId, HttpContext context) in
c:\projects\brewtopia\nlogic.brewtopia.presentation\useractions\generalaction.cs:line
27 at NLogic.Brewtopia.Web.Default.Page_Load(Object sender, EventArgs e) in
c:\projects\brewtopia\nlogic.brewtopia.web\default.aspx.cs:line 51 at
System.Web.UI.Control.OnLoad(EventArgs e) at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Page.ProcessRequestMain()
|
| Error message : | Error executing query 'GetItemListByStatus' for paginated
list. Cause: Specified method is not supported. |
The
machines differ in that dev is an XP machine using mysql 4.1 and live is a 03
server using mysql 5.0.
On
reflection it this is the only page at the moment that returns a list, paginated
in this case, but during my testing I changed it to a plain list with no change
in result. I'm using
the ByteFX connector to get to the
DB
Cheers,
David
