Back end categories explorer

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

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 ?

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)

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.

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

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.

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

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

[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

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 ?

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

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.

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 ?????

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.