Moving MojoPortal problem

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.
11/20/2014 7:26:22 AM
Gravatar
Total Posts 83

Re: Moving MojoPortal problem

Yes, its possible that the MySQL server is a Linux server that would make sense based on the name. But renaming all 128 tables manully just to see how the enviroment works at the new host sounds like alot of work? Is there any other way? Why are not mojoPortal simple using lowcase always?

11/20/2014 7:32:18 AM
Gravatar
Total Posts 83

Re: Moving MojoPortal problem

Im not sure what the real  camel mixed case is for these 128 tables(could not find any table description on mojoportal.com?) but I tried to rename one in MySQL Workbench (right click on table > alter table and then change the name and den save) but this says theat mp_AuthorizenetlLg are the same as mp_authorizenetlog ?

11/20/2014 8:09:08 AM
Gravatar
Total Posts 18439

Re: Moving MojoPortal problem

I told you run the setup page against an empty db, it will create the tables with the correct name and then you will have a reference on how the migrated tables need to be renamed.

Yes, its a bit of work maybe 30-45 minutes manually renaming tables, but if you want to solve the problem that is probably what it will take. 

if it gives trouble about it not being different then make the table name mp_AuthorizenetLogx, then rename it again without x. But honestly I would not expect linux to complain about those names not being different since it is case sensitive. So it casts a little doubt over whether that is the problem. Still it could be the tool that complains, and it is the only thing I know to try. I had to do it myself on this site many years ago.

yes in hindsight it would have been better to just use all lower case tables from the beginning, but I did not know about this difference in MySql on windows vs linux until a few years after mojoportal was originally developed and it is not the kind of thing you can fix later automatically and the problem rarely ever comes up, only a few times in the 10 years of mojoPortal existence that I know of.

11/20/2014 8:16:18 AM
Gravatar
Total Posts 18439

Re: Moving MojoPortal problem

note also that if running the setup on an empty db does not create mixed case tables then it rules out the idea of it being linux, but if it does then it confirms the diagnosis

11/21/2014 6:59:54 AM
Gravatar
Total Posts 83

Re: Moving MojoPortal problem

Thanks a lot! It worked after renaming so the MySQL server most be a Linux sever. The webserver is however a Windows Server and this was the reson to my misleading.

Here is the script I ran : 

