Wishlist problem in front and backend

-- url of the page with the problem -- : www.dekreij.nl/horeca/account/cart/showcarts/cart_type-wishlist
-- HikaShop version -- : 4.2.2
-- Joomla version -- : 3.9.12
-- PHP version -- : 7.3
-- Browser(s) name and version -- : all
-- Error-message(debug-mod must be tuned on) -- : 500




In front and backend we have a problem with the wishlist. In the front we get a 500-error.
You van test with user: 12058 password: Oosterland

In the backen: see attachment.

Can you help us?

Jan

Hi,

This indicates that you have a fatal error during the processing of the page.
Please turn on the "error reporting" and "debug mode" settings of the Joomla configuration and try again.
You should then get an error message on that white page which will indicate where the problem is coming from.
Please provide that error message.

This is the error on the frontpage:

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in /home/dekreij/domains/dekreij.nl/public_html/horeca/libraries/joomla/database/driver/mysqli.php on line 891

This is the backend error:
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in /home/dekreij/domains/dekreij.nl/public_html/horeca/libraries/joomla/database/driver/mysqli.php on line 891

Jan

Hi,

This error indicates that the page is trying to load too much data from the database.
I suppose that you must have changed the number of elements listed by default on the listing.
For each cart / wishlist, HikaShop has to load the full cart/wishlist (all the products, the prices, the discounts, the addresses, the shipping methods, the payment methods, etc. With 20 carts, which is the default number of elements displayed per page, it works fine.
But for 500 carts (or another big number) to be loaded on the same page, that's bound to have the page crash.
So I would recommend to check on that.
Unfortunately, there is not much we can do to avoid this.

Where can I change the number of elements listed by default on the listing?

I did it in the Joomla defaults, but that isn't working.

Jan

Hi,

It's indeed in the Joomla defaults.
However, once you display the listing page once, even if it crashes, it is stored in your user session.
So you need to log out and log in to see the change.

No difference.
Problem is still there

You want to login? Or get an Akeeba backup?

Jan

Hi,

Sure we can do that.
Please provide a backend and a FTP access along with a link to this thread via our contact form and we'll be able to look into it:
www.hikashop.com/support/contact-us.html