Guest Posted October 13, 2012 Share Posted October 13, 2012 Hi guys, I am undertaking a redesign job for a customer wanting to spruce up their website. As part of this, I need to upgrade the software they are using. I would like to know, how difficult is it? Are there any things I should know about beforehand? I have put the old systems database into the new software, and there don't seem to be many errors, but I don't want to chance it and assume there will be none. I am also having trouble logging into the admin account, it won't let me and keeps telling me to wait five minutes. I am very familiar with SQL and PHP, so sorting it out shouldn't be a problem, once I know what I have to do. I did see a thread from a couple of months ago, but I thought it best to start a new thread instead of revive a dead one. Cheers for any help guys. Jrdn Link to comment Share on other sites More sharing options...
Guest Posted October 13, 2012 Share Posted October 13, 2012 @@jrdnhannah Since there is no upgrade path from MS1 to v2.3.3, I assume you downloaded and installed v2.3.3 and then integrated the database. The admin password AND customer passwords more than likely WILL NOT WORK in the newer version as security updates have altered how passwords are saved and checked. So, you won't be able to use existing admin or customer information. So, create your new layout, integrate the categories and products and you should be ready to go. Chris Link to comment Share on other sites More sharing options...
Guest Posted October 15, 2012 Share Posted October 15, 2012 @@DunWeb Yeah, that's what I tried doing. Looking good so far. Apart from admin/customer issues, is there anything else I should know? Cheers Link to comment Share on other sites More sharing options...
Guest Posted October 15, 2012 Share Posted October 15, 2012 @@jrdnhannah I think that covers it. If you come across issues, post them. Chris Link to comment Share on other sites More sharing options...
Guest Posted October 24, 2012 Share Posted October 24, 2012 Sorry to high-jack, but OP states "I have put the old systems database into the new software". Is this recommended? Are there no schema changes between 2.2 and 2.3.3? If there are changes, is there a list of tables that should have their data migrated? Regards, Rob Link to comment Share on other sites More sharing options...
Guest Posted October 24, 2012 Share Posted October 24, 2012 @@rjben Yes there are database differences but an experienced SQL user can integrate the products and categories into the new database. Chris Link to comment Share on other sites More sharing options...
MrPhil Posted October 31, 2012 Share Posted October 31, 2012 You would have to list the schemas for both versions, and either edit the .sql file to conform, or make sure there are reasonable defaults for everything (if missing). AFAIK it's just a few items added to tables (and maybe a new table or two), not a major restructuring at any point. I have no experience with 2.2 MS1 (that is ancient!), so it's up to you to understand the old and new databases, and what the easiest/best path is to get your old data into the new database. Passwords might be a problem if hashing was added or changed, so you might need to generate new passwords in the new system and preserve those passwords when bringing in the old data. Like Chris said, it will take some thinking by someone reasonably experienced in SQL and maybe PHP. Link to comment Share on other sites More sharing options...
danil0 Posted December 27, 2012 Share Posted December 27, 2012 so finally what are we doing if we want to transfer all customers, orders history and general all data to new version 2.3.3 from an 2.2 osc. Is there a safe an deasy way to do it? Link to comment Share on other sites More sharing options...
MrPhil Posted December 27, 2012 Share Posted December 27, 2012 You need to understand tables and their usage between the two versions. Fortunately, most of the tables have not changed all that much. Then you have to map from the old schema to the new one (fields to add or change, default values, etc.). Update the CREATE TABLE statements in the .sql (backup), or just cut and paste in from the new database. Finally, you have to go through all the data (.sql backup file) and modify the INSERT INTO statements to add new columns, new tables, etc. per the schema changes. That last part is the biggest, but most mechanical, task. You end up with an .sql (backup) file of the 2.3.3 database schema (and your old store's data) that you can use to replace the default 2.3.3 database via a restore. Link to comment Share on other sites More sharing options...
danil0 Posted January 1, 2013 Share Posted January 1, 2013 You need to understand tables and their usage between the two versions. Fortunately, most of the tables have not changed all that much. Then you have to map from the old schema to the new one (fields to add or change, default values, etc.). Update the CREATE TABLE statements in the .sql (backup), or just cut and paste in from the new database. Finally, you have to go through all the data (.sql backup file) and modify the INSERT INTO statements to add new columns, new tables, etc. per the schema changes. That last part is the biggest, but most mechanical, task. You end up with an .sql (backup) file of the 2.3.3 database schema (and your old store's data) that you can use to replace the default 2.3.3 database via a restore. thank you for your help but is there any easier way to add customers and their history from old db 2.2 to new one 2.3? maybe a contribution? I am not the best sql writer.. Link to comment Share on other sites More sharing options...
MrPhil Posted January 1, 2013 Share Posted January 1, 2013 I don't know of any way to do this without having a firm understanding of SQL. What's in the database (the old schema) will depend on the exact version of the old osC, as well as any add-ons used that might have modified the tables. That's my understanding for why there isn't a tool to convert one schema to another. I would think that someone could write a PHP script to take the old database backup and the new one, and at least partially do the conversion (and tell the user where manual intervention would be needed). You would end up with a modified old backup (.sql file) that could be used to regenerate the old data under the new store. Or, the utility could read in the old database backup and directly modify and insert the data. There are all sorts of possibilities. Link to comment Share on other sites More sharing options...
Cheepnis Posted January 25, 2013 Share Posted January 25, 2013 Has anybody tried using Cart2Cart ? Is it a waste of money or a good solution? I'm trying to go from 2.2 MS2 to 2.3.3. I'm not afraid of getting my hands dirty, but if this actually works well, it may be worth the cost. Link to comment Share on other sites More sharing options...
MrPhil Posted January 26, 2013 Share Posted January 26, 2013 So this is a service to move you from one cart to another? You would probably be much better off installing 2.3.3 and migrating a copy (.sql backup) of the database. If you'd rather migrate the 2.2 to 2.3.3 because you have a lot of add-ons and custom coding, you're going to pay a fortune to these guys (or in your own time) to do the job (and you end up with a frankenstore). Try a pure 2.3.3 with your old data and see if you need to add anything to it. Link to comment Share on other sites More sharing options...
♥bruyndoncx Posted January 26, 2013 Share Posted January 26, 2013 I used sqldiff tool to compare my MS2 db with the standard installed 2.3.3 I restored a live copy into a test system and modified it keeping track of the sql changes I executed until I got it funnctioning with the standard 2.3.3 php code. I altered my existing tables, adding fields where required, filling in defaults, changing field lengths in a few places if I remember well. The database scheme changes are all easy to do, the most tricky part for me was merging the configuration and configuration group tables contents. Once I was happy with it and ready to move everything over to production, I only needed to execute the same statements on my live database KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.