« Changelog History


Sharetribe v10.0.0 Release Notes

Release Date: 2020-05-10 // almost 4 years 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.