Jump to content

Cart showing Blank Page With Lots of Items


Recommended Posts

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]

 

 

Capture1.JPG

Capture.JPG

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...