Sharetribe v10.0.0 Release NotesRelease Date: 2020-05-10 // over 1 year ago
- 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
- ⬆️ Go no longer uses Harmony for availability management. Functionality is now implemented fully in Go. See the upgrade instructions. #4020, #4037, #4043, #4048, #4071
- Copy texts for admin email notification of new entry in Contact form #4077
- 🛠 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
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.