mjjwatson Posted January 26, 2009 Share Posted January 26, 2009 Hi there, I'm a complete beginner with OS Commerce although I've taken on the task of moving and restyling someone's site, which includes a OSC shop. I don't imagine there should be too many problems, but wondering if someone helpful had a quick step guide to downloading and copying the database onto my computer for testing. Anything to look out for? Thanks in advance! Link to comment Share on other sites More sharing options...
taghosting Posted January 26, 2009 Share Posted January 26, 2009 There are quite a few problems that you may have to overcome. 1) Mysq 4.1.XXX db data being transfered to Mysql 5.0.67 for instance. You will need to convert your database with a free download called MySqladmin. 2) You will need to down load the full DB from the source so will need access to the DB logon details 3) You will need FTP logon details of the site Download all the data above. 4) Change the config.php files in the include directory of root and admin 5) Upload the save db data with MySqladmin 6 Upload the Site with FTP You should now have duplicate site to work on. Just ensure the config.php files have the chmod changed to protect the file I change to 644 If you get memory errors, create in notepad the file php.ini and put in the following memory_limit=120M You may also have a globals problem just put in the same file register_globals = On The ini file only works if your provider allows this. Trevor www.doctoremote.co.uk and www.taghosting.co.uk Hi there, I'm a complete beginner with OS Commerce although I've taken on the task of moving and restyling someone's site, which includes a OSC shop. I don't imagine there should be too many problems, but wondering if someone helpful had a quick step guide to downloading and copying the database onto my computer for testing. Anything to look out for? Thanks in advance! Link to comment Share on other sites More sharing options...
wex Posted January 26, 2009 Share Posted January 26, 2009 Should be fairly easy :) 1. Database Backup/Export - Phpmyadmin is fairly simple to use. 2. Website backup/copy with FTP 3. Change includes/configure.php and admins/includes/configure.php in copied folder to match the new testing settings BE SURE to know that there is quite some things to fix if the old site is php4 and new is php5 and the same for Mysql Link to comment Share on other sites More sharing options...
mjjwatson Posted January 26, 2009 Author Share Posted January 26, 2009 If you get memory errors, create in notepad the file php.ini and put in the following memory_limit=120M You may also have a globals problem just put in the same file register_globals = On Hi! Thanks for your help. Everything's looking good, the sql is imported without errors and seems fine. I am getting that register_globals problem though. I've put a php.ini file into the root catalog folder and altered the htaccess file, but to no avail. Any tips as to why this is happening? Thanks! Link to comment Share on other sites More sharing options...
mjjwatson Posted January 26, 2009 Author Share Posted January 26, 2009 Hi! Thanks for your help. Everything's looking good, the sql is imported without errors and seems fine. I am getting that register_globals problem though. I've put a php.ini file into the root catalog folder and altered the htaccess file, but to no avail. Any tips as to why this is happening? Thanks! To add to this... I've checked my php settings on my computer's set up: Loaded Configuration File /Applications/MAMP/conf/php5/php.ini It also says register_globals = off. I open up php.ini in the php5 folder, and it reads: register_globals = On. Very odd. Grrrrrr Link to comment Share on other sites More sharing options...
Guest Posted January 26, 2009 Share Posted January 26, 2009 To add to this... I've checked my php settings on my computer's set up: It also says register_globals = off. I open up php.ini in the php5 folder, and it reads: . Very odd. Grrrrrr You may have to stop and restart the server (I know this is the case with wamp). Link to comment Share on other sites More sharing options...
mjjwatson Posted January 26, 2009 Author Share Posted January 26, 2009 You may have to stop and restart the server (I know this is the case with wamp). Brilliant. Thank you so much :) It's all alive now on my computer. Well, semi alive. The home page of the catalogue loads up okay, apart from a couple of inexplicable images that aren't showing up... and although the old, imported categories are displaying, which IMPLIES that everything is in working order, any clickable link comes up with "...was not found on this server" message. I feel that the rather messy configure.php file is a little wrong. I would be so indebted if someone could help look over it! I'm hosting on my localhost for the time being, in a subdomain called "catalog." <?php define('HTTP_SERVER', 'http://localhost:8888'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'http://localhost:8888'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'localhost'); define('HTTPS_COOKIE_DOMAIN', 'localhost'); define('HTTP_COOKIE_PATH', '/catalog/'); define('HTTPS_COOKIE_PATH', '/catalog/'); define('DIR_WS_HTTP_CATALOG', '/catalog/'); define('DIR_WS_HTTPS_CATALOG', '/catalog/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_TEMPLATES', 'templates/'); define('DIR_WS_CONTENT', DIR_WS_TEMPLATES . 'content/'); define('DIR_WS_JAVASCRIPT', DIR_WS_INCLUDES . 'javascript/'); //End BTS1.0 define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/Applications/MAMP/htdocs/catalog/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'root'); define('DB_SERVER_PASSWORD', 'root'); define('DB_DATABASE', 'db_catalog'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?> Can't wait to get this thing up and running so I can do the css tweaks I know and love! Link to comment Share on other sites More sharing options...
byke Posted January 27, 2009 Share Posted January 27, 2009 Brilliant. Thank you so much :) It's all alive now on my computer. Well, semi alive. The home page of the catalogue loads up okay, apart from a couple of inexplicable images that aren't showing up... and although the old, imported categories are displaying, which IMPLIES that everything is in working order, any clickable link comes up with "...was not found on this server" message. I feel that the rather messy configure.php file is a little wrong. I would be so indebted if someone could help look over it! I'm hosting on my localhost for the time being, in a subdomain called "catalog." Can't wait to get this thing up and running so I can do the css tweaks I know and love! if you find an answer to this, please post it up as i am interested too cheers Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.