Witam ponownie.
PA działa idealnie, a strona główna wciąż wyświetla "Couldnt execute query2"
W oknie z błędami mam:
[ERROR] PHP 1.5.0.13 -- Step 3: Fill in id_order_reference and merge duplicate lines /* PHP:add_order_reference_in_order_payment(); */
Wykryto ostrzeżenie podczas aktualizacji.
Po aktualizacji w oknie gdzie wykazywane są wszystkie czynności jakie robi 1-click mam następujące ostrzeżenia:
[WARNING] SQL 1.5.0.1 1050 in RENAME TABLE `ps_payment_cc` TO `ps_order_payment`: Table 'ps_order_payment' already exists
WARNING] SQL 1.5.0.1 1050 in RENAME TABLE `ps_discount_lang` TO `ps_cart_rule_lang`: Table 'ps_cart_rule_lang' already exists
[WARNING] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_lang` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'ps_cart_rule_lang'
[WARNING] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_lang` CHANGE `description` `name` varchar(254) NOT NULL: Unknown column 'description' in 'ps_cart_rule_lang'
[WARNING] SQL 1.5.0.1 1050 in RENAME TABLE `ps_discount_category` TO `ps_cart_rule_product_rule_value`: Table 'ps_cart_rule_product_rule_value' already exists
[WARNING] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_product_rule_value` CHANGE `id_category` `id_item` int(10) unsigned NOT NULL: Unknown column 'id_category' in 'ps_cart_rule_product_rule_value'
[WARNING] SQL 1.5.0.1 1054 in ALTER TABLE `ps_cart_rule_product_rule_value` CHANGE `id_discount` `id_product_rule` int(10) unsigned NOT NULL: Unknown column 'id_discount' in 'ps_cart_rule_product_rule_value'
[WARNING] SQL 1.5.0.1 1050 in RENAME TABLE `ps_order_discount` TO `ps_order_cart_rule`: Table 'ps_order_cart_rule' already exists
[WARNING] SQL 1.5.0.1 1050 in RENAME TABLE `ps_cart_discount` TO `ps_cart_cart_rule`: Table 'ps_cart_cart_rule' already exists
[WARNING] SQL 1.5.0.2 1060 in ALTER TABLE `ps_order_cart_rule` ADD `value_tax_excl` DECIMAL(17, 2) NOT NULL DEFAULT '0.00': Duplicate column name 'value_tax_excl'
[WARNING] SQL 1.5.0.2 1060 in ALTER TABLE `ps_order_cart_rule` ADD `id_order_invoice` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `id_cart_rule`: Duplicate column name 'id_order_invoice'
[WARNING] SQL 1.5.0.2 1054 in INSERT IGNORE INTO `ps_order_payment` (`id_order_invoice`, `id_order`, `id_currency`, `amount`, `payment_method`, `conversion_rate`, `date_add`) ( SELECT ( SELECT oi.`id_order_invoice` FROM `ps_order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), o.`id_order`, o.`id_currency`, o.`total_paid_real`, o.`payment`, o.`conversion_rate`, o.`date_add` FROM `ps_orders` o LEFT JOIN `ps_order_payment` op ON (op.`id_order` = o.`id_order`) WHERE op.`id_order_payment` IS NULL ): Unknown column 'op.id_order' in 'on clause'
[WARNING] SQL 1.5.0.10 1050 in RENAME TABLE `ps_group_shop` TO `ps_shop_group`: Table 'ps_shop_group' already exists
[WARNING] SQL 1.5.0.10 1054 in ALTER TABLE `ps_shop_group` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT: Unknown column 'id_group_shop' in 'ps_shop_group'
[WARNING] SQL 1.5.0.13 1054 in INSERT INTO `ps_order_invoice_payment` (SELECT id_order_invoice, id_order_payment, id_order FROM `ps_order_payment` WHERE id_order_invoice > 0): Unknown column 'id_order_invoice' in 'field list'
[WARNING] SQL 1.5.0.13 1054 in -- Step 2: Add the collumn id_order_reference ALTER TABLE `ps_order_payment` ADD COLUMN `order_reference` VARCHAR(9) AFTER `id_order`, ADD INDEX `order_reference`(`order_reference`): Unknown column 'id_order' in 'ps_order_payment'
[ERROR] PHP 1.5.0.13 -- Step 3: Fill in id_order_reference and merge duplicate lines /* PHP:add_order_reference_in_order_payment(); */
[WARNING] SQL 1.5.0.13 1091 in -- Step 4: Drop collumn id_order ALTER TABLE `ps_order_payment` DROP COLUMN `id_order`, DROP COLUMN `id_order_invoice`: Can't DROP 'id_order'; check that column/key exists
