Products not showing in backend

-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.7.4
-- PHP version -- : 7.022

After updating hikashop to latest version this morning, I now found that in the backend my products no longer show.

When clicking on Modules --> Hikashop --> Products (or any other link that should get me into the products page in the backend), the page takes a while to load (on the server mysqld is 100% cpu consuming), and finally just shows me a text bases page with the menu itens for hikashop.
(See attachement)
When clicking on add new product, or any other link, all is just fine.

Please do note that I have over 32.000 articles in the shop, but this didn't happen under the 2.6 version of hikashop.(And I believe under 3.0.4 it functioned correctly as well)

When enabling debugging, no information is added to the end of the page...

Hi Jerome,
had to play around with getting errors to show, but finally got some .....

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgSystemOfflajnJoomla3compat has a deprecated constructor in /var/www/vhosts/1stopmotoronderdelen.nl/httpdocs/plugins/system/offlajnjoomla3compat/offlajnjoomla3compat.php on line 83

Disabled that plugin, but the page still shows the same, but without any errors....

I understand that some error must be occuring somewhere, but no php errors are showing.

I played around some more in my test environment, and also turned on debugging.
When opening the page, the same result (like the screenshot) and no debugging information is posted either.

I now clicked on add a new product, was able to fill in the detailse, pressed save-and-close (which brings it back to the product page) and got following error :

Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 454656 bytes) in /var/www/vhosts/1stopmotoronderdelen.nl/test.1stopmotoronderdelen.nl/plugins/system/debug/debug.php on line 1167

Turned off the debugging, went to products and still the same as in the screenshot.
Added a new product, saved and closed, and now the lists shows correctly !!
Clicked on 'brand' for products in there, and the page is like the screenshot again.
Added a new product, saved & closed, and the list of 'brand' shows correctly.
Clicked on page 2, and again the page shows like the screenshot
Added a new product, saved&closed, and the 2nd page is shown correctly
If I open a prodcut, and press cancel, the product page shows as the screenshot

So it is only after saving&closing a new product that the page comes back to the last clicked product page.....

Any ideas ??

I have full control over the server. Rebooted it last night just to make sure.
I had increased memory ass well, because I was thinking in the same direction, but even 4GB does not help.
And the strange thing is, that still absolutely no error is being reported
I do see errors being shown in the front-end, but not in back-end...

Even added error reporting lines to index.php for the administrator, but again no errors show in the backend.

Enabled slow_query_log, and that shows the query in question takes 16-17 seconds to execute, so also well within my set limits for scritps running (60 s).

NOTE: a similar query in de front-end takes 10 secons, and shows the products page with pagination and so forth.

Any thoughts are still welcome while I try and figure out how to get the error reporting going.

I have tried both direct url's you mentioned, and both times the page is displayed as in the screenshot ..... grrrrr......

What I do notice is that it takes a relative long time to display that page compared to when I save&close a new product. It almost displays instantly after pressing save&close on a new product.
Is there a different query/call used after save&close compared to clicking on the products link ?
BTW: when I cancel the addition of a new product, It also displays the page like in the screenshot.....

I added the slow query as being executed when clicking on products in the backend....

PS: still looking into the showing of errors, as I agree that one would expect one to be displayed. But I even tested by creating an error myself by editing the index.php file, and that just shows fine....

The entry was already in my database with a value of 1.
Changed it to 0, but the behaviour is still the same unfortunately.....

Hi Nicolas,

the problem is, that there are no errors being logged anywhere when I open that page.
If I force an error (eg changing something in the index.php) I do get that error, but when accessing the product page no error is shown, nor written to any of the log files.....
When enabling debugging, that is not shown either, but that would come after the page loaded anyway so it is to be expected that it will not show...

The issue occurs in my test environment as well, so if I need to add some code or 'echo' lines somewhere to get more information, that is no problem.

One other behaviour I have now noticed.....

When adding a new product, and pressing save&close I already stated that I do get the list of products, but I didn't notice that it is the product list for that specific category. I'm missing the side menu (The explorer as I can see in another site still running hikashop 2.6.0)

And I do now notice that I'm missing the explorer also when opening the categories .......

Also re-installed the full hikashop product, even after removing the /components/com_hikashop and /administrator/components/com_hikashop directories....

Jerome wrote: Hello,

Regarding your previous screenshot, I don't see how you cannot have a PHP error :
https://www.hikashop.com/media/kunena/attachments/39940/Hikashop-products-backend.png
The simple fact that you see the HikaShop menu indicates that HikaShop start the process of the page and something make it stop ; and it's not a common error otherwise it would have been handle by the exception system and you would have the Joomla error page.

You should try to call the product listing with:

/administrator/index.php?option=com_hikashop&ctrl=product&filter_type=0

So you will force the "direct sub element" display instead of "inherit" which is "all sub elements" (and require more server resources).
You can even try

/administrator/index.php?option=com_hikashop&ctrl=product&filter_type=0&filter_product_type=main&limit=20

To be sure that variants won't be loaded and that the pagination is right set on 20 elements.

Regards,

I have the same problem. Thank for your sharing to help us solve it!

I just created a new subdomain, installed joomla latest version and hikashop.
All shows just fine.

Then exported all the hikashop_ tables from the test site, imported those into the new site (using sqldump and mysql).
Opened the categories section of hikashop, and the Explorer screen is not showing.
The products screen has the same issue as when I started this thread

So.... somewhere in the database of the hikashop categories/products or perhaps settings something is wrong causing the explorer not to show, and the products page to display incorrectly (Which I start to feel is initially caused by the issue that the explorer is not showing ...)

Again, NO ERRORS are shown or logged anywhere

Partial succes.......

When I import a clean hikashop_config table, the display of the explorer is correct.
When I change the category_explorer to 0 (Default = 1) (As suggested earlier in the thread), the explorer does not show anymore !!!!!!

Still, in any case, the products are listing as shown I my first post......

So, the category_explorer value is for turning on/off the explorer field, and is not changing the behaviour of showing the products themselves.

So still my initial issue remains

I restored the an earlier hikashop site (2.6.0) into the test environment. (Didn't have a clean 2.6 install package available)
The version still shows 3.1.1, but I know for sure that the software is at the lower release !!

The product page is now showing correctly

Installed Hikashop 3.0.1, which I still had available as installable package.

Definately something wrong as of version 3 (at least).
(Obviously, updating to 3.1.1 does not change the behaviour)

Hi,
moved the upload folder to upload.orig, but the behaviour did not change. (Actually it was media/images/com_hikashop/upload in my case)

If it is something in the data, why doesn't it have the problem with version 2.7 which has the same data ?