Thanks! You're a gem.Qphoria wrote: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.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
?
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:
Can someone of you guys please help?
But when I go to the admin page, I get this error:
Which means that the query can't be succeeded because there is something wrong with the row store_id in setting.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
Can someone of you guys please help?
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
And If I try to login to the admin section I get the following error
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 !! :|
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
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 !! :|
Hmm the line is certainly in the script: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:Which means that the query can't be succeeded because there is something wrong with the row store_id in setting.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
Can someone of you guys please help?
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.
Why are you visiting your store after step 11? what about the rest of the steps? What version are you going to?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
And If I try to login to the admin section I get the following errorCode: 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
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 !! :|
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?
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?
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:
John
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:
- 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).
- Create a fresh install of your 1.4.x as if new
- 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)
- Import your database backup.
John
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
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.biggles wrote:A word of warning to all:
The backup advice contained in this script does not work.
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:, and the store (prior to upgrade) is working fine.. any ideas?
Thanks
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:
And when trying to open the store or admin site, I get the error :LINE 28: [8192] mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
I'm using the mmysqli driverFatal error: Class 'DBmmysqli' not found in /home/gwalkerc/public_html/store/system/library/db.php on line 13
Code: Select all
define('DB_DRIVER', 'mmysqli');
Thanks
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..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"
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
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.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
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
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
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
Also why would you go to 1.5.5.1? At the very least you should be going to 1.5.6.4
Q
You could... tho only the admin, catalog, and system folders.. don't delete your image folder or downloads.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.
Better would be to just rename to xadmin, xcatalog, xsystem so you still have a back up just in case.
Who is online
Users browsing this forum: No registered users and 4 guests