chrisrobertson Posted July 30, 2006 Share Posted July 30, 2006 I am attempting to install os commerce windows. However, the installation file keeps telling SQL file does not exist: /install/oscommerce.sql Link to comment Share on other sites More sharing options...
♥Vger Posted July 30, 2006 Share Posted July 30, 2006 Stock answer: You are probably trying to install on a Windows server.If they were people - they wouldn't be able to find their own way home. You need to edit install/templates/pages/install_3.php and where you see: $sql_file = $dir_fs_www_root . 'install/oscommerce.sql'; Edit it to (change /path_to_root/ to real path): $sql_file = '/path_to_root/install/oscommerce.sql'; You will need to know the path to the root of your website. Check with your hosting company if you don't know. Vger Link to comment Share on other sites More sharing options...
kallah Posted July 30, 2006 Share Posted July 30, 2006 Stock answer: Hi...joining in (same problem, on apple mac)...when you say "change /path_to_root/ to real path)", do you mean the full URL ie /sitename/htdocs/catalog/install/install.sql ???...'cos I get the same error result ......Thanks, hope you can correct me. Link to comment Share on other sites More sharing options...
kallah Posted July 30, 2006 Share Posted July 30, 2006 Hi...joining in (same problem, on apple mac)...when you say "change /path_to_root/ to real path)", do you mean the full URL ie /sitename/htdocs/catalog/install/install.sql ???...'cos I get the same error result ......Thanks, hope you can correct me. I have something to add that is probably crucial: my ISP's server requires vpn access before I get to any MySQL tables. Unfortunately, making a vpn connection kills the browser connection because I have to select the 'all traffic thro' vpn' option in order to talk to the database. How do I get around that?....Thanks Link to comment Share on other sites More sharing options...
♥Vger Posted July 30, 2006 Share Posted July 30, 2006 Short answer = "Yes". Once that file is edited you can run the install as normal by going to http://www.yourdomain.com/install Vger Hi...joining in (same problem, on apple mac)...when you say "change /path_to_root/ to real path)", do you mean the full URL ie /sitename/htdocs/catalog/install/install.sql ???...'cos I get the same error result ......Thanks, hope you can correct me. Link to comment Share on other sites More sharing options...
chrisrobertson Posted July 30, 2006 Author Share Posted July 30, 2006 I was able to get past the not able to locate the sql file, but now I have this error message: Table 'websoftosc1.configuration' doesn't exist What should I do now? Link to comment Share on other sites More sharing options...
chrisrobertson Posted July 30, 2006 Author Share Posted July 30, 2006 I was able to get past this error by manually installing the sql file. But now one problem still remains, Unable to connect to database server! Link to comment Share on other sites More sharing options...
kallah Posted July 30, 2006 Share Posted July 30, 2006 Short answer = "Yes". Once that file is edited you can run the install as normal by going to http://www.yourdomain.com/install Vger Sorry, still don't get it. I put in : $db_error = false; $sql_file = 'http://www.xxxxx.com/catalog/install/oscommerce.sql'; osc_set_time_limit(0); osc_db_install($db['DB_DATABASE'], $sql_file); = error! I simply don't understand what is wrong. Can you add more advice? Thanks. BTW, I don't understand the use of [] in this context ... or perhaps that is obvious :-) Link to comment Share on other sites More sharing options...
chrisrobertson Posted July 30, 2006 Author Share Posted July 30, 2006 Sorry, still don't get it.I put in : $db_error = false; $sql_file = 'http://www.xxxxx.com/catalog/install/oscommerce.sql'; osc_set_time_limit(0); osc_db_install($db['DB_DATABASE'], $sql_file); = error! I simply don't understand what is wrong. Can you add more advice? Thanks. BTW, I don't understand the use of [] in this context ... or perhaps that is obvious :-) The absolutel path i.e.: Lunix /home/yourusername/catalog/install or Windows: c:\yourusername\ not the url Link to comment Share on other sites More sharing options...
kallah Posted July 30, 2006 Share Posted July 30, 2006 The absolutel path i.e.: Lunix /home/yourusername/catalog/install or Windows: c:\yourusername\ not the url Hmmm... I'm grateful for the replies but i still don't get it. I need to know "You will need to know the path to the root of your website." in order to complete the following: $sql_file = '/path_to_root/install/oscommerce.sql'; You tell me that 'path to root' is my /home/username/catalog/install/oscommerce.php But I still don't understand what, in this context, 'path to root' is. 'oscommerce.sql' is in 'install' which is in 'catalog' which is in 'htdocs' with my ISP....so what is Thanks'path to root' if it isn't all the obviuous things I've tried? Sorry to be thick but this is starting to totally undermine my confidence in this software....:-( Thanks ..... Link to comment Share on other sites More sharing options...
chrisrobertson Posted July 30, 2006 Author Share Posted July 30, 2006 Hmmm... I'm grateful for the replies but i still don't get it.I need to know "You will need to know the path to the root of your website." in order to complete the following: $sql_file = '/path_to_root/install/oscommerce.sql'; You tell me that 'path to root' is my /home/username/catalog/install/oscommerce.php But I still don't understand what, in this context, 'path to root' is. 'oscommerce.sql' is in 'install' which is in 'catalog' which is in 'htdocs' with my ISP....so what is Thanks'path to root' if it isn't all the obviuous things I've tried? Sorry to be thick but this is starting to totally undermine my confidence in this software....:-( Thanks ..... The root path/absolute path is different for everybody. There are a few ways you can find out your absolute path. You can a) install perl diver (if on a lunix host) and find out all the information about your server B) contact your hosting company and request the root/absolutel path to your account Good Luck! Link to comment Share on other sites More sharing options...
♥Vger Posted July 30, 2006 Share Posted July 30, 2006 To find out the path to the root of your web do this: 1. Create a new text file on your desktop and rename it to something like cwd.php (ignore the warning about changing the file type). 2. Put this piece of code in it <?php $p = getcwd(); echo $p; ?> 3. Upload this file to the same folder or level that you put osCommerce in. 4. In your browser go to e.g. http://yourdomain.com/cwd.php and you'll see the full pathway written on the page you view. 5. Make a note of it and then delete the cwd.php file. but this is starting to totally undermine my confidence in this software It's not the software: a. You decided to install on a Windows server. b. Like all of us you will learn how to do things, but at the moment you are hampered by a lack of knowledge. This would be the same whichever piece of software you decided to install. Vger Link to comment Share on other sites More sharing options...
kallah Posted July 31, 2006 Share Posted July 31, 2006 To find out the path to the root of your web do this: 1. Create a new text file on your desktop and rename it to something like cwd.php (ignore the warning about changing the file type). 2. Put this piece of code in it <?php $p = getcwd(); echo $p; ?> 3. Upload this file to the same folder or level that you put osCommerce in. 4. In your browser go to e.g. http://yourdomain.com/cwd.php and you'll see the full pathway written on the page you view. 5. Make a note of it and then delete the cwd.php file. It's not the software: a. You decided to install on a Windows server. b. Like all of us you will learn how to do things, but at the moment you are hampered by a lack of knowledge. This would be the same whichever piece of software you decided to install. Vger Hi guys ... thanks ...made it ...to another problem: now I get another error and set of warnings of a similar kind: Warning: fopen(/htdocs/includes/configure.php) [function.fopen]: failed to open stream: No such file or directory in g:\Websites\londonopenhouse\htdocs\catalog\install\templates\pages\install_7.php on line 209 Warning: fputs(): supplied argument is not a valid stream resource in g:\Websites\londonopenhouse\htdocs\catalog\install\templates\pages\install_7.php on line 210 Warning: fclose(): supplied argument is not a valid stream resource in g:\Websites\londonopenhouse\htdocs\catalog\install\templates\pages\install_7.php on line 211 Warning: fopen(/htdocs/admin/includes/configure.php) [function.fopen]: failed to open stream: No such file or directory in g:\Websites\londonopenhouse\htdocs\catalog\install\templates\pages\install_7.php on line 259 Warning: fputs(): supplied argument is not a valid stream resource in g:\Websites\londonopenhouse\htdocs\catalog\install\templates\pages\install_7.php on line 260 Warning: fclose(): supplied argument is not a valid stream resource in g:\Websites\londonopenhouse\htdocs\catalog\install\templates\pages\install_7.php on line 261 The configuration was successful! line 209-211= $fp = fopen($dir_fs_document_root . 'includes/configure.php', 'w'); fputs($fp, $file_contents); fclose($fp); line 259-261= same code ?????? Any ideas what is going on now? Thanks Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.