Sharetribe v10.0.0 Release Notes

Release Date: 2020-05-10 // over 1 year ago
  • โž• Added

    • Fuzzy location #4035
    • ๐Ÿ‘ Stripe support for Czech Republic #4049, #4069
    • ๐Ÿ‘ Allow admin to edit the button in Hero section #4051
    • ๐Ÿ‘ Stripe support for Romania #4066

    ๐Ÿ”„ Changed

    ๐Ÿ›  Fixed

    • ๐Ÿ›  Fixed inbox doesn't consider commission status #4044
    • ๐Ÿ›  Fixed encoding issue with PayPal #4045
    • ๐Ÿ›  Fixed missing listing image in community updates email #4046
    • ๐Ÿ›  Fixed scope of transations for testimonials to support Disputed #4063

    โฌ†๏ธ Upgrade from 9.1.0 to 10.0.0

    ๐Ÿ”ง If you are not using Harmony for availability
    โšก๏ธ management, there is nothing special. See the General update
    โšก๏ธ instructions
    .

    Otherwise, follow the instructions below.

    Migrate Harmony data to Go

    ๐Ÿš€ With this release, Go no longer uses Harmony as
    backend for day- and night-based availability management. The functionality is
    completely implemented within Go (there is no change in user-facing features).
    However, this requires that some data from Harmony is migrated to Go's database.

    โšก๏ธ Start by following the General update
    โšก๏ธ instructions
    , which will migrate the Go
    โœ… database to the latest version.

    Backup also your Harmony database.

    โš™ Run the following SQL queries to copy data over. The queries assume you are
    0๏ธโƒฃ using the default production database names for both Go
    (sharetribe_production) and Harmony (harmony_production_db). If that's
    not the case, replace the database names accordingly.

    INSERT INTO sharetribe\_production.listing\_blocked\_dates (listing\_id, blocked\_at, created\_at, updated\_at) SELECTl.id, e.start, e.created\_at, e.updated\_atFROM harmony\_production\_db.exceptions e LEFT JOIN harmony\_production\_db.bookables b ON e.bookable\_id = b.idLEFT JOIN sharetribe\_production.listings l ON b.ref\_id = l.uuidLEFT JOIN sharetribe\_production.listing\_blocked\_dates bd ON bd.listing\_id = l.id AND bd.blocked\_at = e.startWHEREe.deleted \<\> 1AND l.id IS NOT NULLAND e.start \>= curdate() AND bd.id IS NULLGROUP BY e.id ;-- delete blocked dates that are deleted in Harmony but present in Go-- needs temporary tableCREATE TABLE sharetribe\_production.tmp LIKE sharetribe\_production.listing\_blocked\_dates;INSERT INTO sharetribe\_production.tmpSELECT sharetribe\_production.listing\_blocked\_dates.\*FROM sharetribe\_production.listing\_blocked\_dates;CREATE TABLE sharetribe\_production.tmp2 (id int(11) NOT NULL, PRIMARY KEY (id));INSERT INTO sharetribe\_production.tmp2 ( SELECT distinct(bd.id) FROM harmony\_production\_db.exceptions e INNER JOIN ( SELECT e.id, e.bookable\_id, start, max(updated\_at) AS max\_updated\_at FROM harmony\_production\_db.exceptions e GROUP BY e.bookable\_id, e.start ) e2 ON e.id = e2.id AND e.updated\_at = e2.max\_updated\_atLEFT JOIN harmony\_production\_db.bookables b ON e.bookable\_id = b.idLEFT JOIN sharetribe\_production.listings l ON b.ref\_id = l.uuidLEFT JOIN sharetribe\_production.tmp bd ON bd.listing\_id = l.id AND bd.blocked\_at = e.startWHEREe.deleted = 1AND l.id IS NOT NULLAND e.start \>= curdate() AND bd.id IS NOT NULLGROUP BY e.id);DELETE FROM sharetribe\_production.listing\_blocked\_dates WHERE id IN ( SELECT id FROM sharetribe\_production.tmp2);DROP TABLE sharetribe\_production.tmp;DROP TABLE sharetribe\_production.tmp2;
    

    You can now bring Go back up.

    ๐Ÿšš After the migration you can delete Harmony's database and remove the Harmony
    service altogether from your system.