[Skip to main content](#vessel-content)

#   Products not showing in backend

##

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 3 months ago [\#276018](#276018) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276018 "-- 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 --&gt; Hikashop --&gt; 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...")* was created by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")*

-- 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 --&gt; Hikashop --&gt; 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...

- [ ![Hikashop-products-backend.png](/forum/attachment/39747) ](/forum/attachment/39747 "...ts-backend.png") [ ](/forum/attachment/39747?download=1 "...ts-backend.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

9 years 3 months ago [\#276021](#276021) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276021 "-- 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 --&gt; Hikashop --&gt; 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...")*

Hello,

You got a PHP Fatal error in your page ; you should check your PHP error log or set the "error reporting level" to "maximum" in your Joomla global configuration.
Thanks to the error message, we will be able to know more about the issue.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 3 months ago [\#276068](#276068) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276068 "-- 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 --&gt; Hikashop --&gt; 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....

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

9 years 3 months ago [\#276069](#276069) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276069 "-- 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 --&gt; Hikashop --&gt; 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...")*

Hello,

If you still have a page like the one in your screenshot ; you have a PHP Fatal error.
The other solution would be a PHP "exit;" within the code, but I doubt about it.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 3 months ago [\#276136](#276136) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276136 "-- 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 --&gt; Hikashop --&gt; 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...")*

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 &amp; 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&amp;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&amp;closing a new product that the page comes back to the last clicked product page.....

Any ideas ??

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

9 years 2 months ago [\#276147](#276147) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276147 "-- 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 --&gt; Hikashop --&gt; 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...")*

Hello,

Basically, it looks like a memory limit issue.
But if you can't take a look at your PHP error log ; you can't be sure.
You should really try to access to that log file or contact your web hosting for more details.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 2 months ago [\#276196](#276196) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276196 "-- 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 --&gt; Hikashop --&gt; 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...")*

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 ![:(](/media/kunena/emoticons/22.png ":(")
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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

9 years 2 months ago [\#276235](#276235) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276235 "-- 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 --&gt; Hikashop --&gt; 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...")*

Hello,

Regarding your previous screenshot, I don't see how you cannot have a PHP error :
[ www.hikashop.com/media/kunena/attachment...products-backend.png](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: Code:

/administrator/index.php?option=com_hikashop&amp;ctrl=product&amp;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 Code:

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

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

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 2 months ago [\#276255](#276255) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276255 "-- 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 --&gt; Hikashop --&gt; 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...")*

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&amp;close a new product. It almost displays instantly after pressing save&amp;close on a new product.
Is there a different query/call used after save&amp;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....  *This attachment is hidden for guests.
Please log in or register to see it.*

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

9 years 2 months ago [\#276264](#276264) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276264 "-- 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 --&gt; Hikashop --&gt; 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...")*

Hello,

You should deactivate the display of the category explorer.
It is an hidden feature in HikaShop ; you need to add the entry in your hikashop_config table. Code:

config_namekey = category_explorer config_value = 0

Thanks to that, HIkaShop won't try to load a huge data of your categories in the backend product listing page.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 2 months ago [\#276282](#276282) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276282 "-- 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 --&gt; Hikashop --&gt; 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...")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

9 years 2 months ago [\#276354](#276354) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276354 "-- 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 --&gt; Hikashop --&gt; 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,

Then the problem is elsewhere.
As Jerome said repeatedly, the best would be to look in the php error log file of your server.
In your messages you don't mention looking there as far as I can see.
The fatal error message should be in there even if it isn't output on the page (based on how your server is configured, even if you activate the error reporting of Joomla, it's possible that the server doesn't output it but only logs it in its logs).

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 2 months ago [\#276366](#276366) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276366 "-- 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 --&gt; Hikashop --&gt; 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 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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 2 months ago -  9 years 2 months ago [\#276367](#276367) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276367 "-- 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 --&gt; Hikashop --&gt; 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...")*

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

When adding a new product, and pressing save&amp;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....

- [ ![Hikashop-product-backend-aftersave.png](/forum/attachment/39830) ](/forum/attachment/39830 "...-aftersave.png") [ ](/forum/attachment/39830?download=1 "...-aftersave.png")

Last edit: 9 years 2 months ago by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile"). Reason: found some other strange views....

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jane262](/forum/user/52102-jane262 "View Jane262's Profile")**
- [![Jane262's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/52102-jane262 "View Jane262's Profile")
- [ Offline](/forum/user/52102-jane262)

Less More

- Posts: 1
- Thank you received: 0
-
-

9 years 2 months ago [\#276370](#276370) by [Jane262](/forum/user/52102-jane262 "View Jane262's Profile")  Replied by *[Jane262](/forum/user/52102-jane262 "View Jane262's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276370 "-- 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 --&gt; Hikashop --&gt; 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...")*

> Jerome wrote: Hello,
>
> Regarding your previous screenshot, I don't see how you cannot have a PHP error :
> [ ](http://appnaz.com/android/remita-com.systemspecs.remitamobile)[ www.hikashop.com/media/kunena/attachment...products-backend.png](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:
>
> Code:
>
> /administrator/index.php?option=com_hikashop&amp;ctrl=product&amp;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 Code:
>
> /administrator/index.php?option=com_hikashop&amp;ctrl=product&amp;filter_type=0&amp;filter_product_type=main&amp;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!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 2 months ago [\#276624](#276624) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276624 "-- 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 --&gt; Hikashop --&gt; 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...")*

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 ![:(](/media/kunena/emoticons/22.png ":(")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 2 months ago [\#276628](#276628) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276628 "-- 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 --&gt; Hikashop --&gt; 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...")*

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 ![:(](/media/kunena/emoticons/22.png ":(")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 2 months ago [\#276709](#276709) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276709 "-- 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 --&gt; Hikashop --&gt; 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...")*

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)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

9 years 2 months ago [\#276742](#276742) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276742 "-- 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 --&gt; Hikashop --&gt; 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,

So from what I understand, the problem appears because of something in the database but not in the hikashop_config table.
This points to a problem with the data of at least one product or category.
I'm thinking that it might be linked to one of the images (or several of them), which are not valid (wrong format, or really big, etc).
What if you rename the /images/com_hikashop/upload folder to something else temporarily to deactivate all the images of HikaShop.
Does it allows the listing page to display properly ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")**
- [![storeitonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39940-storeitonline "View storeitonline's Profile") Topic Author
- [ Offline](/forum/user/39940-storeitonline)

Less More

- Posts: 62
- Thank you received: 3
-
-

9 years 2 months ago [\#276770](#276770) by [storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")  Replied by *[storeitonline](/forum/user/39940-storeitonline "View storeitonline's Profile")* on topic *[Products not showing in backend](/forum/26-product-category-display/891533-products-not-showing-in-backend#276770 "-- 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 --&gt; Hikashop --&gt; 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,
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 ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84OTE1MzMtcHJvZHVjdHMtbm90LXNob3dpbmctaW4tYmFja2VuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.153 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
