Export plan and fields

  • Y. Rippon
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 months 3 weeks ago #168146 by Y. Rippon
Export plan and fields was created by Y. Rippon
Hi,
I tried to upgrade a J3 website to J5 in order to get all memberships pro data from the database and import them in a Real New J5 website. 

But the structures of some tables changed : plans, fields...and I don't know how to do. 

Please Can you help me ?


Best regards

Myann 
 

Please Log in or Create an account to join the conversation.

More
4 months 3 weeks ago #168161 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export plan and fields
Hi Myann

1. Just please make sure both sites are running on latest version of Membership Pro

2. Then export database tables related to Membership Pro from old site database, import it into new site database. See docs.joomdonation.com/membershippro/gett...e-site-to-a-new-site for instructions

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Y. Rippon
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 months 3 weeks ago #168162 by Y. Rippon
Replied by Y. Rippon on topic Export plan and fields
Hi,

that's what I made. But in the plan table, there are 95 column for J5 and 96 for the old website.

The column set_lifetime_subscription isn't in the new release. I add it in the table to make it work.

Really, do you forget this column or do you delete it ?

Thank you for your help.
Regards

Myann

Please Log in or Create an account to join the conversation.

More
4 months 3 weeks ago #168167 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export plan and fields
set_lifetime_subscription should be available for new installation. You do not need to add the field manually yourself. Just go to Membership Pro, then Tools -> Fix Database Schema to update database schema to have the database structure up to date

Regards,

Tuan
The following user(s) said Thank You: Y. Rippon

Please Log in or Create an account to join the conversation.

  • Y. Rippon
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 months 3 weeks ago #168168 by Y. Rippon
Replied by Y. Rippon on topic Export plan and fields
I did it. Thank you.
I don't know why it was not there.

Thank you again.

Regards

Please Log in or Create an account to join the conversation.

More
4 months 3 weeks ago #168169 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export plan and fields
You're welcome

Tuan

Please Log in or Create an account to join the conversation.

More
1 month 6 days ago - 1 month 6 days ago #169761 by EmediaWeb
Replied by EmediaWeb on topic Export plan and fields
I'm having the a similar issue. I have a development site running J5 and Membership Pro 4.1 , and I want to transfer the membership pro data from my old J3 site running Membership Pro 3.6.2. However, when I try to update the J3 site to Mem Pro 4.1, I get the following error:

Error
Cannot install Membership Pro in a Joomla release prior to 4.2.0
Error installing package


I am also running eShop and Event Bookings on the site. Will this be an issue with these applications as well?

Please advise.

Thanks,

Gene

** UPDATE **

FYI. I was able to update eShop and export/import the data tables via phpadmin into the new site with no issues. However, I did get the same error message trying to upgrade Event Booking. 

 
Last edit: 1 month 6 days ago by EmediaWeb.

Please Log in or Create an account to join the conversation.

More
1 month 6 days ago #169767 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export plan and fields
Hi

For Joomla 3, you cannot use latest version of Membership Pro. Please submit a support ticket so that we can send you the latest version which is compatible with Joomla 3

Regards,

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc