Community Forums

by **larkin88** » Wed May 09, 2012 3:57 am

Qphoria wrote:A big thank you to forum member IBBoard for adding Product Option support to the 14x to 1512 upgrade script! Now you can upgrade from 1.4.x to 1.5.1.2 and KEEP YOUR PRODUCT OPTIONS!

YES, THIS SCRIPT WILL KEEP YOUR PRODUCT OPTIONS!
If your store has no product options, the script will still work for you.

About this script
This script is a collection of all the patches and versions of opencart from version 1.4.0 to version 1.5.1.2.
That means you run this script to bring your store's database to 1.5.1.2
If you want to install a version later than 1.5.1.2, that is fine. Just be sure that after you run this script, you run the installer that comes with the latest version of OpenCart. More info on that below...

READ CAREFULLY:
Only use this script if your store is running OpenCart v1.4.x
DO NOT USE THIS SCRIPT TO UPGRADE EXISTING 1.5.x STORES
This script includes a STEP-BY-STEP readme file. Follow it exactly!
This script will work as far back as OpenCart v1.4.0
This script works! There has never been a confirmed error.
If you see warnings or errors, they are false positives. Just ignore them. This script has been run enough times to know that it has no real errors.
Once you are upgraded, post any functionality bugs in the appropriate thread for your version, not here.

Upgrading to versions later than 1.5.1.2
As I said above, this script will bring your database to version 1.5.1.2
If you are installing straight to a later version, like 1.5.1.3, then you simply need to first follow the upgrade step by step guide from this Beta2, installing the latest version of opencart. Then after you complete this script, you can run the installer that comes with 1.5.1.3 or later.

1. Run this Beta3 Script first by following the step-by-step guide that comes with it
2. After following this Beta3 script, follow the upgrade.txt file that comes with the latest version of OpenCart.
3. Done!

What to Expect after upgrading from 1.4.x to 1.5.x
Your theme will be set to the default opencart 1.5.x theme
You will not see any modules or products on the homepage yet, only the header and footer.
You need to go into the Admin->Extensions->Modules page and add your modules to see products on the front.
Your products, categories, customers, orders will all be safe and viewable in the admin area
If you had any 3rd party modules from 1.4.x installed, you may see errors like "Document::setTitle". That means the module was not updated yet. You should uninstall it from the modules area and get the latest update from the author of the mod
There are new menus in the admin, so be sure to go through them.

when I type this to open
http://laptopsl400.com/install/upgrade-14x-to-15x.php

it shows me this erro

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`; Unknown column 'sort_order' in 'field list'

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`; Table 'laptopsl_larkin.product_option_description' doesn't exist

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`; Unknown column 'sort_order' in 'field list'

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`; Table 'laptopsl_larkin.product_option_value_description' doesn't exist

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!

by **tmart** » Wed May 09, 2012 7:48 am

Hi, I am running Opencart Ver 1.4.9.5 where I have re-named my admin folder. So, before uploading new ver folder files, shall I rename the admin folder to same as what is already running please? Thanks and regards / Tissy

by **platypuspuzzles** » Wed May 09, 2012 1:07 pm

Thanks for all the guidance and script creations that have helped make the upgrade to 1.5.2 almost seemless to a novice.

I have upgraded to 1.5.2.2 patch and have one last error to sort out.

2012-05-11 3:24:55 - PHP Notice: Undefined index: scheme in /home/.../public_html/catalog/controller/common/seo_url.php on line 110

Line 110 in this file is:

return $url_data['scheme'] . '://' . $url_data['host'] . (isset($url_data['port']) ? ':' . $url_data['port'] : '') . str_replace('/index.php', '', $url_data['path']) . $url . $query;

Can someone please tell me what I need to do to fix this?

by **platypuspuzzles** » Sat May 12, 2012 10:50 am

I have this error relating to product options too

viewtopic.php?f=19&t=62718&p=287875#p287875

by **Qphoria** » Sat May 12, 2012 9:24 pm

platypuspuzzles wrote:Thanks for all the guidance and script creations that have helped make the upgrade to 1.5.2 almost seemless to a novice.

I have upgraded to 1.5.2.2 patch and have one last error to sort out.

2012-05-11 3:24:55 - PHP Notice: Undefined index: scheme in /home/.../public_html/catalog/controller/common/seo_url.php on line 110
?

Did you make the config.php file changes to add HTTP_SERVER and HTTPS_SERVER? undefined schema means it can't find "http" or "https" on the url.

by **platypuspuzzles** » Sun May 13, 2012 12:44 am

Ahh thanks Qphoria, that makes sense.

My last issue relates to products options and autocomplete not working:

I had Alreadymade.com's Global Mega Options, which carried over into 'attributes and options' when running the upgrade script to 1.5.2.2patch.

I have no errors relating to the product options, however I cannot get catalog>product>options to work as nothing will appear when I 'add option'

I have tried to remove the options in order to start again, however I get the warning message 'linked to 1 product' - however no options are appearing anywhere on my products.

I have also noticed the autocomplete doesn't work in products, or by changing the paypal status like it used to before upgrading. I have checked the header file, and we have the correct ....16..file included.

Also, when I create new options, I can't get these to link to the products, so 'ignoring' the original options isn't an option, pardon the pun

Please help as I can not receive orders until this is fixed.

by **tenshimsm** » Sat May 19, 2012 11:25 am

Hi!
I upgraded from OC 1.4.9.4 to 1.5.1.2. Receive no error messages but when I finished the process there are no Categories and Products. They are in the database but are not shown in the admin page or in the store front.
What did I do wrong?

by **HansGruber** » Wed May 23, 2012 11:50 am

Hi

