Recovery Mode

I had a user that found a bug in my app that tried to update 2 tables through a view. The user didn’t notice that his changes kept piling up over the few hrs he was working. I was wondering if Recovery Mode would allow me to get his changes even though the description in appsheet article doesn’t specifically mention this as a way to get the changes from this kind of error.

0 2 465
2 REPLIES 2

Hi @Austin_Lambeth! We have two follow up questions for you:

  1. What was the error that was received?
  2. Did the changes made go through to the data on the data on the backend?

1.Unable to add/edit/delete row in table ‘AppSheetView’. → One or more SQL errors has been encountered: One or more SQL errors has been encountered:\nThe insert/update operation to your MySQL join view will modify more than one MySQL base table. Please ask your database administrator to troubleshoot this problem.\nOriginal error message from the database: Can not modify more than one base table through a join view ‘Appsheet.AppSheetView’
2. No

Top Labels in this Space