Question

Photo of David Hanson

0

Rock Shop Errors

I'm having a strange issue, which may be related to the issues I experienced during my recent upgrade to 8.5.

When I navigate to Rock Shop, the page loads and I see the various plugins that are available; however, I receive an error when attempting to click on a plugin, or when I click on the Purchases and Account links under "Store Links". 

When I click on a plugin, I receive a message indicating, "Store Currently Not Available". 

When I click on Purchases (under Store Links), I get a notification page of, "That Wasn't Support to Happen" with the following Exception: 

JsonReaderException in Newtonsoft.Json 

Message 

Unexpected character encountered while parsing value: <. Path '', line 0, position 0. 

Stack Trace  

   at Newtonsoft.Json.JsonTextReader.ParseValue()  

   at Newtonsoft.Json.JsonTextReader.Read() 

   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType(JsonReader reader, JsonContract contract, Boolean hasConverter) 

   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent) 

   at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType) 

   at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) 

   at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) 

   at Rock.Store.PackageService.GetPurchasedPackages(String& errorResponse) 

   at RockWeb.Blocks.Store.PurchasedPackages.DisplayPackages() 

   at RockWeb.Blocks.Store.PurchasedPackages.OnLoad(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.Control.LoadRecursive() 

   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.Control.LoadRecursive() 

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 


When I click on "Account", I receive a notification page of, "We Can't Find That Page" (using the URL of http://www.rockrms.com/Rock/Organization/EAAAAKpQBT3pyODvAaNm9/C0vES07V0z98uc2PLYMfT7T1dUr+A7uYB6s+p++nQVdN5cOjjKW8ebql11lGwbC3LGJkg=)

I don't think this is a file issue as I can successfully access these links using my test Rock 8.5 instance and my production instance has the exact copy of files. So this must be a DB issue in that my production database has different values in a table (or tables) than my testing DB (which works).  

Can someone tell me what tables are accessed for these links so I can compare my testing DB with my production DB? 

  • Photo of David Hanson

    0

    Any ideas or suggestions from anyone??  I attempted to download the SDK to try and find the SQL query that's associated with the Rock.Shop block, but can't find where the queries are defined.  Any help will be greatly appreciated!