Great!

I followed your indications and it worked

but now, I tried to recreate database, i just executed scripts from 2CreateTables.sql

inside a new database, and I have pointed to this new database my mojoPortal with (in .config files)

and now i get this error: 

An Error Occurred:Object reference not set to an instance of an object.
Source:mojoPortal.Web
Stack Trace at mojoPortal.Web.SiteUtils.GetRoleCookieName(SiteSettings siteSettings) at mojoPortal.Web.mojoRoleProvider.GetRolesForUser(String userName) at System.Web.Security.RolePrincipal.IsInRole(String role) at mojoPortal.Business.WebHelpers.WebUser.IsInRole(String role) at mojoPortal.Business.WebHelpers.WebUser.get_IsAdmin() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

any suggestions ?

I created new database, and i set web.config to point it. but I still get same problem.

 An Error Occurred:Object reference not set to an instance of an object.
Source:mojoPortal.Web
Stack Trace at mojoPortal.Web.SiteUtils.GetRoleCookieName(SiteSettings siteSettings) at mojoPortal.Web.mojoRoleProvider.GetRolesForUser(String userName) at System.Web.Security.RolePrincipal.IsInRole(String role) at mojoPortal.Business.WebHelpers.WebUser.IsInRole(String role) at mojoPortal.Business.WebHelpers.WebUser.get_IsAdmin() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Then I returned to my previously created database and I try to open mojoPortal, it works fine at load homepage, login, user pages...

but

if i go to forum, i get this message:

Unable to convert MySQL date/time value to System.DateTime
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime

Source Error:

Line 53: </td>
Line 54: <td headers='<%# Resources.ForumResources.ForumModulePostLastPostLabel %>'>
Line 55: <%# DateTimeHelper.GetTimeZoneAdjustedDateTimeString(((System.Data.Common.DbDataRecord)Container.DataItem),"MostRecentPostDate", TimeOffset) %>
Line 56: </td>
Line 57: </tr>

Source File: g:\mssqlreleasefiles\wwwroot\Forums\ForumModule.ascx Line: 55
 

Followed your advice i did not execute any script manually, I only created empty database, but i get the same error.

my Sql version still:

did5.0.51b-community-nt
MySQL Community Edition (GPL)

Win32

no, I created new database named mojo2, i never did use a name like that, I succesfull connected my self with mojouser login/pwd

then i hit run. as always in visual studio to launch webSite and i see automaticly this page:

http://localhost:1306/wwwroot/Setup/Default.aspx

An Error Occurred:Object reference not set to an instance of an object.
Source:mojoPortal.Web
Stack Trace at mojoPortal.Web.SiteUtils.GetRoleCookieName(SiteSettings siteSettings) at mojoPortal.Web.mojoRoleProvider.GetRolesForUser(String userName) at System.Web.Security.RolePrincipal.IsInRole(String role) at mojoPortal.Business.WebHelpers.WebUser.IsInRole(String role) at mojoPortal.Business.WebHelpers.WebUser.get_IsAdmin() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)