Thanks but that did not resolve my issue. The categories are ordered properly in the catagory list and the catalog list. The catalog page shows the items in right order but the category list in the sidebar shows a different order. I believe the order is of the category id.
Thanks. I have deactivated all the plugins except for product catalog and still get the same http 500 error. Any other thoughts on why this is occurring?