coziosco Posted December 4, 2018 Share Posted December 4, 2018 Hi I'm seeing multiple reports from our heavier users where if they have more than 70 lines of products ready to order they're seeing a blank page when they click checkout. I've been able to replicate this and removing a few lines to less than 70 seems to solve the issue. With or without error reporting turned on there are no errors presented using the one page checkout I have setup as default, however if I switch to the multi page checkout I see the error message below and attached. I'm on 1.6.1.3, any ideas? Cheers C REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content) VALUES ( "745704c29aa8595626ea5bf70827969b91362508", "edfa99458afcea621056b93d68d8cfb1d30c4510", "crossselling|shoppingcart|2531|298|1870|1873|314|316|320|1872|330|332|339|3743|339|342|344|3339|346|350|354|1858|3735|355|355|355|355|359|360|360|366|1404|1404|3737|377|387|1874|3742|388|389|470|471|1857|2524|3727|446|447|447|447|447|447|447|450|451|451|452|3716|3768|1|5|5_25_26_27_28_29_31_33_34_35_47|17", "decodeProperties(array (\n \'file_dependency\' => \n array (\n \'edfa99458afcea621056b93d68d8cfb1d30c4510\' => \n array (\n 0 => \'/home/lyonb2bco/public_html/themes/default-bootstrap/modules/crossselling/crossselling.tpl\',\n 1 => 1450110869,\n 2 => \'file\',\n ),\n ),\n \'nocache_hash\' => \'3362669865c0549251b8738-01874312\',\n \'version\' => \'Smarty-3.1.19\',\n \'unifunc\' => \'content_5c055f63675391_11480355\',\n \'has_nocache_code\' => false,\n \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n \n \n We recommend\n \n \n \n · \n \n \n \n \n \n \n Logo Evo\n \n \n \n \n \n £ 56.10\n \n \n \n \n Add to cart\n \n \n \n \n · \n \n \n \n \n \n \n Compression...\n \n \n \n \n \n £ 13.02\n \n \n \n \n Add to cart\n \n \n \n \n · \n \n \n \n \n \n \n Breeze Zebra...\n \n \n \n \n \n £ 53.33\n \n \n \n \n Add to cart\n \n \n \n \n · \n \n \n \n \n \n \n Antiscratch...\n \n \n \n \n \n £ 3.51\n \n \n \n \n Add to cart\n \n \n \n \n · \n \n \n \n \n \n \n Duffle RS 85L\n \n \n \n \n \n £ 113.30\n \n \n \n \n Add to cart\n \n \n \n \n · \n \n \n \n \n \n \n Pivot Tongs\n \n \n \n \n \n £ 3.86\n \n \n \n \n Add to cart\n \n \n \n \n · \n \n \n \n \n \n \n Back Roller...\n \n \n \n \n \n £ 36.95\n \n \n \n \n Add to cart\n \n \n \n \n · \n \n \n \n \n \n \n Ultimate Six...\n \n \n \n \n \n £ 91.13\n \n \n \n \n Add to cart\n \n \n \n \n · \n \n \n \n \n \n \n Downtown 2...\n \n \n \n \n \n £ 73.89\n \n \n \n \n Add to cart\n \n \n \n \n · \n \n \n \n \n \n \n Duffle RG 34L\n \n \n \n \n \n £ 123.15\n \n \n \n \n Add to cart\n \n \n \n \n \n \n \n\n" ) at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. } DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 601 - classes/db/Db.php] - [1 Arguments] DbCore->execute - [line 91 - classes/SmartyCacheResourceMysql.php] - [1 Arguments] Smarty_CacheResource_Mysql->save - [line 169 - tools/smarty/sysplugins/smarty_cacheresource_custom.php] - [6 Arguments] Smarty_CacheResource_Custom->writeCachedContent - [line 427 - tools/smarty/sysplugins/smarty_cacheresource.php] - [2 Arguments] Smarty_Template_Cached->write - [line 245 - tools/smarty/sysplugins/smarty_internal_template.php] - [2 Arguments] Smarty_Internal_Template->writeCachedContent - [line 273 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments] Smarty_Internal_TemplateBase->fetch - [line 308 - classes/SmartyCustom.php] - [7 Arguments] Smarty_Custom_Template->fetch - [line 2309 - classes/module/Module.php] ModuleCore->display - [line 235 - modules/crossselling/crossselling.php] - [3 Arguments] CrossSelling->hookshoppingCart - [line 587 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 544 - classes/Hook.php] - [3 Arguments] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now