Error Transferencia bancaria v0.7.2 PS 1.6.0.6

[Persianas123]

Buenas, configurando mi modulo de pago por transferencia bancaria en el último paso de la compra cuando debería mostrar los datos de pago obtengo el siguiente error en esta pagina .'../module/bankwire/validation'

 

EDIT1: La tabla ps_order_invoice no existe en mi DB, tengo

ps_orders

ps_order_invoice_payment

ps_order_invoice_tax

ps_order_message

ps_order_message_lang

ps_order_payment

ps_order_return

 

EDIT2: En mi localhost tenia PS instalado pensando en exportar esa tabla e importarla a mi DB tambien tengo problemas justo con esa tabla... Necesito crearla en mi DB e imagino que se solucionará... Pero no se como

 

A ver si me podeis ayudar a solucionarlo. Saludos.

[PrestaShopDatabaseException]

Table 'DB1674950.ps_order_invoice' doesn't exist


				SELECT *
				FROM `ps_order_invoice`
				WHERE `id_order` =  18 LIMIT 1

at line 635 in file classes/db/Db.php
629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630. 		}
631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632. 		{
633. 			if ($sql)
634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635. 			throw new PrestaShopDatabaseException($this->getMsgError());
636. 		}
637. 	}
638. 
639. 	/**
DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 547 - classes/db/Db.php] - [1 Arguments]
DbCore->getRow - [line 1860 - classes/order/Order.php] - [1 Arguments]
OrderCore->hasInvoice - [line 1144 - classes/order/Order.php]
OrderCore->setInvoice - [line 286 - classes/order/OrderHistory.php] - [1 Arguments]
OrderHistoryCore->changeIdOrderState - [line 710 - classes/PaymentModule.php] - [3 Arguments]
PaymentModuleCore->validateOrder - [line 64 - modules/bankwire/controllers/front/validation.php] - [9 Arguments]
BankwireValidationModuleFrontController->postProcess - [line 171 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]

Edited June 10, 2014 by Persianas123 (see edit history)

[Josraso]

Te dejo la estructura de dicha tabla.

CREATE TABLE `ps_order_invoice` (
  `id_order_invoice` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_order` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `delivery_number` int(11) NOT NULL,
  `delivery_date` datetime,
  `total_discount_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_discount_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_paid_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_paid_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_products` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_products_wt` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_shipping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_shipping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `shipping_tax_computation_method` int(10) unsigned NOT NULL,
  `total_wrapping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_wrapping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `note` text,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_order_invoice`),
  KEY `id_order` (`id_order`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8;

[Persianas123]

 

Te dejo la estructura de dicha tabla.

CREATE TABLE `ps_order_invoice` (
  `id_order_invoice` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_order` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `delivery_number` int(11) NOT NULL,
  `delivery_date` datetime,
  `total_discount_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_discount_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_paid_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_paid_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_products` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_products_wt` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_shipping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_shipping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `shipping_tax_computation_method` int(10) unsigned NOT NULL,
  `total_wrapping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `total_wrapping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00',
  `note` text,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_order_invoice`),
  KEY `id_order` (`id_order`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8;

Solucionado. gracias