MarketPress upgrade to 3.0 went horribly wrong

Hi,

I fear the MarketPress upgrade to 3.0 destroyed all 1700+ products. None of them have their featured image any more (or at least as soon as I edit one, the featured image has gone) and product pages show only an excerpt with a ‘read more’ link… which points to the exact same page! And all prices on the Store > All Products page show as zero!

This is awful :slight_frown:

  • Tyler Postle
    • Recruit

    Hey Ravanh,

    Very sorry about this, looks like other members are having some issues as well. While we investigate this can you roll back to the last 2.9.x.x version?

    You can do this by deactivating and deleting MP3.0 then downloaidng 2.9.6.2 from your changelog here: https://wpmudev.com/project/e-commerce/

    Once downloaded just upload like any other plugin via: Plugins > Add New.

    We’ll update this thread once we have sorted out the issues.

    Talk to you soon! In the meantime, let us know if you have any further questions.

    Cheers,

    Tyler

  • RavanH
    • The Crimson Coder

    Hi Tyler, yes I reverted to the previous version and to my surprise I did not even have to restore a DB backup. All was working again except I had to reactivate some payment settings…

    Thanks for looking into this.

    To summarize the issues I encountered:

    1. The DB update process took a really short time for such huge shop and even though I got no error, the results where not good. Product prices where changed to zero. This happened on the primary site in a network with over 1700 products. I attempted the DB update procces on two other (much smaller) sites in the network, and it went well there.

    2. The featured image is not moved to the Product Images metabox. Although still available when products are untouched, after editing and saving, the featured image will have disappeared. *

    3. The automatic creation of store pages does not seem to be very adaptive. It simply creates all new pages without taking old settings and existing store pages into account.

    4. All payment/gateway settings on each site in the network and on network level are lost after the upgrade and have to be reconfigured manually.

    5. Store pages like Store Base, Cart and Checkout seem to use the_excerpt() rather than the_content() which results in empty pages. Only the All Products page renders fine.

    6. Product pages also only show an excerpt followed by a read more link which points to itself.

    * Note that the hidden Featured Image metabox can be unhidden by opening Screen Options and unchecking and then checking again the Featured Image option. It then shows the metabox with the original Product Image still configured. However, after saving the product, the featured image has suddenly gone… My solution would be to restore the Featured Image metabox so that authors can keep using it if they only want one product image. If they want more, they can always use the Product Images box to add them.

  • RavanH
    • The Crimson Coder

    UPDATE: I just got an email from MarketPressThemes about their MOJO plugin not being compatible with MP 3.0 yet.

    Since that plugin is used on many of the sites in the network, I’m getting the feeling this might be playing a part in these issues. I did switch that plugin off but that was after the DB updates. Still, only the update on the main site failed even though MOJO was active on the other two as well.

  • Tyler Postle
    • Recruit

    Hey RavanH,

    Yes, that would make sense – although we did have some issues as well. Which we’ve fixed a lot of in the release we pushed out yesterday. Have you updated and are you still experiencing any issues? Aside from possible MOJO conflict. Or you might be waiting until Mojo is compatible? With MP3.0 before updating? If that’s the case just let us know when you do update and if you are still experiencing the issues.

    Talk to you soon!

    Cheers,

    Tyler

  • RavanH
    • The Crimson Coder

    Hi Tyler, I just attempted an upgrade on another network (MOJO not installed there) but it went as bad as on the first one.

    I notice after the upgrade:

    1. All payement information is lost. On the network level this is not a problem (I can enter chained payement details again immediately after the upgrade myself) but each site in the network needs manual intervention from the site admin to configure checkout payment info again. Up to that intervention, I suppose all site shop checkouts are down?

    2. Product prices are dropped to 0 (even after DB upgrade) at least on all the shops in the network I checked.

    3. The fact that 3.0 needs store/product/checkout pages as opposed to 2.9 where these locations where just settings, messes up menu for and checkout for stores that did not have such pages created before.

    4. I’m missing a page where I can put the “order completed” message that was in 2.9

    I’ve reverted to 2.9.6.2 on the second network too :slight_frown:

  • RavanH
    • The Crimson Coder

    And after reverting to 2.9 I notice the confirmation email templates have been lost ! This sucks because they where customized and in French :slight_frown: … Where can I find them again in the DB (stored under the 3.0 settings) so I can copy them manually?

  • Tyler Postle
    • Recruit

    Hey Ravan,

    Sorry about all the issues you’ve been facing here :slight_frown: didn’t end up being the most elegant upgrade. We have another version coming out soon that will fix the pricing issue. I’m confirmed that a lot of the fields don’t seem to save over to MP3.0, I’m flagging the developer here just in-case this hasn’t already been addressed.

    And after reverting to 2.9 I notice the confirmation email templates have been lost ! This sucks because they where customized and in French :slight_frown: … Where can I find them again in the DB (stored under the 3.0 settings) so I can copy them manually?

    Do you have a backup by any chance? The messages would be in mp_settings within the wp_options table.

    A quick way to find stuff in the database is by using a tool such as Adminer: https://wordpress.org/plugins/adminer/

    That allows you to look into your database straight from the WP admin and you can search for a sentence that you knew was in your message, that should bring up the table it is in :slight_smile:

    4. I’m missing a page where I can put the “order completed” message that was in 2.9

    Yes, it goes straight to order status page now to reflect the status there instead of confirmed page. Will that not work for your setup? Perhaps that is something we could add back in later. Especially if other members are wanting it.

    Thanks for all your feedback here Ravan! and for your patience while we sort this out. Any further questions just let me know.

    Cheers,

    Tyler

  • RavanH
    • The Crimson Coder

    Hi @Tyler thanks for getting back to me :slight_smile: … I’ve found the old e-mail templates in the database so I’m happily back on 2.9.

    Do you know for which version the improvements / fixes will be planned? I’ll remain on 2.9 for now specially on that site with 1,765 products…

    Yes, it goes straight to order status page now to reflect the status there instead of confirmed page.

    Good to know. It should be fine, I think…

  • Tyler Postle
    • Recruit

    Hey Ravan,

    No problem, happy to help – glad you were able to find those in the database :slight_smile:

    We have a big update that is due out today. It should resolve many, if not all of the outstanding issues from what I am told. However, I would highly recommend doing a full back up first or copying your site to a dev install and do the upgrade their first – just to avoid any messes on your live site in-case they do happen.

    A plugin I’ve found that works really well for copying a site from one install to another is this one: https://github.com/wp-sync-db/wp-sync-db

    add-on incase you want to include the media libraries too: https://github.com/wp-sync-db/wp-sync-db-media-files

    Let me know if you have any further questions.

    All the best,

    Tyler

  • RavanH
    • The Crimson Coder

    Hmmm… still a big mess :slight_frown:

    Just upgraded to 3.0.3 on a network with only one active store plus a global marketplace on the front site. I get both on the main site and on the active store site after hitting the “Perform Update” button on the mp-db-update page a blank screen with {"success":false}

    When I try to the Quick Setup wizard, I get a 404 page on an URL like http://sub.my-netwo.rk/wp-admin/store-setup-wizard Other admin pages have similar ‘pretty’ URLs that do not go anywhere.

    I can see products on the Shop > Products page but again all are now at a price of 0 and on the front-end shop page, the product images are gone.

    Reverting to 2.9 again :slight_frown:

  • Tyler Postle
    • Recruit

    Hey Ravan,

    I’ve asked our MP developer about this and he’s thinking there is something else wrong with your setup here. Would you be able to send in your cPanel? Then we can create a staging version of your site to test on. That way we don’t need to make any changes to your live site.

    You can send that privately through our contact form: https://wpmudev.com/contact/

    Select “I have a different question” for your topic – this and the subject line ensure that it gets assigned to me :slight_smile:

    Send in:

    Subject: “Attn: Tyler Postle

    -cpanel username

    -cpanel password

    -login url

    -link back to this thread for reference

    -any other relevant urls

    **can you grant support access again as well? We won’t make any changes to your live site but just to make sure it matches.

    You can grant support access via WPMU DEV > Support > Support Access > Grant Access.

    Talk to you soon! Cheers

  • RavanH
    • The Crimson Coder

    Hi Tyler, your help is much appreciated! The thing is that this is on a VPS with a lean Nginx setup. No Cpanel or similar so I cannot give you such access. Support access of course, no problem…

    Snapshot is installed. Could you use that to create a copy of the main network site + the one (small) site running MartketPress?

  • Tyler Postle
    • Recruit

    Hey Ravan,

    No problem, I can try using a snapshot and see how that goes :slight_smile: which subsite should I be snapshoting? or if you already have the snapshots created then just let me know which ones they are and I’ll login and download them. Make sure support access is re-granted as well.

    Talk to you soon!

    Cheers,

    Tyler

  • RavanH
    • The Crimson Coder

    Hi Tyler, I recently tried the 3.0.0.5 upgrade on that smaller shop site and this time all prices, stock and featured images seem to have taken correctly. Only most of the general shop settings (checkout methods, shipping calculation table) had to be reconfigured but that was doable…

    I’ll attempt another upgrade to the latest 3.0.0.6 on that large shop with 1700+ products and let you know. If it still goes wrong, I’ll revert and grant access so you can take a look.

    Or do you want access beforehand? Snapshot is installed there too and you can take a zip for local copy. Only the media library is too large for Snapshot there (timeout during zipping) but I suppose that should not be a problem. Let me know :slight_smile: