Hello support,
I have faced a problem, while before I might not noticed. I have transfer banch of items from my WH2 (warehouse Block) to WH1(showroom) -->> we can see list of items in the transfer module but when we go to item >> Detail page >> transfer ( we did not see any record there).
I have just seen this because I tried to correct my stock many times but not correct then I tried to look for each individual module then I saw this error it gives me a blind spot.
so please see my attached screenshot for reference.
Please help.
- MSAnswered
Hello,
I checked it locally, it is displying the transfer. It might be due to volumn or some relational data. May I know your version number?
Please let me know the site link with owner account details in private reply.
Thank you
- MSAnswered
Hello,
Please edit
app/controllers/admin/Reports.phpand change the line no 2533 & 2534 from->from('transfer_items') ->join('transfers', 'transfer_items.transfer_id=transfers.id', 'left')to
->from('transfers') ->join('transfer_items', 'transfer_items.transfer_id=transfers.id', 'left')This should resolve the listing issue.
Thank you
- PVAnswered
Great,
Thank you very much
- SKAnswered
I got exactly the same problem on version 3.4.53. I redownload the project source code from codecanyon and I do a fresh install (both database and code) but it still have problem.
- SKAnswered
Prom Vongchann Please share your solutions
- MSAnswered
Seng Kruy Please try the solution in this reply. Thank
- PVAnswered
Seng Kruy Hello bong,
I got it work by modify the query in app/controllers/admin/Reports.php
you can follow the guide above.
- PVAnswered
Mian Saleem it seems to me like the data loading is quite slower than before after I update the query on the Transfer in product detail.
would you have any suggestion?
Thank you
- MSAnswered
Hello,
I am not sure. Please let me know your server details in private reply, I will check.
Thank you
- PVAnswered
Mian Saleem I used Hostinger SSD cloud and it was working OK before I update the query. but seems like the query changed the website perfomance.
- Login to Reply