i've followed the steps and all seemed to work ok. i'm fairly fresh at opencart so i'm no expert and have noticed the following problem.

this is from the notes in the upgrade.txt for version 1.5.2.1

STEP 9. Goto Admin->System->Settings.
- Be sure to set the "Use Store Tax Address" and "Use Customer Tax Address" to "Shipping Address" (for most users) to ensure taxes work
- Update any other fields and click save, even if nothing changed.

i do this but get a little red box appear above saying
"Warning: Please check the form carefully for errors!"

don't know what errors these might be but when i go to...

Step 10. Goto Admin->System->Localisation->Tax Rates->Edit Existing rates
- Be sure to add a Tax Rate Name if empty
- Be sure to check the boxes for the customer groups that are affected by this tax rate

i just get a blank white page with nothing. clearly i've missed something but been very careful to follow each step.

cheers for any advice.

by **wbHH** » Fri May 25, 2012 5:32 pm

So far, everything went well. I ran the upgrade script and then the internal upgrade to the latest version 1.5.3.1.
And I can see the basic storefront: http://shop.wolfgangboenisch.de
But I can't go to the Admin-page (http://shop.wolfgangboenisch.de/admin/): Internal error HTTP500 - I cleared cache and cookies, pressed CTRL+F5 several times, but to no use.
Any idea how to fix it?
Thanks,
Wolfgang

by **affordable** » Sat May 26, 2012 2:12 pm

Hi,
Was upgrading for an old client who requires 2 sites upgraded

Received this error.

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/ireland5/public_html/mysite.com/config.php:2) in /home/ireland5/public_html/mysite.com/system/library/session.php on line 11

Thanks
Stephen

by **Qphoria** » Tue May 29, 2012 8:25 pm

some extra space in the config.php file?

by **Webnet** » Thu May 31, 2012 2:44 pm

-- REMOVED --

by **clarkie** » Tue Jun 19, 2012 10:53 am

Qphoria wrote:
mohit11 wrote:Hi,

I am upgrading from v1.4.9.1 to v1.5.1.2 using the ugrade script .
I get a success and then upgrade
STEP 12. RUN THE BUILT-IN OPENCART UPGRADE FOR v1.5.1.3 or LATER by visiting:
http://mysite.com/install/index.php

The problem is that I am losing all my data.

Kindly guide

If you are going to
http://mysite.com/install/index.php it should redirect you to
http://mysite.com/install/upgrade.php

if it isn't then you didn't follow the steps about restoring your config.php and admin/config.php files
If those files are empty, it assumes new install.
If those files have data, it assumed upgrade.
Sounds like your config files are empty which is why its making you install new and overwriting your data.

This is my problem also
I have ran the upgrade several times and made the required changes to the config file but I always end up with a fresh install. I have checked the config after the upgrade also if only to check up on myself that I did replace with the originals and the required data is there as it should be.

The one deviation is that I had changed my Admin DIR to something less obvious but before each upgrade attempt I revert back to original AND make the required path changes in the config file checking the site runs before I go with the upgrade. I must have done this seven or eight times now and visted the forum to get some ideas but it always leads back to the config file problem.

I figure it has to be something really stupid that I am just not seeing so any pointers you can give would be appreciated.

Current version is 1.4.9.4

Thank you

by **garulfo** » Mon Jul 09, 2012 8:37 pm

Just did the upgrade - it appeared to work fine - except that my store front has gone nuts. I can't work out how to fix it. Any help gratefully received!

http://www.strasbulles.fr/boutique/

by **Qphoria** » Tue Jul 10, 2012 4:02 am

garulfo wrote:Just did the upgrade - it appeared to work fine - except that my store front has gone nuts. I can't work out how to fix it. Any help gratefully received!

http://www.strasbulles.fr/boutique/

Looks like you still have 1.4.x file. Did you upload the new 1.5.3.1 files? Did you change your theme? Did you read the steps at all?

by **garulfo** » Tue Jul 10, 2012 7:20 am

Admin end looks fine and it says Version 1.5.3.1 at the bottom.

Next question (without the implied stupidity please).

by **georgeb2005** » Thu Jul 12, 2012 1:29 pm

Error: Unknown column 'o.currency' in 'field list'
Error No: 1054
SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS name, (SELECT os.name FROM _shoporder_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS status, o.date_added, o.total, o.currency, o.value FROM `_shoporder` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,10
What can i do.. please help me

by **Qphoria** » Fri Jul 13, 2012 2:50 pm

georgeb2005 wrote:Error: Unknown column 'o.currency' in 'field list'
Error No: 1054
SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS name, (SELECT os.name FROM _shoporder_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '2') AS status, o.date_added, o.total, o.currency, o.value FROM `_shoporder` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,10
What can i do.. please help me

That means you didn't upload the new files or are using a mod that only works with 1.4.x as it is still references the old query for "o.currency" but that has changed in 1.5.x

by **nikoloz** » Fri Jul 13, 2012 7:37 pm

Could you please help me?
I have blocked all my system, writes everywhere: Permission Denied! You do not have permission to access this page, please refer to your system administrator.
how can I remove this problem?

does not respond to user

by **robster** » Tue Jul 17, 2012 8:41 pm

I am trying to upgrade a 1.4.9 site to 1.5.3.1 (ultimately)

To start with I have used this upgrade script to upgrade to 1.5.1.3 and all seems to have gone ok, except that the tax is not showing correctly on the product pages. It shows ex tax and inc tax as same price - it should show tax at 10% as this is how the tax has been set. When I try to go through checkout it gets to step 4 and jumps back to step 3 so something is not quite right and I am not sure if the two things are connected.

I have checked that the tax settings are (I think) correct. What could I have done wrong?

Rob