Don't know if this is the correct forum to post this in, if it's please point me in the right direction.

When adding a SuperFlexi component to a page I get a "The given key was not present in the dictionary." error, I am running the page locally with a mysql database that's on an external server.

Could this be because of capitalization, when installing I had change capitalization in setup/applicaations/blog/schemaupgradescripts/mysql/2.6.1.9 because MySQL on a Linux host is case sensitive, maybe it failed to create some SuperFlexi tables somewhere?

This is what I see in terms of superflexi tables:

`i7_sflexi_fields`, `i7_sflexi_items`, `i7_sflexi_searchdefs`, `i7_sflexi_values`

Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.2556.0
MySQL version 5.6.35

Stack trace:

[KeyNotFoundException: The given key was not present in the dictionary.]
   System.ThrowHelper.ThrowKeyNotFoundException() +36
   System.Collections.Generic.Dictionary`2.get_Item(TKey key) +52
   MySql.Data.MySqlClient.CharSetMap.GetCharacterSet(DBVersion version, String CharSetName) +53
   MySql.Data.MySqlClient.MySqlField.SetFieldEncoding() +288
   MySql.Data.MySqlClient.NativeDriver.GetColumnData(MySqlField field) +352
   MySql.Data.MySqlClient.NativeDriver.GetColumnsData(MySqlField[] columns) +39
   MySql.Data.MySqlClient.Driver.GetColumns(Int32 count) +111
   MySql.Data.MySqlClient.ResultSet.LoadColumns(Int32 numCols) +26
   MySql.Data.MySqlClient.ResultSet..ctor(Driver d, Int32 statementId, Int32 numCols) +59
   MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) +170
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +130
   MySql.Data.MySqlClient.MySqlDataReader.Close() +69
   MySql.Data.MySqlClient.MySqlConnection.Close() +60
   MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters) +137
   SuperFlexiUI.Widget.Page_Load(Object sender, EventArgs e) +272
   System.Web.UI.Control.OnLoad(EventArgs e) +103
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1381

Hi Joe,

This is running mojoPortal 2.6.