RENAME TABLE 
mp_authorizenetlog to mp_AuthorizeNetLog,
mp_bannedipaddresses to mp_BannedIPAddresses,
mp_blogcategories to mp_BlogCategories,
mp_blogcomments to mp_BlogComments,
mp_blogitemcategories to mp_BlogItemCategories,
mp_blogs to mp_Blogs,
mp_blogstats to mp_BlogStats,
mp_calendarevents to mp_CalendarEvents,
mp_category to mp_Category,
mp_categoryitem to mp_CategoryItem,
mp_comments to mp_Comments,
mp_commercereport to mp_CommerceReport,
mp_commercereportorders to mp_CommerceReportOrders,
mp_contactformmessage to mp_ContactFormMessage,
mp_contenthistory to mp_ContentHistory,
mp_contentmeta to mp_ContentMeta,
mp_contentmetalink to mp_ContentMetaLink,
mp_contentrating to mp_ContentRating,
mp_contentstyle to mp_ContentStyle,
mp_contenttemplate to mp_ContentTemplate,
mp_contentworkflow to mp_ContentWorkflow,
mp_contentworkflowaudithistory to mp_ContentWorkflowAuditHistory,
mp_currency to mp_Currency,
mp_emailsendlog to mp_EmailSendLog,
mp_emailsendqueue to mp_EmailSendQueue,
mp_emailtemplate to mp_EmailTemplate,
mp_fileattachment to mp_FileAttachment,
mp_forumposts to mp_ForumPosts,
mp_forums to mp_Forums,
mp_forumsubscriptions to mp_ForumSubscriptions,
mp_forumthreads to mp_ForumThreads,
mp_forumthreadsubscriptions to mp_ForumThreadSubscriptions,
mp_friendlyurls to mp_FriendlyUrls,
mp_galleryimages to mp_GalleryImages,
mp_geocountry to mp_GeoCountry,
mp_geozone to mp_GeoZone,
mp_googlecheckoutlog to mp_GoogleCheckoutLog,
mp_htmlcontent to mp_HtmlContent,
mp_indexingqueue to mp_IndexingQueue,
mp_language to mp_Language,
mp_letter to mp_Letter,
mp_letterhtmltemplate to mp_LetterHtmlTemplate,
mp_letterinfo to mp_LetterInfo,
mp_lettersendlog to mp_LetterSendLog,
mp_lettersubscribe to mp_LetterSubscribe ,
mp_lettersubscribehx to mp_LetterSubscribeHx,
mp_links to mp_Links,
mp_mediafile to mp_MediaFile,
mp_mediaplayer to mp_MediaPlayer,
mp_mediatrack to mp_MediaTrack,
mp_moduledefinitions to mp_ModuleDefinitions,
mp_moduledefinitionsettings to mp_ModuleDefinitionSettings,
mp_modules to mp_Modules,
mp_modulesettings to mp_ModuleSettings,
mp_pagemodules to mp_PageModules,
mp_pages to mp_Pages,
mp_paymentlog to mp_PaymentLog,
mp_paypallog to mp_PayPalLog,
mp_plugnpaylog to mp_PlugNPayLog,
mp_pollmodules to mp_PollModules,
mp_polloptions to mp_PollOptions,
mp_polls to mp_Polls,
mp_pollusers to mp_PollUsers,
mp_redirectlist to mp_RedirectList,
mp_roles to mp_Roles,
mp_rssfeedentries to mp_RssFeedEntries,
mp_rssfeeds to mp_RssFeeds,
mp_savedquery to mp_SavedQuery,
mp_schemascripthistory to mp_SchemaScriptHistory,
mp_schemaversion to mp_SchemaVersion,
mp_sharedfilefolders to mp_SharedFileFolders,
mp_sharedfiles to mp_SharedFiles,
mp_sharedfileshistory to mp_SharedFilesHistory,
mp_sitefolders to mp_SiteFolders,
mp_sitehosts to mp_SiteHosts,
mp_sitemoduledefinitions to mp_SiteModuleDefinitions,
mp_sitepaths to mp_SitePaths,
mp_sitepersonalizationallusers to mp_SitePersonalizationAllUsers,
mp_sitepersonalizationperuser to mp_SitePersonalizationPerUser,
mp_sites to mp_Sites,
mp_sitesettingsex to mp_SiteSettingsEx,
mp_sitesettingsexdef to mp_SiteSettingsExDef,
mp_surveymodules to mp_SurveyModules,
mp_surveypages to mp_SurveyPages,
mp_surveyquestionanswers to mp_SurveyQuestionAnswers,
mp_surveyquestionoptions to mp_SurveyQuestionOptions,
mp_surveyquestions to mp_SurveyQuestions,
mp_surveyresponses to mp_SurveyResponses,
mp_surveys to mp_Surveys,
mp_systemlog to mp_SystemLog,
mp_tag to mp_Tag,
mp_tagitem to mp_TagItem,
mp_tagvocabulary to mp_TagVocabulary,
mp_taskqueue to mp_TaskQueue,
mp_taxclass to mp_TaxClass,
mp_taxrate to mp_TaxRate,
mp_taxratehistory to mp_TaxRateHistory,
mp_userlocation to mp_UserLocation,
mp_userpages to mp_UserPages,
mp_userproperties to mp_UserProperties,
mp_userroles to mp_UserRoles,
mp_users to mp_Users,
mp_webparts to mp_WebParts,
ws_cart to ws_Cart,
ws_cartoffers to ws_CartOffers,
ws_cartorderinfo to ws_CartOrderInfo,
ws_discount to ws_Discount,
ws_fullfilldownloadhistory to ws_FullfillDownloadHistory,
ws_fullfilldownloadterms to ws_FullfillDownloadTerms,
ws_fullfilldownloadticket to ws_FullfillDownloadTicket,
ws_offer to ws_Offer,
ws_offeravailability to ws_OfferAvailability,
ws_offeravailabilityhistory to ws_OfferAvailabilityHistory,
ws_offerhistory to ws_OfferHistory,
ws_offerpricehistory to ws_OfferPriceHistory,
ws_offerproduct to ws_OfferProduct,
ws_order to ws_Order,
ws_orderofferproduct to ws_OrderOfferProduct,
ws_orderoffers to ws_OrderOffers,
ws_orderstatus to ws_OrderStatus,
ws_orderstatusdescription to ws_OrderStatusDescription,
ws_product to ws_Product ,
ws_productfile to ws_ProductFile,
ws_producthistory to ws_ProductHistory,
ws_store to ws_Store,
ws_storecurrency to ws_StoreCurrency,
ws_storelanguage to ws_StoreLanguage;

 

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