Smart relationships broken after v7 update

This is a template you can use to report issues. You can also drag images, videos and include Preformatted text

Expected behavior

Hello :slight_smile:
My smart relationships are working in Dev environment but nothing is shown in production environment
one example ( but all our smart relationships are broken )
The first screen is from my dev Env


The second one from the exact same order in production environment

The exact same code is running on both environment

Any clue ? :thinking:

Actual behavior

What is the current behavior?

Failure Logs

Please include any relevant log snippets, if necessary.

Context

Please provide any relevant information about your setup.

  • Package Version: ^7.8.3
  • Express Version: ^5.3.3
  • Sequelize Version:
  • Database Dialect: Mongo
  • Database Version:
  • Project Name: Panopli

Hello @Tom,

Thank you for reporting this issue.

Just to start with the obvious:

  • is the forest-express-mongoose version exactly the same on both environments?
  • is the database used the same?
  • do you have any error message in the browser window?
  • do you have any (error) message in the forest agent terminal / log?

Also, did you update from an early v7 version, or from some v6 version?

And last, can you share the code for your smart collection?

Thank you

Hello @Guillaume_Deslandes,

  • is the forest-express-mongoose version exactly the same on both environments?
    Yes
  • is the database used the same?
    Yes
  • do you have any error message in the browser window?
    No
  • do you have any (error) message in the forest agent terminal / log?
    No

Actually my ticket message is wrong , all our relationships are gone in production ( smart or not ), i took this one as example
We update from v5 actually ( v5 → v6 → v7 )

@Tom,

From the screenshot, you are trying to see related data from a record.

Are you able to access your collections from the “data” tab and list records from there?

If you have a look at the Forest agent log, you can see what requests are received, this may help.
Also, if you start the Forest agent with DEBUG=* npm start it will get very verbose, but you might notice something in the logs or queries displayed when accessing the related data.

Yes the screenshot is a related data . I can normally access all my datas from the “data” tab, but all related Datas return the “there are no collectionName yet” . I will start the forest agent with DEBUG=* and check if i can spot anything .

I cannot spot anything suspicious in local ( but it’s working fine anyway ) .
I tried to apply the DEBUG=* to my deployed version but i’m struggling .
Anyway it’s quite hard to debug as i cannot reproduce it locally.

When i try to access to a related data i get a

Request URL: https://app.forestadmin.com/lottie-animations/error_no_match-0d24bc6bf4da03f98bad258a8c63d5e7.json
Request Method: GET
Status Code: 200 OK (from disk cache)
Remote Address: 54.216.252.255:443
Referrer Policy: strict-origin-when-cross-origin
Cache-Control: public, max-age=15552000
Content-Encoding: gzip
Content-Type: application/json
Date: Tue, 03 Aug 2021 10:32:31 GMT
Etag: W/"6107b310-13b1d"
Last-Modified: Mon, 02 Aug 2021 08:55:44 GMT
Server: nginx
Vary: Accept-Encoding
Via: 1.1 vegur
Referer: https://app.forestadmin.com/Panopli/Preproduction/All%20Panopli/data/1524369/index/record/1524369/5e68be3eaeb81243b7d1b77e/has-many/eccb0e23-344c-11e9-9d6d-f72a3fe7e6da
sec-ch-ua: "Chromium";v="92", " Not A;Brand";v="99", "Google Chrome";v="92"
sec-ch-ua-mobile: ?0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36

localy i can access my ressource

Request URL: http://localhost:3000/forest/Shops/5e68be3eaeb81243b7d1b77e/relationships/orders?timezone=Europe%2FParis&fields%5BOrders%5D=lead%20Time%2Cpaid_amount%2Cclient_name%2Cclient_email%2CInclude%20PreOrder%2C_id%2CautoValidated%2Cbypass_regrouped%2CcreatedAt%2CcustomerOrderId%2CgiftOrder%2ChasRegroupedLinkedTo%2CinternalOrder%2ClateEmailSent%2CreSent%2CreSent_id%2Cregrouped%2Csav%2Csav_tags%2Cseller%2Cseller_email%2Cseller_logo%2Cseller_name%2Cseller_url%2CshippingPrice%2Cshipping_frequency%2Cstatus%2CstatusLinkedTo%2CSupplier%20Response%2CupdatedAt%2Cimportant&page%5Bnumber%5D=1&page%5Bsize%5D=20&sort=-createdAt
Request Method: GET
Status Code: 200 OK
Remote Address: [::1]:3000
Referrer Policy: strict-origin-when-cross-origin
Access-Control-Allow-Credentials: true
Access-Control-Allow-Origin: https://app.forestadmin.com
Connection: keep-alive
Content-Length: 289065
Content-Type: application/json; charset=utf-8
Date: Thu, 05 Aug 2021 09:21:33 GMT
ETag: W/"46929-LD9N9SCSSOxnx8LmdnUICBvHFSc"
Vary: Origin
X-Powered-By: Express
Accept: application/json
Accept-Encoding: gzip, deflate, br
Accept-Language: fr-FR,fr;q=0.9,en-US;q=0.8,en;q=0.7
Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjE4MDI0IiwiZW1haWwiOiJ0aG9tYXNAcGFub3BsaS5jbyIsImZpcnN0TmFtZSI6IlRob21hcyIsImxhc3ROYW1lIjoiTWV1bmllciIsInRlYW0iOiJBbGwgUGFub3BsaSIsInJlbmRlcmluZ0lkIjo0NTk1MiwiaWF0IjoxNjI4MTU1MjM2LCJleHAiOjE2MjgxNTg4MzZ9.VagCmcyzMXtDG9wvrLNHka411zddXzss2N5UQ8Sh9Uo
Connection: keep-alive
Content-Type: application/json
Host: localhost:3000
Origin: https://app.forestadmin.com
sec-ch-ua: "Chromium";v="92", " Not A;Brand";v="99", "Google Chrome";v="92"
sec-ch-ua-mobile: ?0
Sec-Fetch-Dest: empty
Sec-Fetch-Mode: cors
Sec-Fetch-Site: cross-site
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36
timezone: Europe%2FParis
fields%5BOrders%5D: lead%20Time%2Cpaid_amount%2Cclient_name%2Cclient_email%2CInclude%20PreOrder%2C_id%2CautoValidated%2Cbypass_regrouped%2CcreatedAt%2CcustomerOrderId%2CgiftOrder%2ChasRegroupedLinkedTo%2CinternalOrder%2ClateEmailSent%2CreSent%2CreSent_id%2Cregrouped%2Csav%2Csav_tags%2Cseller%2Cseller_email%2Cseller_logo%2Cseller_name%2Cseller_url%2CshippingPrice%2Cshipping_frequency%2Cstatus%2CstatusLinkedTo%2CSupplier%20Response%2CupdatedAt%2Cimportant
page%5Bnumber%5D: 1
page%5Bsize%5D: 20
sort: -createdAt

actually same as

removing the ^ from the install to forced 7.8.3 install worked for me