search

konkodi210 / sampratistaana

MIT License
3 stars 0 forks source link

Blank screen when clicking “Pusthaka Maaraata” #39

Closed mohankmithur closed 3 years ago

mohankmithur commented 3 years ago

I think I added two book sales and again went to that screen and deleted first entry to check if it gets reflected in “kharchu veccha varadi”. It did reflect in that screen, however, I am not able to see the book sale screen again. When I select, blank screen is displayed.

konkodi210 commented 3 years ago

I am not able to reproduce this bug. Can you please give exact reproducible steps?..

if it happens consistently for you, please share the sqlite file from your system (it will be in user.home/sampratistaana.sqlite)

murarisharma31 commented 3 years ago

@mohankmithur , I tried the same but no issues found. Pls recheck and let's know

konkodi210 commented 3 years ago

Most likely database file corrupted. If so it should be bug. Please share the dB file . Let me try to use and reproduce the bug

mohankmithur commented 3 years ago

I did not find the same issue in another system. With this db, I am able to reproduce. Most probable reason could that I have generated a book sale for particular book and then deleted that book from maintenance page and then came back book sale screen.

I tried to repeat above scenario with fresh db, I did not see same problem, but as expected, the sold book name field was empty in book sale page for those deleted books.

Screen recording when the issue happened: https://user-images.githubusercontent.com/5713874/104149503-6669b600-53fc-11eb-90ce-18dc4bd21fcb.mp4

Error log seen in console when we click on "book sale" button: ErrorLog.txt

DB to reproduce the issue: db_sampratistana.zip

konkodi210 commented 3 years ago

I got the issue. In Book Sale table, it just went with customer name. There is no Ledger entry at all.

Now problem is I am not able to explain why it happened. Let me put some restriction for bad record. This should solve the problem

konkodi210 commented 3 years ago

Added Inner join with Ledger and Inventory such that bad records will be filtered.

This is workaround. We should not get bad record in first place. We need to monitor this. If this happens in other place,. we should investigate why it happens.

murarisharma31 commented 3 years ago

@mohankmithur @anoochana .. Pls retest in the new build (1/12) and let's know.

mohankmithur commented 3 years ago

Issue is fixed in 12Jan Version.