chongshengdz Posted April 30, 2018 Share Posted April 30, 2018 where to limit number of products to show on sales items? too many products lead to internal server error. Quote Link to comment Share on other sites More sharing options...
keat Posted April 30, 2018 Share Posted April 30, 2018 store settings / Features Quote Link to comment Share on other sites More sharing options...
chongshengdz Posted April 30, 2018 Author Share Posted April 30, 2018 yes,but it still takes forever and then time out (500 internal error),no matter how many i set. it should be optimised for big site for the new cubecart version. Quote Link to comment Share on other sites More sharing options...
keat Posted April 30, 2018 Share Posted April 30, 2018 how many do you show Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 30, 2018 Share Posted April 30, 2018 Please create the error log. It may show the exact cause of the 500 error. Quote Link to comment Share on other sites More sharing options...
chongshengdz Posted April 30, 2018 Author Share Posted April 30, 2018 (edited) [fcgid:warn] mod_fcgid: read data timeout in 40 seconds, referer: /sale-items.html [core:error]End of script output before headers: index.php, referer: /sale-items.html error log has the above 2 lines. i have over 66000 products and change InnoDB to MyISAM storage. Edited April 30, 2018 by chongshengdz Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 30, 2018 Share Posted April 30, 2018 We can agree that CubeCart can be better with some optimizations. These posts suggests the problem is more related to using a low powered environment to run a high-capacity application: https://www.howtoforge.com/community/threads/mod_fcgid-read-data-timeout-in-40-seconds.44427/ https://serverfault.com/questions/382261/mod-fcgid-read-data-timeout-errors Quote Link to comment Share on other sites More sharing options...
chongshengdz Posted April 30, 2018 Author Share Posted April 30, 2018 (edited) 66000 products are not too many at all. maybe cubecart needs more work on optimizations. select 8 products for sales items can lead to time out (500 internal error),that is really incredible. even set to 0,still time out. Edited April 30, 2018 by chongshengdz Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 30, 2018 Share Posted April 30, 2018 (edited) If set to zero, then CubeCart should not show a link in the navigation menu bar for Sale Items, nor a box for "On Sale". CubeCart would not execute the routine to query the database for records where the calculation in the query selects where 'sale_price' is less than 'price'. We may need to explore further where the problem is at. The error messages you posted above do not look like the typical error messages generated by PHP. Please verify you are posting the contents of a file named 'error_log' located in CubeCart's main folder. CubeCart's main folder is where "ini-custom.inc.php" will write this file. Edited April 30, 2018 by bsmither Quote Link to comment Share on other sites More sharing options...
chongshengdz Posted April 30, 2018 Author Share Posted April 30, 2018 yes,100% sure,Apache Error Log Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 30, 2018 Share Posted April 30, 2018 We want to read PHP's error log. Quote Link to comment Share on other sites More sharing options...
chongshengdz Posted April 30, 2018 Author Share Posted April 30, 2018 (edited) where does it located? i am using webmin/virtualmin panel. CentOS Linux 7.4.1708 /var/log/virtualmin/domain.com_error_log [fcgid:warn] mod_fcgid: read data timeout in 40 seconds, referer: /sale-items.html [core:error]End of script output before headers: index.php, referer: /sale-items.html Edited April 30, 2018 by chongshengdz Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 30, 2018 Share Posted April 30, 2018 (edited) In CubeCart's main folder. When you FTP to your site, you probably are in /public_html/. Find CubeCart's index.php. A few of the folders in CubeCart's main folder are: /cache/, /classes/, /controllers/, and more - and ini-custom.inc.php if you followed the link provided earlier. Along with index.php and these folders (and more), there should be PHP's error_log. Edited April 30, 2018 by bsmither Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.