Error when adding SuperFlexi to a page

Post here if you have questions about creating SuperFlexi Solutions.

The SuperFlexi documentation is very thorough, so you might want to start there.

12/5/2017 12:39:35 AM
Gravatar
Total Posts 5

Error when adding SuperFlexi to a page

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
12/5/2017 9:57:24 AM
Gravatar
Total Posts 1992

Re: Error when adding SuperFlexi to a page

Hi,

Are you running the mojoPortal 2.6 release or are you building from the repository?

We're working on some additional functionality for SuperFlexi that we have working MSSQL but we haven't gotten the MySQL side done yet. So, if you're building from the repo and wanting to use MySQL, you could run into problems.

Thanks,
Joe

12/5/2017 10:10:43 AM
Gravatar
Total Posts 5

Re: Error when adding SuperFlexi to a page

Hi Joe,

This is running mojoPortal 2.6.