Post by uglyeoin » Thu Feb 19, 2015 7:39 pm

Qphoria wrote:
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.
Thanks! You're a gem.

Newbie

Posts

Joined
Mon Jun 23, 2014 5:13 pm

Post by stefvdwel » Thu Feb 26, 2015 2:59 am

Hey guys,
I'm exactly following the txt file which says STEP 8. FIND: // DIR
But what is this thing and where can I find it?
Thanks :)

Newbie

Posts

Joined
Thu Feb 26, 2015 2:56 am

Post by stefvdwel » Thu Feb 26, 2015 3:52 am

Hey guys, I just got to STEP 13 and the script told me success.
But when I go to the admin page, I get this error:
Notice: Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0' in /home/mywebsite/domains/mywebsite.be/public_html/update/system/database/mysql.php on line 50
Which means that the query can't be succeeded because there is something wrong with the row store_id in setting.
Can someone of you guys please help?

Newbie

Posts

Joined
Thu Feb 26, 2015 2:56 am

Post by opencartn00b » Thu Mar 19, 2015 5:00 am

Hello Every one ,

Ive followed the guide up to >>


STEP 11a. IF it shows "SUCCESSFUL" then continue to the next step.

I did get the "SUCESSFUL" image . Now when I clicked to visit my store I have a whole load of errors on the header

Code: Select all

Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11
And If I try to login to the admin section I get the following error

Code: Select all

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 order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS status, o.date_added, o.total, o.currency, o.value FROM `order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,10

The website was running version 1.4.9 before running the update script ...

Now I'm panicing and the website has all gone weird and the worst thing is its not my website !!! PLEASE CAN SOME ONE HELP ME !!!



*** TRIED TO RESTORE PREVIOUS MYSQL BACKUP - STILL SHOWING LOADS OF ERRORS !! :|

Newbie

Posts

Joined
Thu Mar 19, 2015 4:57 am

Post by Qphoria » Thu Mar 26, 2015 10:11 pm

stefvdwel wrote:Hey guys, I just got to STEP 13 and the script told me success.
But when I go to the admin page, I get this error:
Notice: Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0' in /home/mywebsite/domains/mywebsite.be/public_html/update/system/database/mysql.php on line 50
Which means that the query can't be succeeded because there is something wrong with the row store_id in setting.
Can someone of you guys please help?
Hmm the line is certainly in the script:
ALTER TABLE `oc_setting` ADD `store_id` int(11) NOT NULL DEFAULT '0' AFTER setting_id;

So if you ran the beta script and it showed success it certainly should have added it.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Qphoria » Thu Mar 26, 2015 10:12 pm

opencartn00b wrote:Hello Every one ,

Ive followed the guide up to >>


STEP 11a. IF it shows "SUCCESSFUL" then continue to the next step.

I did get the "SUCESSFUL" image . Now when I clicked to visit my store I have a whole load of errors on the header

Code: Select all

Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/model/checkout/extension.php on line 15Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_right.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11Notice: Undefined index: key in /var/www/vhosts/brightchoiceltd.com/httpdocs/catalog/controller/common/column_left.php on line 11
And If I try to login to the admin section I get the following error

Code: Select all

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 order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS status, o.date_added, o.total, o.currency, o.value FROM `order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,10

The website was running version 1.4.9 before running the update script ...

Now I'm panicing and the website has all gone weird and the worst thing is its not my website !!! PLEASE CAN SOME ONE HELP ME !!!



*** TRIED TO RESTORE PREVIOUS MYSQL BACKUP - STILL SHOWING LOADS OF ERRORS !! :|
Why are you visiting your store after step 11? what about the rest of the steps? What version are you going to?

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by zimbrul » Sat May 16, 2015 3:00 pm

The instructions do not make any sense to be honest:


STEP 4a. UNZIP AND UPLOAD ALL THE NEW OPENCART FILES OVER YOUR EXISTING FILES-What are these new opencart files? Are the two in the "install" folder?

STEP 4b. If you haven't already, Upload the install folder from the beta2 upgrade zip file

