So in other words, just importing my old database into OpenCart 1.5x on Arvixe won't work? How would OC 1.5x react if I tried to use a 1.4x database? Would it just crash completely, or would there be some way for me to make it work?avvici -arvixe- wrote:Sounds about right. If you have any further questions feel free to ask.Purebeads wrote:It would seem that this is my only solution for upgrading to OpenCart 1.5 on Arvixe: To copy my installation of OpenCart 1.4 to Arvixe (from my old hosting company), then import my database from my old hosting company, and then run the script. Is that right?
Joe
The files have no relevance to the database, other than the config.php file. The beta upgrade from 1.4.x to 1.5.2.x only uses the config.php file to get the db information for upgrade. But to complete the process from the 1.5.2.x state to the latest state, you need to run the upgrade script that comes with your opencart install.
So if you just make a folder "myupdate" with the following structure:
/myupdate
/install
/config.php <--- copied from your 1.4.x site
and run the
http://mysite.com/myupdate/install/upgr ... to_15x.php file (whatever the file is named)
Then it should upgrade the database to 1.5.2.x level.
I "believe" you could just copy the "install" and "system" folders from the latest version of opencart and drop that into the myupdate folder and then run the http://mysite.com/myupdate/install/index.php and it should let you upgrade from 1.5.2.x to the current state.
Then you "should" technically be able to drop your current 1.5.x database and import this one and it should work.
So if you just make a folder "myupdate" with the following structure:
/myupdate
/install
/config.php <--- copied from your 1.4.x site
and run the
http://mysite.com/myupdate/install/upgr ... to_15x.php file (whatever the file is named)
Then it should upgrade the database to 1.5.2.x level.
I "believe" you could just copy the "install" and "system" folders from the latest version of opencart and drop that into the myupdate folder and then run the http://mysite.com/myupdate/install/index.php and it should let you upgrade from 1.5.2.x to the current state.
Then you "should" technically be able to drop your current 1.5.x database and import this one and it should work.
Hi Guys,
Tried upgrading from 1.4.9 to 1.5.6 and getting to following errors:
I ran the script once, tried multiple times (and yes i restored the backup before trying again).
Any ideas what is going on?
Love to hear from you.
Tried upgrading from 1.4.9 to 1.5.6 and getting to following errors:
I ran the script once, tried multiple times (and yes i restored the backup before trying again).
Any ideas what is going on?
Love to hear from you.
Code: Select all
OpenCart 1.x Upgrade Script (BETA)
The following errors occured:
Could not execute this query: INSERT INTO `option` (`option_id`, `type`, `sort_order`)SELECT `product_option_id`, "select", `sort_order` FROM `product_option`; Duplicate entry '339' for key 'PRIMARY'
Could not execute this query: INSERT INTO `option_description` (`option_id`, `language_id`, `name`)SELECT `product_option_id`, `language_id`, `name` FROM `product_option_description`; Duplicate entry '339-2' for key 'PRIMARY'
Could not execute this query: INSERT INTO `option_value` (`option_value_id`, `option_id`, `sort_order`)SELECT `product_option_value_id`, `product_option_id`, `sort_order` FROM `product_option_value`; Duplicate entry '1067' for key 'PRIMARY'
Could not execute this query: INSERT INTO `option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`)SELECT `pov`.`product_option_value_id` , `language_id` , `pov`.`product_option_id` , `name`FROM `product_option_value_description` AS `povd` INNER JOIN `product_option_value` AS `pov` ON `pov`.`product_option_value_id` = `povd`.`product_option_value_id`; Duplicate entry '1089-2' for key 'PRIMARY'
The above errors occurred because the script could not properly determine the existing state of those db elements. Your store may not need those changes. Please post any errors on the forums to ensure that they can be addressed in future versions!
OpenCart.com
Hi!
I'm trying too to upgrade from 1.4.9.1 to the last version but I'm getting a strange error:
Too many connection to database
And then it says than it can't connect.
Is the script too fast for may hosting provider? Can be the script delayed?
Thanks!
I'm trying too to upgrade from 1.4.9.1 to the last version but I'm getting a strange error:
Too many connection to database
And then it says than it can't connect.
Is the script too fast for may hosting provider? Can be the script delayed?
Thanks!
Try ignoring those errors. The errors say the adjustments are already therevioza wrote:Hi Guys,
Tried upgrading from 1.4.9 to 1.5.6 and getting to following errors:
I ran the script once, tried multiple times (and yes i restored the backup before trying again).
Any ideas what is going on?
Love to hear from you.
Code: Select all
OpenCart 1.x Upgrade Script (BETA) The following errors occured: Could not execute this query: INSERT INTO `option` (`option_id`, `type`, `sort_order`)SELECT `product_option_id`, "select", `sort_order` FROM `product_option`; Duplicate entry '339' for key 'PRIMARY' Could not execute this query: INSERT INTO `option_description` (`option_id`, `language_id`, `name`)SELECT `product_option_id`, `language_id`, `name` FROM `product_option_description`; Duplicate entry '339-2' for key 'PRIMARY' Could not execute this query: INSERT INTO `option_value` (`option_value_id`, `option_id`, `sort_order`)SELECT `product_option_value_id`, `product_option_id`, `sort_order` FROM `product_option_value`; Duplicate entry '1067' for key 'PRIMARY' Could not execute this query: INSERT INTO `option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`)SELECT `pov`.`product_option_value_id` , `language_id` , `pov`.`product_option_id` , `name`FROM `product_option_value_description` AS `povd` INNER JOIN `product_option_value` AS `pov` ON `pov`.`product_option_value_id` = `povd`.`product_option_value_id`; Duplicate entry '1089-2' for key 'PRIMARY' The above errors occurred because the script could not properly determine the existing state of those db elements. Your store may not need those changes. Please post any errors on the forums to ensure that they can be addressed in future versions! OpenCart.com
Hi,
It was successful when I ran the upgrade script. I followed every instruction closely, however it was only after I've installed the new theme that I realized that the product pages aren't working: http://prontocoffeemachines.com/
I am having this error -
2014-09-07 14:30:06 - PHP Notice: Error: Unknown column 'sort_order' in 'order clause'<br />Error No: 1054<br />SELECT * FROM product_image WHERE product_id = '89' ORDER BY sort_order ASC in /public_html/system/database/mysql.php on line 50
Could anyone help me with it?
It was successful when I ran the upgrade script. I followed every instruction closely, however it was only after I've installed the new theme that I realized that the product pages aren't working: http://prontocoffeemachines.com/
I am having this error -
2014-09-07 14:30:06 - PHP Notice: Error: Unknown column 'sort_order' in 'order clause'<br />Error No: 1054<br />SELECT * FROM product_image WHERE product_id = '89' ORDER BY sort_order ASC in /public_html/system/database/mysql.php on line 50
Could anyone help me with it?
Hej, I have upgraded from 1.5.5 to 1.5.6.4 and when i click on product this mesg comes up. should i need to insert this oc_product_profile in table or how can i fix this problem.
Notice: Error: Table 'carmedia_se.oc_product_profile' doesn't exist
Error No: 1146
SELECT `pd`.* FROM `oc_product_profile` `pp` JOIN `oc_profile_description` `pd` ON `pd`.`language_id` = 2 AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `oc_profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `product_id` = 81 AND `status` = 1 AND `customer_group_id` = 1 ORDER BY `sort_order` ASC in /customers/8/e/3/carmedia.se/httpd.www/system/database/mysql.php on line 50
Notice: Error: Table 'carmedia_se.oc_product_profile' doesn't exist
Error No: 1146
SELECT `pd`.* FROM `oc_product_profile` `pp` JOIN `oc_profile_description` `pd` ON `pd`.`language_id` = 2 AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `oc_profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `product_id` = 81 AND `status` = 1 AND `customer_group_id` = 1 ORDER BY `sort_order` ASC in /customers/8/e/3/carmedia.se/httpd.www/system/database/mysql.php on line 50
Car Multimedia System, Sales, Support & Installation
You should not be allowed to touch a computer if you can't read the readme file and the "ONLY FOR 1.4.x to 1.5.x UPGRADES" listed ad nauseum.carmedia wrote:Hej, I have upgraded from 1.5.5 to 1.5.6.4 and when i click on product this mesg comes up. should i need to insert this oc_product_profile in table or how can i fix this problem.
Qphoria wrote:You should not be allowed to touch a computer if you can't read the readme file and the "ONLY FOR 1.4.x to 1.5.x UPGRADES" listed ad nauseum.carmedia wrote:Hej, I have upgraded from 1.5.5 to 1.5.6.4 and when i click on product this mesg comes up. should i need to insert this oc_product_profile in table or how can i fix this problem.
Thank you, i could read this txt file, I am trying to fix this to follow this instructions,
Car Multimedia System, Sales, Support & Installation
Can anyone help with this?nick941741 wrote:Missing Product options.
I've run the script and it seemed to work perfectly, but when logging in and checking the products I notice that there are no product option listed either individually for products or under the options on the menu.
The DB still shows the options.
Any ideas?
Nick
It's getting kind of urgent now as the client wants to enhance the store and all the new features can't be added till I've managed to get the upgrade working with the product options.
I'm running a local copy of the store and upgrading locally too, using WAMP as a SQL server.
I can see the product options in the tables, but they are no longer connected to the the products.
Any help appreciated.
Nick
I've verified this in the code, and in the databases of a number of our clients' sites spanning several versions of 1.4 and 1.5. Seems like a bit of a big omission from this upgrade script. Without adjusting, all invoices from pre-upgrade will show the wrong amounts on each line. It doesn't affect the totals, but it's still a big error. For the UK, where items have 20% tax, it will add £20 to each line! This also affects some of the admin pages.
The fix is very simple, just stick this line at the end of upgrade-14x-to-15x.sql:
The fix is very simple, just stick this line at the end of upgrade-14x-to-15x.sql:
Code: Select all
UPDATE `oc_order_product` SET `tax` = (`total` * `tax` / 100);
It doesn't really matter... but I would do thisjmagro wrote:Forgive me for being dumb but do I run this script first and THEN install version 1.5x or do I first run the installation for 1.5 and THEN run this script.
1. Upload 1.5.x over the current 1.4.x version... overwriting all files.
2. Upload this beta script to the install folder that now exists
3. Run the beta script at http://mysite.com/install/upgrade-14x-to-15x.php
4. Run the default opencart installer at http://mysite.com/install/index.php
5. Login to Admin
Follow the rest of the steps from the guide.
Hello and thank you for the script,
Just upgraded from v1.4.9.1 to v1.5.6.4 and everything seems OK but cannot change some of the settings in System/Settings:
1. Store Tab - can't change the theme of the store
2. Option Tab / TAXES - Display Prices With Tax - can't switch to YES to show princes with tax.
when trying to save some of that options the message is "Please check carefully for errors"
The problem with the option "Display Prices With Tax" existed on v1.4.9.1 and I thought the upgrade will fix that problem but that option still don't react and got error message. Is it possible to reset settings to default open cart settings or anything else I can do at least to change the theme. Everything else works fine so thanks again.
Just upgraded from v1.4.9.1 to v1.5.6.4 and everything seems OK but cannot change some of the settings in System/Settings:
1. Store Tab - can't change the theme of the store
2. Option Tab / TAXES - Display Prices With Tax - can't switch to YES to show princes with tax.
when trying to save some of that options the message is "Please check carefully for errors"
The problem with the option "Display Prices With Tax" existed on v1.4.9.1 and I thought the upgrade will fix that problem but that option still don't react and got error message. Is it possible to reset settings to default open cart settings or anything else I can do at least to change the theme. Everything else works fine so thanks again.
Who is online
Users browsing this forum: No registered users and 136 guests