lilouetpuce Posted January 25, 2020 Share Posted January 25, 2020 Bonjour, Je viens de changer d'hébergeur (de 1and1 à Infomaniak). J'ai eu plusieurs soucis de BDD. Il me reste au moins celle là que je n'arrive pas à résoudre. Quand j'essaye d'accéder à une commande passée avec Paypal (ancienne ou nouvelle) sur mon BO, j'ai ceci : Quote [PrestaShopDatabaseException] Table 'h877p_lilouetpucev1.ps_paypal_capture' doesn't exist SELECT SUM(capture_amount) FROM `ps_paypal_capture` WHERE (id_order = 2395) AND (result = "Completed") LIMIT 1 at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, ' '.$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 690 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 723 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 112 - modules/paypal/classes/PaypalCapture.php] - [1 Arguments] PaypalCapture::getTotalAmountCapturedByIdOrder - [line 120 - modules/paypal/classes/PaypalCapture.php] - [1 Arguments] PaypalCapture->getRestToPaid - [line 1335 - modules/paypal/paypal.php] - [1 Arguments] PayPal->hookAdminOrder - [line 591 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 548 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 207 - config/smarty.config.inc.php] - [3 Arguments] smartyHook - [line 270 - config/smarty.config.inc.php] - [2 Arguments] SmartyLazyRegister->__call - [line 1297 - cache/smarty/compile/7c/fa/66/7cfa660662a9a488c74f124644ecd5a12df6de24.file.view.tpl.php] - [2 Arguments] content_5e2c53d11028e9_29012293 - [line 188 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments] Smarty_Internal_TemplateBase->fetch - [line 317 - classes/SmartyCustom.php] - [7 Arguments] Smarty_Custom_Template->fetch - [line 113 - classes/helper/Helper.php] HelperCore->generate - [line 59 - classes/helper/HelperView.php] HelperViewCore->generateView - [line 2434 - classes/controller/AdminController.php] AdminControllerCore->renderView - [line 1793 - controllers/admin/AdminOrdersController.php] AdminOrdersControllerCore->renderView - [line 2059 - classes/controller/AdminController.php] AdminControllerCore->initContent - [line 189 - classes/controller/Controller.php] ControllerCore->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 58 - admin/index.php] [Click and drag to move] Link to comment Share on other sites More sharing options...
JLCH Posted May 18, 2020 Share Posted May 18, 2020 Bonjour, vous avez trouvé? Link to comment Share on other sites More sharing options...
solsol69 Posted May 18, 2020 Share Posted May 18, 2020 Le 25/01/2020 à 4:06 PM, lilouetpuce a dit : Table 'h877p_lilouetpucev1.ps_paypal_capture Bonjour Il me semble qu'il vous manque cette table sur votre base SQL. Link to comment Share on other sites More sharing options...
lilouetpuce Posted May 19, 2020 Author Share Posted May 19, 2020 Bonjour, j'ai pour l'instant pu résoudre ce problème grâce à une tierce personne, mais je ne sais pas ce qu'elle a fait... Je suis en parallèle entrain de mettre en place une nouvelle boutique mais en 1.7 cette fois... Merci de s'être intéressé à mon problème. Bonne soirée, Claire 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