STEP 5. DELETE THE "NEW" config.php and admin/config.php files that come with the new files - What do you mean by "new files"? Are these in the install folder? In the install folder in the zip file only comes 2 files: upgrade-14x-to-15x.php and upgrade-14x-to-15x.sql

STEP 6. RENAME config.bak and admin/config.bak to "config.php" -I've just renamed .bak. Why do I rename them again?

Newbie

Posts

Joined
Sat May 16, 2015 2:25 pm

Post by biggles » Wed Jun 10, 2015 7:19 pm

A word of warning to all:

The backup advice contained in this script does not work. This is because the script changes the database fields and the database backup has no DROP TABLE or CREATE commands.

I recommend, if possible, taking a backup through phpMyAdmin or similar containing these commands.

Alternatively, the only way I can figure out to restore to 1.4.x, if you need to, is to:
  1. Start with a clean, empty database (I deleted and recreated, but not everybody will be able to do that, so it may be a time-consuming exercise).
  2. Create a fresh install of your 1.4.x as if new
  3. Upload your backed-up files, but do not overwrite anything that is there from your new install. This will ensure the new config files are undisturbed (for instance, I had a new password for the database)
  4. Import your database backup.
This worked for me . . .

John

Newbie

Posts

Joined
Mon Jan 24, 2011 1:58 pm

Post by Qphoria » Wed Jun 17, 2015 9:39 pm

zimbrul wrote:The instructions do not make any sense to be honest:


STEP 4a. UNZIP AND UPLOAD ALL THE NEW OPENCART FILES OVER YOUR EXISTING FILES-What are these new opencart files? Are the two in the "install" folder?

STEP 4b. If you haven't already, Upload the install folder from the beta2 upgrade zip file

STEP 5. DELETE THE "NEW" config.php and admin/config.php files that come with the new files - What do you mean by "new files"? Are these in the install folder? In the install folder in the zip file only comes 2 files: upgrade-14x-to-15x.php and upgrade-14x-to-15x.sql

STEP 6. RENAME config.bak and admin/config.bak to "config.php" -I've just renamed .bak. Why do I rename them again?

They make perfect sense if you actually read them.

4. Unzip the "new opencart" files.. this means the files you get from http://www.opencart.com/index.php?route ... d/download .. whatever version that may be.

5. Again you are going down the path of not reading.

6. In previous versions of opencart (when this readme was written) they didn't come with "config-dist.php" files... so if you tried to just upload the new files, you would have overwritten your REAL config files. This is no longer a requirement as 1.5.5 and later started using a "-dist" suffix to prevent accidental overwriting.

Step 5 and 6 can be skipped if upgrading to 1.5.5 or later as they have the -dist suffix now, but that shouldn't prevent you from properly reading step 4

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Qphoria » Wed Jun 17, 2015 9:44 pm

biggles wrote:A word of warning to all:

The backup advice contained in this script does not work.
The advice in the script says "BACKUP YOUR DATABASE"... it says nothing about the methods. Honestly I've never used the backup tool within opencart nor did I intend on its use for this script. I mean do a full phpmyadmin backup including all the drop/create table stuff.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by gazerooni » Tue Jun 23, 2015 1:11 pm

Hi all,
I have attempted the upgrade a few times now (restoring from backup after each failure). After running the upgrade script It says "SUCCESS", but above the "SUCCESS" text I continue to get the following error:
LINE 28: [8192] mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
And when trying to open the store or admin site, I get the error :
Fatal error: Class 'DBmmysqli' not found in /home/gwalkerc/public_html/store/system/library/db.php on line 13
I'm using the mmysqli driver

Code: Select all

define('DB_DRIVER', 'mmysqli');
, and the store (prior to upgrade) is working fine.. any ideas?

Thanks

Newbie

Posts

Joined
Tue Jun 14, 2011 7:31 pm

Post by Qphoria » Tue Jun 23, 2015 2:30 pm

The first warning is fine.. that is the whole point of your upgrade.
The second error is because there is no such thing as "mmysqli" it should be "mysqli"

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by gazerooni » Wed Jun 24, 2015 10:34 am

