Hello,
I try to upgrade my shop from 1.4.5.1 to 1.5.1 but every time i got this <action result="fail" error="34">
1.Backup the old shop and deactivate it
2.Use theme "default"
3.Copy only /img/p/ to new shop
4.Copy only settings.inc.php to /config floder of new shop
5.Then use this
http://www.myprestashop.com/prestashop/install/upgrade/upgrade.php
And then i got the <action result="fail" error="34">
Here is my log file :
*ERROR* 2012/10/18 - 01:46:43: SQL query:
INSERT INTO `ps_hook_module` (`id_hook`, `id_module`, `position`) VALUES (@id_hook, @id_module, @position)
*ERROR* 2012/10/18 - 01:46:43: SQL error:
Column 'id_module' cannot be null
*ERROR* 2012/10/18 - 01:47:00: SQL query:
UPDATE `ps_order_detail` od
SET od.`id_order_invoice` = (
SELECT oi.`id_order_invoice`
FROM `ps_order_invoice` oi
WHERE oi.`id_order` = od.`id_order`
)
*ERROR* 2012/10/18 - 01:47:00: SQL error:
Column 'id_order_invoice' cannot be null
*ERROR* 2012/10/18 - 01:47:11: PHP error: /* PHP:p15012_add_missing_columns(); */
- <subquery><query>ALTER TABLE `ps_order_payment`
CHANGE `id_order_invoice` id_order_invoice int(10) unsigned DEFAULT NULL</query><error>Incorrect integer value: '' for column 'id_order_invoice' at row 1</error></subquery>
*ERROR* 2012/10/18 - 01:47:11: 1
*ERROR* 2012/10/18 - 15:27:12: SQL query:
UPDATE `ps_order_detail` od
SET od.`id_order_invoice` = (
SELECT oi.`id_order_invoice`
FROM `ps_order_invoice` oi
WHERE oi.`id_order` = od.`id_order`
)
*ERROR* 2012/10/18 - 15:27:13: SQL error:
Column 'id_order_invoice' cannot be null
*ERROR* 2012/10/18 - 15:27:25: PHP error: /* PHP:p15012_add_missing_columns(); */
- <subquery><query>ALTER TABLE `ps_order_payment`
CHANGE `id_order_invoice` id_order_invoice int(10) unsigned DEFAULT NULL</query><error>Incorrect integer value: '' for column 'id_order_invoice' at row 1</error></subquery>
*ERROR* 2012/10/18 - 15:27:25: 1
In BO: when I edit the CMS,I got a page white,
In FO: can not add the product to cart, got this message:
Impossible to add the product to the cart.
textStatus: 'error'
errorThrown: 'Internal Server Error'
responseText:
Some one can give me a help,
Thank you very very much.