CHPG

Hi, we upgraded our shop (7bioscience.com) on the 12th of June from 6.1.5 to 6.1.8 using the CC Upgrade Feature on the admin user interface. At first glance all worked our fine, but after a few days we recognized that the contact form is not working any more. In order to be sure that the issue was not caused by the upgrade, we did today a manual Upgrade to 6.1.8. Unfortunately the issue still persist. The Error-Log-File contains the following entrys: [18-Jun-2017 16:36:30 Europe/Berlin] PHP Warning: mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: MySQL server has gone away in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/db/mysqli.class.php on line 203 [18-Jun-2017 16:36:30 Europe/Berlin] PHP Warning: mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: Error reading result set's header in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/db/mysqli.class.php on line 203 [18-Jun-2017 16:36:30 Europe/Berlin] PHP Notice: `language` is not allowed as a key in 'CubeCart_lang_strings' table! in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/db/database.class.php on line 900 [18-Jun-2017 16:36:30 Europe/Berlin] PHP Notice: `doc_parent_id` is not allowed as a key in 'CubeCart_documents' table! in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/db/database.class.php on line 900 [18-Jun-2017 16:36:30 Europe/Berlin] PHP Notice: `doc_status` is not allowed as a key in 'CubeCart_documents' table! in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/db/database.class.php on line 900 [18-Jun-2017 16:36:30 Europe/Berlin] PHP Notice: `navigation_link` is not allowed as a key in 'CubeCart_documents' table! in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/db/database.class.php on line 900 [18-Jun-2017 16:36:30 Europe/Berlin] PHP Notice: `status` is not allowed as a key in 'CubeCart_inventory' table! in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/db/database.class.php on line 900 [18-Jun-2017 16:36:30 Europe/Berlin] PHP Notice: `featured` is not allowed as a key in 'CubeCart_inventory' table! in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/db/database.class.php on line 900 [18-Jun-2017 16:36:30 Europe/Berlin] PHP Notice: `time` is not allowed as a key in 'CubeCart_access_log' table! in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/db/database.class.php on line 900 The shop is running in the following environment (see attached file) It would really be great if somebody has an idea what´s wrong with the contact form kind regards Christian

Hi All, in our cubecart shop we have currently about 120k Products. Since the last import of products i see problems on the storefront (white pages) and error-messages like the one below in the error_log file: [28-Nov-2016 09:37:53 Europe/Berlin] PHP Fatal error: Out of memory (allocated 879730688) (tried to allocate 166163888 bytes) in /homepages/29/d649162713/htdocs/clickandbuilds/cubecart/7BioScienceShop/classes/cache/file.class.php on line 227 The error above came up after i selected "ALL" in the page naviagtion of a category with 8867 Pages (12 Products per page) It looks like cubecart uses up all memory avalable. My hosting provider informed me that there is a memory limit of 512MB per process in his shared hosting environments - so there is nothing he can do about this. He said if we really need mor memory per process we have to switch to a dedicated server for our shop. Is there any way to reduce the memory consumption per process of cubecart? kind regards Christian

can you give me more informations about these packages, at least about the one you are selling ? kind regards Christian

Hi All, thanks for your comments/hints. @bsmither - unfortunately the error_log does not contain an error message. So i think the webserver killed the process before it was ready with the sitemap. So based on the informations received here it seems that i will have to create my own sitemap generator that creates several "small" sitemap files which are connected via a main sitemap file

Hi Ditry Butter, thanks for the quick reply. Since the site is hosted at 1und1.de i don´t have much contol over the settings. Is there maybe a way to exclude the products from the sitemap ? For my oppinion it would be OK to have only the catagories and the documents in the sitemap. kind regards

Hi All, i have currently the Problem that when i try to rebuild the sitemap it takes a long time and than ends with the attached screen. I have alread activated the error_log using the file ini-custom.inc.php as suggested by bsmither in a different Topic. The Shop is running CC 6.1.1 and has currently about 39000 Products loaded. Since it is planed to increase the number of products to about 800.000 I´m a little bit worried about this issue. Hopefully somebody has an idea how this issue can be fixed. kind regards Christian