Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.
If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.
When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:
You may also want to review the installation or upgrading documentation.
I installed the latest 2.2.8.2 version of mojoportal release for mssql, then y downloaded mysql data layer same version and i extracted it overwriting files inside bin folder.
I started the portal, and it worked great !
But, I could not create forum due to this error (from log):
2009-01-13 14:21:57,086 ERROR mojoPortal.Web.mojoBasePage - 194.186.179.140-ru-RU - /portal/forum.aspx MySql.Data.MySqlClient.MySqlException: Table 'gb_av_mojo.mp_ForumSubscriptions' doesn't exist at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean ExternalConn) at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
...and a lot of line codes ...
http://portal.gnosere.ru/portal , you temporary may login or exec Setup
If you are using MySql 5.1, it has major bugs, I recommend use 5.0 instead.
I would verify does the table exist or not? If not then maybe upload all the /Setup folder again, possibly not all the scripts made it.
Hope it helps,
Joe
version 5.0.70-log version_comment Gentoo Linux mysql-5.0.70
I guess its ok ?
I performed /Setup several times,
Forum setup module - 00:00:03.9843240
but anyway mp_ForumSubscription does not exist i only have tables:
Tables_in_gb_av_mojo mp_AuthorizeNetlog mp_BannedIPAddresses mp_BlogCategories mp_Blogs mp_CalendarEvents mp_ContactFormMessage mp_ContentRating mp_Currency mp_Forums mp_FriendlyUrls mp_GalleryImages mp_GeoCountry mp_GeoZone mp_GoogleCheckoutLog mp_HtmlContent mp_IndexingQueue mp_Language mp_Letter mp_LetterHtmlTemplate mp_LetterInfo mp_LetterSendLog mp_LetterSubscriber mp_LetterSubscriberHx mp_Links mp_ModuleDefinitionSettings mp_ModuleDefinitions mp_ModuleSettings mp_Modules mp_PageModules mp_Pages mp_PayPalLog mp_PollModules mp_PollOptions mp_PollUsers mp_Polls mp_RedirectList mp_Roles mp_RssFeedEntries mp_RssFeeds mp_SchemaScriptHistory mp_SchemaVersion mp_SharedFileFolders mp_SharedFiles mp_SiteFolders mp_SiteHosts mp_SiteModuleDefinitions mp_SitePaths mp_SitePersonalizationAllUsers mp_SitePersonalizationPerUser mp_SiteSettingsEx mp_SiteSettingsExDef mp_Sites mp_SurveyModules mp_SurveyPages mp_SurveyQuestionAnswers mp_SurveyQuestionOptions mp_SurveyQuestions mp_SurveyResponses mp_Surveys mp_TaskQueue mp_TaxClass mp_TaxRate mp_TaxRateHistory mp_UserLocation mp_UserPages mp_UserProperties mp_UserRoles mp_Users mp_WebParts ws_Cart ws_CartOffers ws_CartOrderInfo ws_FullfillDownloadHistory ws_FullfillDownloadTerms ws_FullfillDownloadTicket ws_Offer ws_OfferAvailability ws_OfferAvailabilityHistory ws_OfferHistory ws_OfferPriceHistory ws_OfferProduct ws_Order ws_OrderOfferProduct ws_OrderOffers ws_OrderStatus ws_OrderStatusDescription ws_Product ws_ProductFile ws_ProductHistory ws_Store ws_StoreCurrency ws_StoreLanguage
That is very strange. If you look in the /Setup/applications/forums/SchemaInstallScripts/mysql/0.0.0.1.config file you will see it has script there to create the table. It will not run that script again since it thinks its already past version 0.0.0.1 so you will have to copy the missing table scripts and run them manually. You are also missing several other forums tables as you will see when you review this script.
yes, the script is there, I dont know why it was not performed.
/****** Object: Table [dbo].[mp_ForumSubscriptions] Script Date: 11/10/2008 13:12:29 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[mp_ForumSubscriptions]( [SubscriptionID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [ForumID] [int] NOT NULL, [UserID] [int] NOT NULL, [SubscribeDate] [datetime] NOT NULL CONSTRAINT [DF_mp_ForumSubscriptions_SubscribeDate] DEFAULT (getdate()), [UnSubscribeDate] [datetime] NULL, CONSTRAINT [PK_mp_ForumSubscriptions] PRIMARY KEY CLUSTERED ( [SubscriptionID] ASC ) ON [PRIMARY] ) ON [PRIMARY]
You are looking in the wrong folder, what you posted is for ms sql not mysql
Best,
Oops, Sorry.
any way it is present the right query inside mysql:
CREATE TABLE `mp_ForumSubscriptions` ( `SubscriptionID` int(11) NOT NULL auto_increment, `ForumID` int(11) NOT NULL default '0', `UserID` int(11) NOT NULL default '0', `SubscribeDate` datetime NOT NULL default '0000-00-00 00:00:00', `UnSubscribeDate` datetime default NULL, PRIMARY KEY (`SubscriptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `mp_ForumThreadSubscriptions` ( `ThreadSubscriptionID` int(11) NOT NULL auto_increment, `ThreadID` int(11) NOT NULL default '0', `UserID` int(11) NOT NULL default '0', `SubscribeDate` datetime NOT NULL default '0000-00-00 00:00:00', `UnSubscribeDate` datetime default NULL, PRIMARY KEY (`ThreadSubscriptionID`), KEY `FK_mp_ForumThreadSubThread` (`ThreadID`), CONSTRAINT `FK_mp_ForumThreadSubThread` FOREIGN KEY (`ThreadID`) REFERENCES `mp_forumthreads` (`ThreadID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `mp_ForumSubscriptions` ( `SubscriptionID` int(11) NOT NULL auto_increment, `ForumID` int(11) NOT NULL default '0', `UserID` int(11) NOT NULL default '0', `SubscribeDate` datetime NOT NULL default '0000-00-00 00:00:00', `UnSubscribeDate` datetime default NULL, PRIMARY KEY (`SubscriptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `mp_ForumThreadSubscriptions` ( `ThreadSubscriptionID` int(11) NOT NULL auto_increment, `ThreadID` int(11) NOT NULL default '0', `UserID` int(11) NOT NULL default '0', `SubscribeDate` datetime NOT NULL default '0000-00-00 00:00:00', `UnSubscribeDate` datetime default NULL, PRIMARY KEY (`ThreadSubscriptionID`), KEY `FK_mp_ForumThreadSubThread` (`ThreadID`), CONSTRAINT `FK_mp_ForumThreadSubThread` FOREIGN KEY (`ThreadID`) REFERENCES `mp_forumthreads` (`ThreadID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
?
you will have to copy the missing table scripts and run them manually
Dear Joe!
I found the problem for a lot of issues in MySql queries when a MySql server is running under linux systems, the table names are filenames (same as in win32 MySql server version) but, all Unix OS has case sensitive filenames.
So, the query
CREATE TABLE `mp_ForumThreads` ( `ThreadID` int(11) NOT NULL auto_increment, `ForumID` int(11) NOT NULL default '0', `ThreadSubject` varchar(255) NOT NULL default '', `ThreadDate` datetime NOT NULL default '0000-00-00 00:00:00', `TotalViews` int(11) NOT NULL default '0', `TotalReplies` int(11) NOT NULL default '0', `SortOrder` int(11) NOT NULL default '1000', `IsLocked` tinyint(1) unsigned NOT NULL default '0', `ForumSequence` int(11) NOT NULL default '1', `MostRecentPostDate` datetime default NULL, `MostRecentPostUserID` int(11) default NULL, `StartedByUserID` int(11) NOT NULL default '0', PRIMARY KEY (`ThreadID`), KEY `FK_mp_ForumThreads_Forum` (`ForumID`), CONSTRAINT `FK_mp_ForumThreads_Forum` FOREIGN KEY (`ForumID`) REFERENCES `mp_forums` (`ItemID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
of course fails, becouse there is no such table mp_forums. it was creates with name mp_Forums
I just changed the case and it worked. will be better to fix all the queries, to support Unix based Mysql versions.
thanks
Alexei Vladychevski (Алексей Владышевский)