upgrading from 0.7.6

Code: Select all

Error: Table 'catrin_cart079.product_discount' doesn't exist
Error No: 1146
select * from product_discount where product_id = '6' and quantity <= '1' order by quantity desc limit 1

Code: Select all

CREATE TABLE `product_discount` (
  `product_discount_id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL,
  `quantity` int(4) NOT NULL,
  `discount` decimal(15,4) NOT NULL,
  PRIMARY KEY  (`product_discount_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Code: Select all

Notice: Undefined index: discount in /home/catrin/public_html/079/admin/controller/order.php on line 426

Code: Select all

ALTER TABLE `order_product` ADD `discount2` DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000' AFTER `price` ;

Code: Select all

$sql = "select `order_status_id` from `order_status` where `name` = '?' and `language_id` = '?'";
                $parsed = $this->database->parse($sql, $this->language->get('order_status_pending'), $this->language->getId()); 
                $results = $this->database->getRow($parsed);
                if ($results)
                {
                    $pendingStatus = $results['order_status_id'];
                }

Code: Select all

//
                //  Perhaps the IPN from paypal has arrived before the user has returned from
                //  the paypal web site OR the user has not returned at all. 
                //  In response to either case, we should load and process the order.
                //             
		$reference = $this->request->get('invoice', 'post');
                if ($this->order->load($reference))
                {
                    //  IPN is winner or customer never returned and IPN arrived.
                    //  default status should be Pending so the update below will have no
                    //  effect if we process the order here but the end result is still correct.
                    $this->order->process(); 
                }