Natursara Posted December 20, 2016 Share Posted December 20, 2016 Hola al hacer clic en los carritos de la compra activos, me sale esto, me podéis decir qué sucede? gracias tengo prestashop 1.6.1.3 y es de prestashop cloud [PrestaShopException] Invalid address #10 at line 401 in file core/www/core_1.6.1.3/classes/Address.php 396. // if an id_address has been specified retrieve the address397. if ($id_address) { 398. $address = new Address((int)$id_address); 399. 400. if (!Validate::isLoadedObject($address)) { 401. throw new PrestaShopException('Invalid address #'.(int)$id_address); 402. } 403. } elseif ($with_geoloc && isset($context->customer->geoloc_id_country)) { 404. $address = new Address(); 405. $address->id_country = (int)$context->customer->geoloc_id_country; 406. $address->id_state = (int)$context->customer->id_state; AddressCore::initialize - [line 197 - core/www/core_1.6.1.3/classes/tax/Tax.php] - [1 Arguments] TaxCore::getProductEcotaxRate - [line 610 - core/www/core_1.6.1.3/classes/Cart.php] - [1 Arguments] CartCore->getProducts - [line 1494 - core/www/core_1.6.1.3/classes/Cart.php] CartCore->getOrderTotal - [line 1392 - core/www/core_1.6.1.3/classes/Cart.php] - [2 Arguments] CartCore::getTotalCart - [line 854 - core/www/core_1.6.1.3/controllers/admin/AdminCartsController.php] - [3 Arguments] AdminCartsControllerCore->getOrderTotalUsingTaxCalculationMethod - [line - ] - [2 Arguments] call_user_func_array - [line 321 - core/www/core_1.6.1.3/classes/helper/HelperList.php] - [2 Arguments] HelperListCore->displayListContent - [line 156 - core/www/core_1.6.1.3/classes/helper/HelperList.php] HelperListCore->generateList - [line 914 - core/www/core_1.6.1.3/controllers/admin/AdminCartsController.php] - [2 Arguments] AdminCartsControllerCore->renderList - [line 2025 - core/www/core_1.6.1.3/classes/controller/AdminController.php] AdminControllerCore->initContent - [line 37 - home/pfr1631112h/www/ftp/override/classes/controller/AdminController.php] AdminController->initContent - [line 189 - core/www/core_1.6.1.3/classes/controller/Controller.php] ControllerCore->run - [line 367 - core/www/core_1.6.1.3/classes/Dispatcher.php] DispatcherCore->dispatch - [line 58 - core/www/core_1.6.1.3/admin/index.php] include_once - [line 100 - core/www/index.php] - [1 Arguments] include_once - [line 26 - home/pfr1631112h/www/admin/index.php] - [1 Arguments] Link to comment Share on other sites More sharing options...
joseantgv Posted December 20, 2016 Share Posted December 20, 2016 On 12/20/2016 at 10:03 AM, Natursara said: Hola al hacer clic en los carritos de la compra activos, me sale esto, me podéis decir qué sucede? gracias tengo prestashop 1.6.1.3 y es de prestashop cloud [PrestaShopException] Invalid address #10 at line 401 in file core/www/core_1.6.1.3/classes/Address.php 396. // if an id_address has been specified retrieve the address397. if ($id_address) { 398. $address = new Address((int)$id_address); 399. 400. if (!Validate::isLoadedObject($address)) { 401. throw new PrestaShopException('Invalid address #'.(int)$id_address); 402. } 403. } elseif ($with_geoloc && isset($context->customer->geoloc_id_country)) { 404. $address = new Address(); 405. $address->id_country = (int)$context->customer->geoloc_id_country; 406. $address->id_state = (int)$context->customer->id_state; AddressCore::initialize - [line 197 - core/www/core_1.6.1.3/classes/tax/Tax.php] - [1 Arguments] TaxCore::getProductEcotaxRate - [line 610 - core/www/core_1.6.1.3/classes/Cart.php] - [1 Arguments] CartCore->getProducts - [line 1494 - core/www/core_1.6.1.3/classes/Cart.php] CartCore->getOrderTotal - [line 1392 - core/www/core_1.6.1.3/classes/Cart.php] - [2 Arguments] CartCore::getTotalCart - [line 854 - core/www/core_1.6.1.3/controllers/admin/AdminCartsController.php] - [3 Arguments] AdminCartsControllerCore->getOrderTotalUsingTaxCalculationMethod - [line - ] - [2 Arguments] call_user_func_array - [line 321 - core/www/core_1.6.1.3/classes/helper/HelperList.php] - [2 Arguments] HelperListCore->displayListContent - [line 156 - core/www/core_1.6.1.3/classes/helper/HelperList.php] HelperListCore->generateList - [line 914 - core/www/core_1.6.1.3/controllers/admin/AdminCartsController.php] - [2 Arguments] AdminCartsControllerCore->renderList - [line 2025 - core/www/core_1.6.1.3/classes/controller/AdminController.php] AdminControllerCore->initContent - [line 37 - home/pfr1631112h/www/ftp/override/classes/controller/AdminController.php] AdminController->initContent - [line 189 - core/www/core_1.6.1.3/classes/controller/Controller.php] ControllerCore->run - [line 367 - core/www/core_1.6.1.3/classes/Dispatcher.php] DispatcherCore->dispatch - [line 58 - core/www/core_1.6.1.3/admin/index.php] include_once - [line 100 - core/www/index.php] - [1 Arguments] include_once - [line 26 - home/pfr1631112h/www/admin/index.php] - [1 Arguments] Hay algún carrito asociado a una dirección que no existe. Has borrado direcciones desde base de datos? 1 Link to comment Share on other sites More sharing options...
Natursara Posted December 21, 2016 Author Share Posted December 21, 2016 On 12/20/2016 at 10:09 AM, joseantgv said: Hay algún carrito asociado a una dirección que no existe. Has borrado direcciones desde base de datos? No, borré desde el mismo módulo de clientes, algunos miembros que se habían registrados dos veces, pero esto me ha sucedido con un miembro que aparece como invitado, es decir que no se ha registrado todavía... Link to comment Share on other sites More sharing options...
joseantgv Posted December 21, 2016 Share Posted December 21, 2016 (edited) On 12/21/2016 at 12:06 PM, Natursara said: No, borré desde el mismo módulo de clientes, algunos miembros que se habían registrados dos veces, pero esto me ha sucedido con un miembro que aparece como invitado, es decir que no se ha registrado todavía... Ejecuta estas queries a ver si te aparece algún resultado: SELECT * FROM `ps_cart` WHERE `id_address_delivery` > 0 AND `id_address_delivery` NOT IN (SELECT `id_address` FROM `ps_address`); SELECT * FROM `ps_cart` WHERE `id_address_invoice` > 0 AND `id_address_invoice` NOT IN (SELECT `id_address` FROM `ps_address`) Edited December 21, 2016 by joseantgv (see edit history) 1 1 Link to comment Share on other sites More sharing options...
Natursara Posted December 22, 2016 Author Share Posted December 22, 2016 On 12/21/2016 at 2:47 PM, joseantgv said: Ejecuta estas queries a ver si te aparece algún resultado: SELECT * FROM `ps_cart` WHERE `id_address_delivery` > 0 AND `id_address_delivery` NOT IN (SELECT `id_address` FROM `ps_address`); SELECT * FROM `ps_cart` WHERE `id_address_invoice` > 0 AND `id_address_invoice` NOT IN (SELECT `id_address` FROM `ps_address`) Sé que te pido mucho, pero me puedes decir como se hace? muchas gracias! Un total novato soy... Link to comment Share on other sites More sharing options...
nadie Posted December 22, 2016 Share Posted December 22, 2016 On 12/22/2016 at 10:24 AM, Natursara said: On 12/21/2016 at 2:47 PM, joseantgv said: Ejecuta estas queries a ver si te aparece algún resultado: SELECT * FROM `ps_cart` WHERE `id_address_delivery` > 0 AND `id_address_delivery` NOT IN (SELECT `id_address` FROM `ps_address`); SELECT * FROM `ps_cart` WHERE `id_address_invoice` > 0 AND `id_address_invoice` NOT IN (SELECT `id_address` FROM `ps_address`) Sé que te pido mucho, pero me puedes decir como se hace? muchas gracias! Un total novato soy... Para hacer las consultas de "impresion de datos" tienes varias opciones, una de ellas es desde phpmyadmin, otra opción es desde el panel de tu tienda en la pestaña Parametros Avanzados -> Gestor SQL, ect.. Link to comment Share on other sites More sharing options...
joseantgv Posted December 22, 2016 Share Posted December 22, 2016 On 12/22/2016 at 10:24 AM, Natursara said: On 12/21/2016 at 2:47 PM, joseantgv said: Ejecuta estas queries a ver si te aparece algún resultado: SELECT * FROM `ps_cart` WHERE `id_address_delivery` > 0 AND `id_address_delivery` NOT IN (SELECT `id_address` FROM `ps_address`); SELECT * FROM `ps_cart` WHERE `id_address_invoice` > 0 AND `id_address_invoice` NOT IN (SELECT `id_address` FROM `ps_address`) Sé que te pido mucho, pero me puedes decir como se hace? muchas gracias! Un total novato soy... Las queries las puedes ejecutar desde "Parámetros avanzados -> Gestor SQL". Link to comment Share on other sites More sharing options...
Recommended Posts