[0.7.9RC3] Obsolete and duplicate entries in DB table order_status

Locked

3 posts Page 1 of 1

[0.7.9RC3] Obsolete and duplicate entries in DB table order_status

JNeuhoff

Guru Member

Posts

6753

Joined

Wed Dec 05, 2007 3:38 am

Post by JNeuhoff » Mon Oct 27, 2008 5:03 am

The initial OpenCart database table `order_status` is created from

Code: Select all

INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('7', '7', 'Pending');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('2', '7', 'Processing');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('2', '1', 'Processing');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('12', '1', 'Canceled');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('3', '7', 'Shipped');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('3', '1', 'Shipped');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('5', '7', 'Pending');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('9', '7', 'Pending');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('1', '1', 'Pending');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('12', '7', 'Canceled');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('16', '1', 'Complete');

However, there is no language_id = 7 in table `language`. Also, there are some duplicate entries for 'Pending'.

Instead, we should probably use this for `order_status` during the initial installation:

Code: Select all

INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('1', '1', 'Processing');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('2', '1', 'Canceled');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('3', '1', 'Shipped');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('4', '1', 'Pending');
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES ('5', '1', 'Complete');

See http://code.google.com/p/open-cart/issues/detail?id=90 for more details.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig