app data not loading

[stable urchin]

Hey There,

We've registered your query, and our team will get back to you soon.

Regards,
Pranav

[stable urchin]

@tall jetty Zoom will allow them to screen share, and you can request
remote control to debug from their machine. If you need to use your Appsmith
account you can open a private browsing window on their machine. An alternative
here would be a tool like TeamViewer.

Thank you for your ongoing support and patience. We aim to provide you with
helpful assistance and hope we have addressed your question adequately.

Please take a moment to share your experience with our support team.
https://survey.frontapp.com/v2/09a400bf433bc9676d67/4fde2a29ca0b44d78c5fb6fe74deb837

[tall jetty]

@stable urchin
Im familiar with this aspect
What Im not sure about is what areas to check to see why the the information form the DB is not getting through to populate the App

[tall jetty]

@stable urchin I have found that the issue seems to be wider spread than my customer

I set up a log in page based on the video - https://www.youtube.com/watch?v=5oPcF9dXZyU

It has been working without issue until recently. Im not sure if the recent update maybe had an impact on it in some way?

It seems to work fine on my computer when I use chrome.

however, if I use Edge it doesnt work or if I try to use my mobile it doesnt work either.

[tall jetty]

This video shows the problem I am experiencing.
The first window works fine - Chrome
The second doesnt work - Edge
I am having the same problem on my phone on both chrome and Samsung Internet

You will see that on edje, there is no error message that appears.
If the login details are incorrect, there should be an error - showAlert('Incorrect Login details');

[stable urchin]

I've asked the team about this behavior change and forwarded the information to
them.

[tall jetty]

@stable urchin, the app loads and seems to work. the issue seems to be connecting with the database.
I am thinking that it might be something to do with my JS but not sure.
It seemed to work fine up until the recent update

Am I able to export the app and send it to you to have a look at?

[tall jetty]

@stable urchin Even if the input fields are empty, it acts in the same way

It should present an error telling me Incorrect login details but nothing happens

It looks as though there is an issue with the button click conneting with the database

The Code I am using is:

export default {
  saveLogin: async () => {
    await portalUsers.run();
    await storeValue('useremail', portalUsers.data[0]).then(async () => {
      var pswrd = "randomString" + passwordEnter.text + "randomString";
      await storeValue('login', { "hash": sha512(pswrd) }).then(async () => {
        await hash.run();
        await storeValue('userdata', hash.data[0]);
        if (appsmith.store.userdata && appsmith.store.userdata.userPassword === appsmith.store.login.hash) {
          await navigateTo('Job Record');
        } else {
          showAlert('Incorrect Login details');
        }
      });
    });
  },
};

Then the queries Mentioned

portalUsers.run()

SELECT email FROM DB where email = {{username.text}}

hash.run()

select * from DB where email = {{username.text}} AND jwt = PASSWORD({{appsmith.store.login.hash}})

[tall jetty]

Could this error from Console be relevant

WebSocket connection to 'wss://sub.domain.co.uk/rts/?EIO=4&transport=websocket' failed:    websocket.js:54
value    @    websocket.js:54
value    @    transport.js:49
value    @    socket.js:162
n    @    socket.js:103
value    @    manager.js:108
(anonymous)    @    manager.js:328

[tall jetty]

@stable urchin is there anything I should do to figure out the problem?

Has there been any similar issues since the last update?

[vital hare]

Hello @tall jetty ,
I haven't encountered this issue, and I aslo don't recall any user reporting a similar issue.

Are you still facing this issue?

[tall jetty]

@vital hare I can't find the message but one of your team told me to toggle the make app public switch off then back on and this seemed to sort the problem