I have a shop currently using 0.7.6 and need advise on how to upgrade it to 0.7.current.. while keeping all the current database data intact.
an initial attempt of using the 0.7.6 database with 0.7.8 resulted in a few 'undefined index' errors in the admin.. and i expect more i haven't found yet.
i remember reading a few posts about there being databass structure changes with the later versions of opencart? or something.
any help / instructions would be very much appreciated.
thanks a lot.
an initial attempt of using the 0.7.6 database with 0.7.8 resulted in a few 'undefined index' errors in the admin.. and i expect more i haven't found yet.
i remember reading a few posts about there being databass structure changes with the later versions of opencart? or something.
any help / instructions would be very much appreciated.
thanks a lot.
i've followed the instructions but i'm getting a few errors.
when i looked at past orders in the admin, i got 3 undefined index errors about discounts or something. Then when i checked the catalogue, i tried adding a product to the cart and it gave me this error:
and since then that error comes up no matter where i navigate to on the site through the url. even going to the homepage brings that up.
is this to do with the database restructuring i mentioned above?
Thanks for any help.
when i looked at past orders in the admin, i got 3 undefined index errors about discounts or something. Then when i checked the catalogue, i tried adding a product to the cart and it gave me this error:
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
is this to do with the database restructuring i mentioned above?
Thanks for any help.
Last edited by salmoon on Thu Nov 13, 2008 8:43 pm, edited 1 time in total.
I guess daniel didn't include any SQL upgrading considerations between versions...
You need to create the table by using the following SQL:
You need to create the table by using the following SQL:
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;
excellent that worked. thankyou.
now it seems the only other problem im having with the upgrading is the error i get when looking at previous orders
shown at the top of the page.
any ideas?
now it seems the only other problem im having with the upgrading is the error i get when looking at previous orders
shown at the top of the page.
Code: Select all
Notice: Undefined index: discount in /home/catrin/public_html/079/admin/controller/order.php on line 426
any ideas?
ha ha. thanks guys.
so now i've successfully upgraded to 0.7.9RC3.
however, i'm still having problems with the Paypal IPN bug.
I've just installed the "paypal improved" module but it doesn't appear to have made any difference... orders are still not getting processed until the user returns to the shop after paypal.
I'm using the sandbox to test this.
Have i missed something?
so now i've successfully upgraded to 0.7.9RC3.
however, i'm still having problems with the Paypal IPN bug.
I've just installed the "paypal improved" module but it doesn't appear to have made any difference... orders are still not getting processed until the user returns to the shop after paypal.
I'm using the sandbox to test this.
Have i missed something?
After rummaging through the forums i found this suggestion:
(http://forum.opencart.com/index.php/top ... ml#msg8841)
In paypal improved - paypal.php Replace:
with:
So i did this, placed a test order without returning to the shop after paying.. and the order actually got processed with a status of "Processing"!!
i don't know if this is the IPN calling back now? or why it's now working after replacing that bit of code?
(http://forum.opencart.com/index.php/top ... ml#msg8841)
In paypal improved - paypal.php Replace:
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();
}
So i did this, placed a test order without returning to the shop after paying.. and the order actually got processed with a status of "Processing"!!
i don't know if this is the IPN calling back now? or why it's now working after replacing that bit of code?
Who is online
Users browsing this forum: No registered users and 2 guests