MySql issue installation: mp_ForumSubscriptions doesn't exist -

MySql issue installation: mp_ForumSubscriptions doesn't exist

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.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

What operating system were you running when the bug appeared?
What database platform is your site using?
What version of mojoPortal are you running?
What version of .NET do you use?
What steps are necessary to reproduce the issue? Compare expected results vs actual results.

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.

This thread is closed to new posts. You must sign in to post in the forums.

1/13/2009 6:02:29 AM

Alexei

Total Posts 35

View Posts

---------------- Alexei V.

MySql issue installation: mp_ForumSubscriptions doesn't exist

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

1/13/2009 7:21:06 AM

Joe Audette

Total Posts 18439

View Posts

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

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

1/13/2009 7:23:55 AM

Alexei

Total Posts 35

View Posts

---------------- Alexei V.

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

version 5.0.70-log
version_comment Gentoo Linux mysql-5.0.70

I guess its ok ?

1/13/2009 7:27:20 AM

Alexei

Total Posts 35

View Posts

---------------- Alexei V.

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

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

1/13/2009 7:33:52 AM

Joe Audette

Total Posts 18439

View Posts

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

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.

Hope it helps,

Joe

1/13/2009 7:42:26 AM

Alexei

Total Posts 35

View Posts

---------------- Alexei V.

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

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]

1/13/2009 7:53:52 AM

Joe Audette

Total Posts 18439

View Posts

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

You are looking in the wrong folder, what you posted is for ms sql not mysql

Best,

Joe

1/13/2009 7:57:15 AM

Alexei

Total Posts 35

View Posts

---------------- Alexei V.

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

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;

1/13/2009 10:47:09 AM

Alexei

Total Posts 35

View Posts

---------------- Alexei V.

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

1/13/2009 10:53:48 AM

Joe Audette

Total Posts 18439

View Posts

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

you will have to copy the missing table scripts and run them manually

1/14/2009 12:39:38 AM

Alexei

Total Posts 35

View Posts

---------------- Alexei V.

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

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 (Алексей Владышевский)

1/14/2009 4:47:25 AM

Joe Audette

Total Posts 18439

View Posts

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

Hi Alexei,

You are correct, this is a bug in the scripts, it had passed my testing because on windows it forces lower case table names. I am making the same correction here.

I reviewed other MySql scripts and found similar problems in the blog and shared files scripts, so you should look at those as you are missing a few more tables releated to those features and will need to run the table scripts manually for thoswe as you did with this one.

Thanks,

Joe

1/14/2009 4:56:06 PM

HeftiSchlumpf

Total Posts 44

View Posts

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

Hey Joe, is this problem already fixed in 2.2.8.2 ?

or do i need to get the latest stuff from svn ?

1/15/2009 5:14:25 AM

Joe Audette

Total Posts 18439

View Posts

Re: MySql issue installation: mp_ForumSubscriptions doesn't exist

Its only fixed in svn so far as it was just reported yesterday. I hope to ship a fixed release soon.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.