[peterlee]

Hi there,

When my categories increased to around 2400, "Manage categories" in the admin part begins blank. I can not manage any category at all now. Does anyone get such a problem? It seems cs-cart can not handle large categories.

I am using cs-cart sp2.

Thanks a lot

Peter

[MikeFold]

theoretically, there's no reason that the program should not be able to handle 2400 categories.
Outside of asking the obvious question (2400 categories), all I can think of are limitations of the server (hosting) and variable environment settings. (time-outs and char limits)

I have NO PROBLEM listing all my "products" at once in a "Full List" option (3175)
(takes about 30 seconds though)

[baballuci]

2400 categories? How long is your page?

[peterlee]

2400 categories? How long is your page?

Thanks for you guys' quick answer. We are running a wheel's company and we use cs-cart for the online shop. I tried zen-cart, x-cart and finally stick to cs-cart because it is so easy to manage product options. Now I found two problems in cs-cart: one is that after I added category to more than 2400 then when I click "Manage categories" , it shows nothing and I could not manage our products the other is that when I check the error log of Apache, I got the following:


[Wed Feb 27 16:51:37 2008] [error] [client ] PHP Warning: mysqli_errno() [<a href='function.mysqli-errno'>function.mysqli-errno</a>]: Couldn't fetch mysqli in /var/www/html/core/db_mysql41.php on line 140, referer: http://www.wheelall.com/
[Wed Feb 27 16:51:37 2008] [error] [client ] PHP Warning: mysqli_error() [<a href='function.mysqli-error'>function.mysqli-error</a>]: Couldn't fetch mysqli in /var/www/html/core/db_mysql41.php on line 146, referer: http://www.wheelall.com/


[Wed Feb 27 16:53:22 2008] [error] [client ] PHP Warning: mysqli_errno() [<a href='function.mysqli-errno'>function.mysqli-errno</a>]: Couldn't fetch mysqli in /var/www/html/core/db_mysql41.php on line 140, referer: http://www.wheelall.com/elemis.html
Allowed memory size of 12582912 bytes exhausted (tried to allocate 1956140 bytes)

I increased timeout from php.ini and httpd.conf and still no help. Our server is CentOS 5.1 (Apache 2, php 5.16 and MySQL5)

The website is

http://www.WheelAll.com

Thanks a lot

Peter

[MikeFold]

Still looks like an environment setup....maybe S-Combs or one of the techies will catch this thread

(physical memory maybe?)

[S-Combs]

Sounds as if you are on a dedicated or vps server and have access to your main conf files. If so; Open your servers main php.ini file and adjust the following variables to something more suiting to your needs. Don't go overboard with these settings because it could make your server more vulnerable to a DOS attack.

max_execution_time =
max_input_time =
memory_limit =
post_max_size =

After adjusting those restart Apache

It would also help to raise MySQL's max_allowed_packet as well

Open my.ini or my.cnf (whichever your server has) and find
max_allowed_packet =

If it is there then raise the limit to 32M (A high limit is safer here)

If the setting is not listed then add this after [mysqld]

max_allowed_packet=32M

Restart Mysql server.

Now open config.php and go to near the bottom

Find

@ini_set('memory_limit', '12M');

Comment it out like below

//@ini_set('memory_limit', '12M');

-------------------------------------------
If your do NOT have access to the servers main conf files then try this below
-------------------------------------------

Open config.php

Find

@ini_set('memory_limit', '12M');

Change to

@ini_set('memory_limit', '32M');

This sounds like a very easy fix either way if it works but, it is not good to have this setting hard coded in the script for multiple reasons.

1) It will not work on all servers
2) It will actually reduce your abilities with more professional hosting services that already allow for more than a 12MB limit.
3) It can get you kicked off of some budget hosting services for manipulating services that increase the servers resource usage.

You can also manipulate some of the other PHP variables listed above with either the .htaccess file or a php.ini file in the root of your account (depending on PHP type Module/CGI) but I will not promote that practice.

[peterlee]

Great! S-combs, the "Manage categories" problem is INDEED resolved
Now I can manage my categories again. Thanks.

But the second problem is still there. See the following apache log error:

[Fri Feb 29 10:26:57 2008] [error] [client *.*.*.*] PHP Warning: mysqli_error() [<a href='function.mysqli-error'>function.mysqli-error</a>]: Couldn't fetch mysqli in /var/www/html/core/db_mysql41.php on line 146, referer: http://www.wheelall....from=&price_to=

[S-Combs]

Try this fix

http://vb.cs-cart.co...543&postcount=7