Hi there, yesterday i have updated my mojoportal instance to:

mojoPortal Version 2.3.7.0 MySQL
Operating System Microsoft Windows NT 6.0.6002 Service Pack 2
ASP.NET Info v2.0.50727 Running in full trust

i have followed the upgrade procedure, replaced mysql dlls, the setup script run smoothly. I am hosting several sites on that instance based on folder names, and all the sites were working fine until now. Now if I try to open up these sites, i receive a message, which says: We're sorry but a server error has occurred while trying to process your request.....

in the system log i see: 
2011-11-09 06:37:39,210 ERROR (null) - (null) - (null) - mojoPortal.Web.Global -  Referrer(http://mysite.com/) useragent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2
System.IndexOutOfRangeException: Could not find specified column in results: SiteID
   at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e)
   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Is this a mojoportal bug, or an issue on my side? Any ideas how should i proceed further?

Thanks in advance for the answer, you really do a great job

Erik 

Hmm. good question, Probably i can't tell it now exactly, i would need to contact the hosting company to restore the DB. I believe it was around 2.3.6.2. Are there suggestions what I could do to fix this issue?  The mysql.dll -s I have replaced already once again. I am thinking about making a fresh install on a VM test machine to see the table structure and compare with my one (i wouldnt want to lose the data). and maybe manually create missing coloumns if there are or so. Or if the data structure is backwards compatible, is it possible to switch back or downgrade to a former version?

Hi Joe

I have identified the place where it breaks, it is here: mojoPortal.Data.MySQL/ DBSiteSettings.cs : 2058
 

sqlCommand.Append("SELECT COALESCE(s.SiteID, -1) ");
            sqlCommand.Append("FROM mp_SiteFolders sf ");
            sqlCommand.Append("JOIN mp_Sites s ");
            sqlCommand.Append("ON ");
            sqlCommand.Append("sf.SiteGuid = s.SiteGuid ");
            sqlCommand.Append("WHERE sf.FolderName = ?FolderName ");
            sqlCommand.Append("ORDER BY s.SiteID ");
            sqlCommand.Append(";");

            using (IDataReader reader = MySqlHelper.ExecuteReader(
                GetReadConnectionString(),
                sqlCommand.ToString(),
                arParams))
            {
                if (reader.Read())
                {
                    siteId = Convert.ToInt32(reader["SiteID"]);
                }

on the reader["SiteID"] row. unfortunately i am not good at SQL, but i have verified the mp_Sitefolders table, i have there the row for the website with a guid b2f...., in the mp_sites table i have a row with the same guid, the returned siteId should be 2. What is interesting, if i change the call to siteId = Convert.ToInt32(reader[0]);, i get siteId=2 back, which is correct. Do you have a tip what could be wrong?

Thanks

Erik

Hi ,

I have similar problem. But my site works ok for first instance - SiteID=1, but when i try to go to Site 2 it gives me next errors

2011-12-17 17:55:30,496 ERROR (null) - (null) - (null) - mojoPortal.Web.Global - Referrer(none) useragent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7
System.IndexOutOfRangeException: Could not find specified column in results: SiteID
at MySql.Data.MySqlClient.ResultSet.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.GetOrdinal(String name)
at MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name)
at mojoPortal.Data.DBSiteSettings.GetSiteIdByFolder(String folderName)
at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache()
at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext()
at mojoPortal.Web.SiteUtils.GetDefaultCulture()
at mojoPortal.Web.CultureHelperHttpModule.BeginRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2011-12-17 17:56:02,636 ERROR (null) - (null) - (null) - mojoPortal.Web.Global - Referrer(none) useragent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7
System.IndexOutOfRangeException: Could not find specified column in results: SiteID
at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I checked mp_Sites and it's there.

I can't say when exactly it stopped working, 2 things happened recently:

1) i moved from one provider to another and this new provider has MySql locally on windows server, before this the Mysql was remotely on Unix version of MySql,

2) i've made upgrade of the portal to 2.3.7.0 MySQL vesrion

but this second subsite was not used and i never checked it after this two changes and can't say if it failed after move or after upgrade.

Any clues?

Regards,

Victor