Back end categories explorer

  • Posts: 51
  • Thank you received: 0
11 years 8 months ago #95368

hello
when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error
when i deactivate it everything is fine
i have more than 240000 products in the db
thank you

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 8 months ago #95418

Hi,

Have you imported products and categories via a csv file ?
If it is, maybe it was not correctly formatted and that's why the error appear.

Have you enabled the Joomla debug mode, set the error reporting to maximum ? An error is returned ?

The following user(s) said Thank You: gili

Please Log in or Create an account to join the conversation.

  • Posts: 51
  • Thank you received: 0
11 years 8 months ago #95550

hello
i have imported them through a script directly to db cause i had to take them from another website
i enabled debug mode in joomla but it does not show any errors since it shows a white page
thanx

Error 324 (net::ERR_EMPTY_RESPONSE): The server closed the connection without sending any data. (This is the error chrome gave me)

Last edit: 11 years 8 months ago by gili.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
11 years 8 months ago #95588

And do you have any error logged in the PHP error log of your server ?

The category explorer has to load all the categories of your website. So if you have a lot of categories, it can potentially means too much data for the server to handle and thus there is an option to deactivate it in the configuration. I'm afraid that if you have a lot of categories, we won't be able to help much.

The following user(s) said Thank You: gili

Please Log in or Create an account to join the conversation.

  • Posts: 51
  • Thank you received: 0
11 years 8 months ago #95590

hello
i have only 371 categories (the brands are around 2000 and work ok)

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 8 months ago #95635

Hi,

The brands are too in the categories listing, because it's a kind of category.
Thanks to give us the error logged in the PHP error log.

Please Log in or Create an account to join the conversation.

  • Posts: 51
  • Thank you received: 0
11 years 8 months ago #95636

i dont know how to find the php error log
can u help ?

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
11 years 8 months ago #95650

It depends on how is setup your server. You should ask your hosting company.

Please Log in or Create an account to join the conversation.

  • Posts: 51
  • Thank you received: 0
11 years 8 months ago #95663

[Thu Mar 21 19:09:46 2013] [error] [client 178.59.197.244] PHP Fatal error: Allowed memory size of 343932928 bytes exhausted (tried to allocate 8388608 bytes) in /home/ubookftp/www.ubook.gr/libraries/joomla/database/database/mysql.php on line 712, referer: ubook.gr/administrator/index.php?option=...ashop&ctrl=dashboard

this is the error from error_log

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
11 years 8 months ago #95667

That Fatal error is for the dashboard page of HikaShop. Do you have other Fatal errors (the ones related to the categories/products listing where the categories explorer is used) in your error log ?

The following user(s) said Thank You: gili

Please Log in or Create an account to join the conversation.

  • Posts: 51
  • Thank you received: 0
11 years 8 months ago #95682

i have sent you the link to the log .. in your inbox !!!

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
11 years 8 months ago #95696

It's that one:
[Thu Mar 21 07:34:58 2013] [error] [client 178.59.197.244] PHP Fatal error: Allowed memory size of 343932928 bytes exhausted (tried to allocate 8388608 bytes) in /home/ubookftp/www.ubook.gr/libraries/joomla/database/database/mysql.php on line 712, referer: ubook.gr/administrator/index.php?option=...ikashop&ctrl=product

So it means that the memory is getting filled completely before it can display anything.

So it's not an error, just that the data is too much to handle.
Maybe some kind of optimization in HikaShop could be possible but we won't be able to look at that before next week.

Is that a brand new install of HikaShop 2.1.1 or was it updated from a previous version ? With the 2.1.1, if you have a fresh install, you have improvments in the database to optimize queries for lot of data like here. Maybe that could help ?
Actually, we've only added some strategic indexes in some tables. That would already be a good start I think. You can compare the back/tables.sql file of the install package with the tables structure on your website to add the indexes if it's not a fresh install of the latest version and thus get these improvements.

The following user(s) said Thank You: gili

Please Log in or Create an account to join the conversation.

  • Posts: 51
  • Thank you received: 0
11 years 8 months ago #96120

hello
i reinstalled as u said
but nothing has changed
what i noticed though is that i have around 100000 categories ... and this is what causes the problem
any suggestion ?????

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
11 years 8 months ago #96128

Hi,

From what you're saying, there is nothing we can do.
The category explorer has to load all the categories to be able to display the category tree.
Loading 100000 categories at once is not possible.
You'll have to keep it deactivated or reduce a lot the amount of categories you're using.

The following user(s) said Thank You: gili

Please Log in or Create an account to join the conversation.

Time to create page: 0.100 seconds
Powered by Kunena Forum