Jump to content

Recommended Posts

Bonjour,

Je reviens avec une solution qui a marché pour moi, il faut procéder comme suit:

This is what worked for me:

Past this SQL into your damaged prestashop database:

1. Make sure to change ps_order_detail if your database prefix is not “ps”
2. This is a version 1.3.5 ps_order_detail table that I put over on damaged 1.3.3 ps_order_detail table
3. This patch will only apply to new order placed since the patch

CREATE TABLE IF NOT EXISTS `ps_order_detail` (
`id_order_detail` int(10) unsigned NOT NULL auto_increment,
`id_order` int(10) unsigned NOT NULL,
`product_id` int(10) unsigned NOT NULL,
`product_attribute_id` int(10) unsigned default NULL,
`product_name` varchar(255) NOT NULL,
`product_quantity` int(10) unsigned NOT NULL default '0',
`product_quantity_in_stock` int(10) unsigned NOT NULL default '0',
`product_quantity_refunded` int(10) unsigned NOT NULL default '0',
`product_quantity_return` int(10) unsigned NOT NULL default '0',
`product_quantity_reinjected` int(10) unsigned NOT NULL default '0',
`product_price` decimal(20,6) NOT NULL default '0.000000',
`reduction_percent` decimal(10,2) NOT NULL default '0.00',
`reduction_amount` decimal(20,6) NOT NULL default '0.000000',
`group_reduction` decimal(10,2) NOT NULL default '0.00',
`product_quantity_discount` decimal(20,6) NOT NULL default '0.000000',
`product_ean13` varchar(13) default NULL,
`product_reference` varchar(32) default NULL,
`product_supplier_reference` varchar(32) default NULL,
`product_weight` float NOT NULL,
`tax_name` varchar(16) NOT NULL,
`tax_rate` decimal(10,3) NOT NULL default '0.000',
`ecotax` decimal(21,6) NOT NULL default '0.000000',
`ecotax_tax_rate` decimal(5,3) NOT NULL,
`discount_quantity_applied` tinyint(1) NOT NULL default '0',
`download_hash` varchar(255) default NULL,
`download_nb` int(10) unsigned default '0',
`download_deadline` datetime default '0000-00-00 00:00:00',
PRIMARY KEY (`id_order_detail`),
KEY `order_detail_order` (`id_order`),
KEY `product_id` (`product_id`),
KEY `product_attribute_id` (`product_attribute_id`),
KEY `id_order_id_order_detail` (`id_order`,`id_order_detail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

cordialement

Link to comment
Share on other sites

  • 2 months later...

Voici la solution
dans le fichier config/settings.inc.php
tu définie la version 1.3.0.0

define('_PS_VERSION_', '1.3.0.0');



ensuite tu lance une mise à jour en allant sur

www.maboutique.com/install



voire capture d'image ci-jointe

et le problème est réglé

43167_XrAquHhA6ZOK9whKv84y_t

Link to comment
Share on other sites

  • 3 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...