Qphoria wrote:The first warning is fine.. that is the whole point of your upgrade.
The second error is because there is no such thing as "mmysqli" it should be "mysqli"
I just changed the line to mysqli and it has worked - Thanks heaps! Can't understand how my store has been working all this time with mmysqli though..

Newbie

Posts

Joined
Tue Jun 14, 2011 7:31 pm

Post by ocartman » Wed Aug 05, 2015 1:17 am

Ran the script from 1.4.9.5 to 1.5.6
everything went good except the storefront shows erros

Notice: Constant HTTP_SERVER already defined in /home/rccarbon/public_html/store/index.php on line 54

Notice: Constant HTTP_IMAGE already defined in /home/rccarbon/public_html/store/index.php on line 55

Notice: Constant HTTPS_SERVER already defined in /home/rccarbon/public_html/store/index.php on line 61

Notice: Constant HTTPS_IMAGE already defined in /home/rccarbon/public_html/store/index.php on line 62
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/rccarbon/public_html/store/index.php:54) in /home/rccarbon/public_html/store/system/library/session.php on line 11
Fatal error: Call to a member function link() on a non-object in /home/rccarbon/public_html/store/catalog/controller/error/not_found.php on line 12

Active Member

Posts

Joined
Fri Oct 15, 2010 12:01 am

Post by Qphoria » Wed Aug 05, 2015 1:26 am

ocartman wrote:Ran the script from 1.4.9.5 to 1.5.6
everything went good except the storefront shows erros

Notice: Constant HTTP_SERVER already defined in /home/rccarbon/public_html/store/index.php on line 54

Notice: Constant HTTP_IMAGE already defined in /home/rccarbon/public_html/store/index.php on line 55

Notice: Constant HTTPS_SERVER already defined in /home/rccarbon/public_html/store/index.php on line 61

Notice: Constant HTTPS_IMAGE already defined in /home/rccarbon/public_html/store/index.php on line 62
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/rccarbon/public_html/store/index.php:54) in /home/rccarbon/public_html/store/system/library/session.php on line 11
Fatal error: Call to a member function link() on a non-object in /home/rccarbon/public_html/store/catalog/controller/error/not_found.php on line 12
This means you didn't follow all the steps. You altered the config.php file but didn't upload the new opencart files yet.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by ocartman » Wed Aug 05, 2015 1:57 am

The new files were uploaded, the admin side shows products etc but has errors in the module section as well.
the admin side showing updated to V1.5

Active Member

Posts

Joined
Fri Oct 15, 2010 12:01 am

Post by ocartman » Wed Aug 05, 2015 3:54 am

Restored back to V1.4.9 then tried to upgrade to V1.5.5.1
All the upgrade stated success and my admin shows V1.5.5.1

Here is an error in the cart Module:
Fatal error: Cannot access private property Document::$title in /home/rccarbon/public_html/store/admin/controller/module/cart.php on line 8

Active Member

Posts

Joined
Fri Oct 15, 2010 12:01 am

Post by Qphoria » Wed Aug 05, 2015 5:12 am

That is because the cart module is not a 1.5.x module. It was discontinued after 1.4.x so you'll need to delete that one (and manufacturer module). Anytime you see that error about " Cannot access private property Document::$title" that means you are trying to edit a 1.4.x module on 1.5.x or later.

Also why would you go to 1.5.5.1? At the very least you should be going to 1.5.6.4

Q

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by ocartman » Wed Aug 05, 2015 5:30 am

Should i just delete the folder with the OC 1.4 store and install OC 1.5 then upload config files?

I would rather not have all the old modules that dont belong anyway.

Active Member

Posts

Joined
Fri Oct 15, 2010 12:01 am

Post by Qphoria » Wed Aug 05, 2015 5:50 am

ocartman wrote:Should i just delete the folder with the OC 1.4 store and install OC 1.5 then upload config files?

I would rather not have all the old modules that dont belong anyway.
You could... tho only the admin, catalog, and system folders.. don't delete your image folder or downloads.
Better would be to just rename to xadmin, xcatalog, xsystem so you still have a back up just in case.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: Google [Bot] and 35 guests