jonwreck

And how they fix it ?

HI any update with module i need ?

Hi PS 1.6.1.4 I just moved testing shop to new hosting, all works fine except orders.. When i go thru checkout to the end and click "confirm order" i have white page i checked error and here you go: [PrestaShopDatabaseException] Field 'up_fields' doesn't have a default value INSERT INTO `ps_orders` (`id_address_delivery`, `id_address_invoice`, `id_cart`, `id_currency`, `id_shop_group`, `id_shop`, `id_lang`, `id_customer`, `id_carrier`, `current_state`, `secure_key`, `payment`, `module`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `total_discounts`, `total_discounts_tax_incl`, `total_discounts_tax_excl`, `total_paid`, `total_paid_tax_incl`, `total_paid_tax_excl`, `total_paid_real`, `total_products`, `total_products_wt`, `total_shipping`, `total_shipping_tax_incl`, `total_shipping_tax_excl`, `carrier_tax_rate`, `total_wrapping`, `total_wrapping_tax_incl`, `total_wrapping_tax_excl`, `round_mode`, `round_type`, `shipping_number`, `conversion_rate`, `invoice_number`, `delivery_number`, `invoice_date`, `delivery_date`, `valid`, `reference`, `date_add`, `date_upd`) VALUES ('491', '491', '14793', '1', '1', '1', '1', '1', '6', '0', 'd597aa6ae77596a8ead049ad5d903224', 'Bank wire', 'bankwire', '0', '0', NULL, '0', '0', '0', '0', '880', '880', '880', '0', '855', '855', '25', '25', '25', '0', '0', '0', '0', '2', '2', NULL, '1', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', 'MADLUULCK', '2016-11-25 06:49:33', '2016-11-25 06:49:33') 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 763 - classes/db/Db.php] - [1 Arguments] DbCore->q - [line 514 - classes/db/Db.php] - [2 Arguments] DbCore->insert - [line 487 - classes/ObjectModel.php] - [3 Arguments] ObjectModelCore->add - [line 309 - classes/order/Order.php] - [2 Arguments] OrderCore->add - [line 341 - classes/PaymentModule.php] PaymentModuleCore->validateOrder - [line 64 - modules/bankwire/controllers/front/validation.php] - [9 Arguments] BankwireValidationModuleFrontController->postProcess - [line 178 - classes/controller/Controller.php] ControllerCore->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] i instaled new payment module to check it and problem is still the same, with the same info ( 3 different payment module) when i moved db there was such code in sql (`up_fields` varchar(255) NOT NULL,) i checked it and in that filed in shop is empty field '' CREATE TABLE IF NOT EXISTS `ps_orders` ( `id_order` int(10) unsigned NOT NULL AUTO_INCREMENT, `reference` varchar(9) DEFAULT NULL, `id_shop_group` int(11) unsigned NOT NULL DEFAULT '1', `id_shop` int(11) unsigned NOT NULL DEFAULT '1', `id_carrier` int(10) unsigned NOT NULL, `id_lang` int(10) unsigned NOT NULL, `id_customer` int(10) unsigned NOT NULL, `id_cart` int(10) unsigned NOT NULL, `id_currency` int(10) unsigned NOT NULL, `id_address_delivery` int(10) unsigned NOT NULL, `id_address_invoice` int(10) unsigned NOT NULL, `current_state` int(10) unsigned NOT NULL, `secure_key` varchar(32) NOT NULL DEFAULT '-1', `payment` varchar(255) NOT NULL, `conversion_rate` decimal(13,6) NOT NULL DEFAULT '1.000000', `module` varchar(255) DEFAULT NULL, `recyclable` tinyint(1) unsigned NOT NULL DEFAULT '0', `gift` tinyint(1) unsigned NOT NULL DEFAULT '0', `gift_message` text, `mobile_theme` tinyint(1) NOT NULL DEFAULT '0', `shipping_number` varchar(64) DEFAULT NULL, `total_discounts` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_discounts_tax_incl` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_discounts_tax_excl` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_paid` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_paid_tax_incl` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_paid_tax_excl` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_paid_real` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_products` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_products_wt` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_shipping` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_shipping_tax_incl` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_shipping_tax_excl` decimal(20,6) NOT NULL DEFAULT '0.000000', `carrier_tax_rate` decimal(10,3) NOT NULL DEFAULT '0.000', `total_wrapping` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_wrapping_tax_incl` decimal(20,6) NOT NULL DEFAULT '0.000000', `total_wrapping_tax_excl` decimal(20,6) NOT NULL DEFAULT '0.000000', `round_mode` tinyint(1) NOT NULL DEFAULT '2', `round_type` tinyint(1) NOT NULL DEFAULT '1', `invoice_number` int(10) unsigned NOT NULL DEFAULT '0', `delivery_number` int(10) unsigned NOT NULL DEFAULT '0', `invoice_date` datetime NOT NULL, `delivery_date` datetime NOT NULL, `valid` int(1) unsigned NOT NULL DEFAULT '0', `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, `up_fields` varchar(255) NOT NULL, `shipping_number2` text, PRIMARY KEY (`id_order`), KEY `reference` (`reference`), KEY `id_customer` (`id_customer`), KEY `id_cart` (`id_cart`), KEY `invoice_number` (`invoice_number`), KEY `id_carrier` (`id_carrier`), KEY `id_lang` (`id_lang`), KEY `id_currency` (`id_currency`), KEY `id_address_delivery` (`id_address_delivery`), KEY `id_address_invoice` (`id_address_invoice`), KEY `id_shop_group` (`id_shop_group`), KEY `current_state` (`current_state`), KEY `id_shop` (`id_shop`), KEY `date_add` (`date_add`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5341 ; so what is wrong ? i just go to phpmyadmin finded ps_orders and i changed in "up_fields" default value to NULL and all is ok now with orders, but why such thing happend ?

HI ok, i will go there and see, i still don't have solution for this so mabe your module will help

Hi i know that Ps display it in that way, but maybe someone can write what to do to change it, some code or something ?

HI ok, i use 2 carriers now carrier 1 and carrier 2 depend what product you want order there are different carriers and now, when someone buy only "product 1" there i only carrier 1 to choose, all is ok same situation with "product 2" when you want buy both product then of course order will be split into 2 parts, thats ok, there will be use 2 carriers but please look in checkout, point 4, shipping product 1 -carrier 1 - all is ok product 2 -carrier 2 - all is ok and now both products as you see there is only price, no description or logo how to put there carrier logo ? and maybe is there a way to put there both carriers description , something like that below

Thank you for update ps. so maybe there is another way to set it ? 2 carriers with different cost 2 products each product have own carrier, if someone order both products then of course shipping costs add up maybe someone have or see module for that ? maybe something like that: we created 3 carriers, 2 are link to products but third one show only when someone order both product ? then order will not be split

Any update ? I have also 2 carriers and now my order are split In checkout shipping cost is summary from two carriers, but after that prestashop create 2 orders, each one with own carrier how to disable spliting orders by prestashop ?

Hi yes, exaclt, i have such module, when i removed it all works fine

Hi i have the same problem, nothing changed and now i can't upload even the same photo of product

Hi no i using my theme and there i change product.tpl file but on product page with atribute it's show only loyalty points from the biggest price of product Sorry for my english

Hi This solution don't work with combinations in 1.6.3 and 1.6.1.4

HI >:this is why "from" will be your shop email (because your shop sends this email) yes i know that, and in customer mail clinet always show my shop name with my address and this is correct, when customer "replay" then he replay directly to me but when i get mail from contact form from customer why on one shop i have "replay to "my shop name"" and on second shop i have "replay to "customer email " ?? difference is on my first and third pic in previous post, this is my mail box also earlier on 1.2 it works fine, but when i upgra it to 1.3 it doesn't work in the same way Thank you

HI anyone ?

HI I have 2 shops on presta 1.6.1.3, both are on the same vps hosting, both have the same configuration, also both shops have the same configuration (contact), on both i use the same mail client with the same configuration When customers send mail from contact form from my one shop i get mail without problem but in mail client i have in field "From" shop name, please look When i open it i have something like on first picture So why in "FROM" is my shop name it shuld be customer mail like in "replay-to" like on second pic Please look in other shop: pic 3 and 4, there s all ok So where is problem ?