core- Posted February 4, 2011 Share Posted February 4, 2011 Hi to all, i installed osc 2.3.1 on my local server and after customizing and populating with several products/categories, i want to upload this test box (catalog+database) to my web server. actually uploading e-shop/catalog directory is not a problem, but i wonder how to upload my existing test db from the local computer to the web server and how to connect it to the new server mydomain.com on the admin panel (hosting), there is only the option to create a new db (or list existing ones), no import. also, do i need to reconfigure any paths in osc ? thanks a lot in advance. Link to comment Share on other sites More sharing options...
Guest Posted February 4, 2011 Share Posted February 4, 2011 Create a new DB, it will be blank. Once created, you can import your existing database into it. The paths will need to be changed in the two configure.php files to reflect the new path and also need to have the database information changed. Chris Link to comment Share on other sites More sharing options...
core- Posted February 4, 2011 Author Share Posted February 4, 2011 Create a new DB, it will be blank. Once created, you can import your existing database into it. Thanks for the reply. Can you tell me how exactly to import the db ? Do i need some sql command ? In PhpMyAdmin on the hosting server i have only the option to upload a txt file: http://www.mediafire.com/i/?tab9u0mfcwng821 Link to comment Share on other sites More sharing options...
alex2621 Posted February 5, 2011 Share Posted February 5, 2011 create a blank db in your host panel. make sure you have a copy of your database as a gzip file, (seems to work better as a gzip file), from your localhost. On your host control panel goto phpmyadamin, goto your blank db and click on it. At the top of the page there should be a import tab, click on this and then follow the path to your backup db. This is where to upload it. If you already have a working version of OSC on your host, upload all your new files EXCEPT the two configure files. Please make sure that your db settings are the same in both configure files, your local version and host version. Hope this explains a little bit. the box that says file to import also says 'Imported file compression will be automatically detected from: None, gzip, bzip2, zip' Link to comment Share on other sites More sharing options...
core- Posted February 5, 2011 Author Share Posted February 5, 2011 Thank you for the response. I managed to import my database as an .sql file. Still, i can access the index file of the osc but not a single link on it. (all of links look like this: http://www.mydomain.com/e-shop/catalog/nameofthehostingserver.com/e-shop/catalog/index.php?cPath=22&osCsid=xxxxxxxxxxx'>http://www.mydomain.com/e-shop/catalog/nameofthehostingserver.com/e-shop/catalog/index.php?cPath=22&osCsid=xxxxxxxxxxx (an obvious duplication) The catalog folder has the following position: http://www.mydomain.com/e-shop/catalog and the server structure is the following: MySite/docroot/(here are all site files, including e-shop folder) The question is have i configured correctly the 2 configure.php files ? includes: HTTP_SERVER', 'http://www.mydomain.com); DIR_FS_CATALOG', 'http://www.mydomain.com/e-shop/catalog/'); also tried /e-shop/catalog and just '/' DB_SERVER', 'www.mydomain.com); also tried 'nameofthehostingserver.com' admin/includes: 'HTTP_SERVER', 'http://www.mydomain.com); 'HTTP_CATALOG_SERVER', 'http://www.mydomain.com); 'HTTPS_CATALOG_SERVER', 'http://www.mydomain.com); DIR_FS_DOCUMENT_ROOT', '/e-shop/catalog/'); also tried http://www.mydomain.com/e-shop/catalog/ and also MySite/docroot/e-shop/catalog DIR_FS_ADMIN', '/e-shop/catalog/admin/'); also tried http://www.mydomain.com/e-shop/catalog/admin and also MySite/docroot/e-shop/catalog/admin DIR_FS_CATALOG', '/e-shop/catalog/'); also tried http://www.mydomain.com/e-shop/catalog and also MySite/docroot/e-shop/catalog 'DIR_WS_CATALOG', '/e-shop/catalog/'); What parameters should i define in the 2 configure files ? Thanks p.s. i'm also waiting for the response of the hosting staff. Link to comment Share on other sites More sharing options...
alex2621 Posted February 6, 2011 Share Posted February 6, 2011 Okay i have had a look and done a comparison to mine, remember they all vary in setups, includes: HTTP_SERVER', 'http://www.mydomain.com); DIR_FS_CATALOG', 'http://www.mydomain.com/e-shop/catalog/'>http://www.mydomain.com/e-shop/catalog/'); also tried /e-shop/catalog and just '/' DB_SERVER', 'www.mydomain.com); also tried 'nameofthehostingserver.com' includes: 'HTTP_SERVER', 'http://www.mydomain.com'); line above looks okay. 'DIR_FS_CATALOG', 'http://www.mydomain.com/e-shop/catalog/'>http://www.mydomain.com/e-shop/catalog/'); also tried /e-shop/catalog and just '/' this line above i think should be: 'DIR_FS_CATALOG', 'MySite/docroot/'); 'DB_SERVER', 'www.mydomain.com'); also tried 'nameofthehostingserver.com' this line above i think should be: 'DB_SERVER', 'localhost'); beware as some some hosts alocate a specific name to the database host location i.e: 'hostuser12345' but this would have been listed when you setup a new database. admin/includes: 'HTTP_SERVER', 'http://www.mydomain.com); 'HTTP_CATALOG_SERVER', 'http://www.mydomain.com); 'HTTPS_CATALOG_SERVER', 'http://www.mydomain.com); DIR_FS_DOCUMENT_ROOT', '/e-shop/catalog/'); also tried http://www.mydomain.com/e-shop/catalog/'>http://www.mydomain.com/e-shop/catalog/ and also MySite/docroot/e-shop/catalog DIR_FS_ADMIN', '/e-shop/catalog/admin/'); also tried http://www.mydomain.com/e-shop/catalog/'>http://www.mydomain.com/e-shop/catalog/admin and also MySite/docroot/e-shop/catalog/admin DIR_FS_CATALOG', '/e-shop/catalog/'); also tried http://www.mydomain.com/e-shop/catalog and also MySite/docroot/e-shop/catalog 'DIR_WS_CATALOG', '/e-shop/catalog/'); admin/includes: 'HTTP_SERVER', 'http://www.mydomain.com'); line above looks okay. 'HTTP_CATALOG_SERVER', 'http://www.mydomain.com'); line above looks okay. 'HTTPS_CATALOG_SERVER', 'http://www.mydomain.com'); line above if you have an SSL certificate should start with 'https://'. 'DIR_FS_DOCUMENT_ROOT', '/e-shop/catalog/'); also tried http://www.mydomain.com/e-shop/catalog/'>http://www.mydomain.com/e-shop/catalog/ and also MySite/docroot/e-shop/catalog this line above i think should be: 'DIR_FS_DOCUMENT_ROOT', 'MySite/docroot/'); 'DIR_FS_ADMIN', '/e-shop/catalog/admin/'); also tried http://www.mydomain.com/e-shop/catalog/'>http://www.mydomain.com/e-shop/catalog/admin and also MySite/docroot/e-shop/catalog/admin this line above i think should be: 'DIR_FS_ADMIN', '/e-shop/catalog/admin/'); 'DIR_FS_CATALOG', '/e-shop/catalog/'); also tried http://www.mydomain.com/e-shop/catalog and also MySite/docroot/e-shop/catalog this line above i think should be: 'DIR_FS_CATALOG', 'MySite/docroot/'); 'DIR_WS_CATALOG', '/e-shop/catalog/'); this line above i think should be: 'DIR_WS_CATALOG', '/'); What parameters should i define in the 2 configure files ? Thanks p.s. i'm also waiting for the response of the hosting staff. The other way that i find makes it bit a simpler for me, is to install a completely fresh OSC site on your host, following the same steps as you did for your local server. Once this is setup, over write all your OSC files with your modified ones, please remember DO NOT OVERWRITE THE TWO CONFIGURE FILES ON YOR HOST, these are the ones you need to run the site on your host. The same goes for your local server. Make a backup of the configure files so you know where the orginal ones are. Also as a note, some of the single quotes were missing from the lines, i presume this is just a typing error. Hope it works for you Alex Link to comment Share on other sites More sharing options...
core- Posted February 6, 2011 Author Share Posted February 6, 2011 Hi I tried all those modifications, to no avail. Interesting, i can change the configuration files however i want (even to completely comment out those lines), but the links on index page look the same (as i noted above). Anyway, your idea to execute a new OSC installation on the host, is excellent. I'll try to do that and will report about results. Thanks once again. Link to comment Share on other sites More sharing options...
core- Posted February 6, 2011 Author Share Posted February 6, 2011 Ok, i successfully installed a fresh OSC from the host (and i created a new blank db). The Webserver Root Directory actually should be: /www/mydomain/MySite/docroot/catalog/ (this time i didn't create the container folder "e-shop") I deleted 'install' folder, but the host (linux) server seems to refuse changing permissions for the 2 configure.php files... Every time i try to set 444 (read for all), after clicking OK and checking the permissions, they remain unchanged (??) So this is probably the reason why i can't get to the index catalog page (although i can log in into the admin panel). It seems i have to wait until tomorrow for hosting provider staff to change the permissions :( p.s. one more question. i've noticed that every time i load a remote php file (via dreamweaver ftp) to edit it, dreamweaver shows the local path (D:/MyDocs/MySite/catalog/includes/configure.php) instead of remote path www.mydomain.com/catalog/includes/configure.php :o i even tried to remove the folder 'catalog' from the local 'MySite' folder to see what happens, but then dw creates a new folder named 'catalog' with only that one file i want to edit. is this regular ? Link to comment Share on other sites More sharing options...
core- Posted February 7, 2011 Author Share Posted February 7, 2011 Eventually i solved all issues by myself, and now only one left. It should have been an easy one, but... The DB has worked fine with croatian/serbian latin special characters on my local computer, with default collation latin1_swedish (i didn't know it's the default setting at all) and the charset in the language config php file was set to iso-8859-1 (as i found it's the only character set that shows all special letters - dont know why but utf8 didn't show all characters correctly /ŠŽ/). However, after importing the DB in the blank host DB (which also has latin1_swedish_ci collation) i can't get correct special characters on the OSC pages. They all are unrecognized (blank little squares in google chrome). I tried to change charset in language php to UTF-8 and latin1 without results. Default server settings are: MySQL charset: UTF-8 Unicode (utf8) MySQL connection collation: utf8_unicode_ci A guy from hosting support couldn't solve this problem and said he will forward it to the admin. Any thoughts ? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.