Tuan Le Posted December 12, 2003 Share Posted December 12, 2003 Hi guys, I am trying to install OSC 2.2 MS2 onto my Win2003 server. The server is running MySQL 4.0.16 and PHP 4.3.4 via ISAPI. I extracted all the files from the OSC zip download to c:\web-directory\catalog. Set up the php.ini to have the register_globals turn on. Set the permissions to let the anonymous IIS account have access to all the files. Run the install, pick "a new online store". Hit continue. Fill in all the info for the database server. Hit continue and it shows "A test connection made to the database was successful.". Hit continue and then I run into the error below. Database Import The following error has occurred: SQL file does not exist: /install/oscommerce.sql I checked under the install directly and sure enough, the oscommerce.sql file is there. Double check the permission and everyone does have access to it. :( Any help you can give me would be greatly appreciated. Thanks -Tuan Link to comment Share on other sites More sharing options...
ale1981 Posted December 12, 2003 Share Posted December 12, 2003 You could try adding the sql queries into the db manually using a program like phpMyAdmin or something similar. Link to comment Share on other sites More sharing options...
ylpoplove Posted December 16, 2003 Share Posted December 16, 2003 i had the same problem :( i try to do that used the phpmyadmin to adding the wql queries into db manually, but the problem still on:( who can help me :) thx Link to comment Share on other sites More sharing options...
Guest Posted December 16, 2003 Share Posted December 16, 2003 you can go to mysql.com and then get the mysql connector, however you need to be able to create the database first on the server somehow. do you know how to access mysql from graphics or command prompt? you can create a database there, then add the user with rights, then using a sql query, install the database.l Link to comment Share on other sites More sharing options...
Tuan Le Posted December 16, 2003 Author Share Posted December 16, 2003 I do have MySQL 4.0.16 installed on my Windows 2003 server along with PHP 4.3.4 with it. The database is there with the user account assigned with full permission. The user acount can connect to the database just fine. However, when I always run into the "SQL file does not exist: /install/oscommerce.sql" error during set up. I also tried importing "oscommerce.sql" file into the database first and then run install. However, I don't have any luck going this route either. After the set, at the last screen that give the 2 options "Catalog" or "Administration Tools", I get a blank screen picking either choices. :( Has any got it installed successful on Windows 2003 ever? Link to comment Share on other sites More sharing options...
Tuan Le Posted December 16, 2003 Author Share Posted December 16, 2003 ttt Link to comment Share on other sites More sharing options...
Guest Posted December 17, 2003 Share Posted December 17, 2003 if you checked install database files and sample data, then it connected fine, it may have over written the sql database. once you get to the catalog or admin screen, exit there, then reinstall the database. easiest way is to drop the database then recreate the database and then run the sql query to get the data into the database (open the sql file in the install in wordpad, select all, copy, then paste it into the sql query screen), make sure you have the database selected, then execute the query Link to comment Share on other sites More sharing options...
JamesHenry Posted December 17, 2003 Share Posted December 17, 2003 Im also having the same problem as Tuan Le, im going to delete the database and try to reinstall OSC :). Lets hope it works! update I tried it and had no success. is the oscommerce.sql supposed to be a text file? Imagination Breeds Revolution -Me Link to comment Share on other sites More sharing options...
JamesHenry Posted December 17, 2003 Share Posted December 17, 2003 Anyone know what to do? Imagination Breeds Revolution -Me Link to comment Share on other sites More sharing options...
Guest Posted December 17, 2003 Share Posted December 17, 2003 If you are able to use MySqlcc.exe to hit the database you can get oscommerce.sql to install manually. 1)Open a connection to the server and manually create the database. 2)using mysqlcc connect to the database and "open" it. At this point there should be no tables listed. 3)click on the database so it is highlighted and click on the SQL button in the toolbar. This will open a text box where you can enter SQL queries manually. 4) open oscommerce.sql and copy the contents of the file. 5) click i nthe SQL textbox in mysqlcc and paste the text from os~.sql The syntax highlighting should warn you if you accidentally copied incorrectly. click the excecute "!" button and the bell should start ringing for each successful query. at the bottom of the window you should see the prgress as mysql returns log entries for each query. when it completes refresh the tree view on the server window and you should see the tables for the database have been created correctly. Fred Link to comment Share on other sites More sharing options...
JamesHenry Posted December 17, 2003 Share Posted December 17, 2003 I dont use MySqlcc.exe, however I did do what you said through phpMyAdmin. Sorry if this sounds stupid, I just started this php stuff literally 2 days ago. I checked it all and everything is correct, however, what do I do next? I tried the install way through the insaller that came with osCommercem, however it still couldnt find the oscommerce file. Imagination Breeds Revolution -Me Link to comment Share on other sites More sharing options...
Guest Posted December 17, 2003 Share Posted December 17, 2003 If you have manually installed the database, when you run the install, do not import the database. See if that works for you. Link to comment Share on other sites More sharing options...
JamesHenry Posted December 17, 2003 Share Posted December 17, 2003 That worked, atleast until I got to the: osCommerce Configuration The configuration was successful! The cataloge button takes me back to installation and the Admin tools takes me to a page saying: Unable to connect to database server! Imagination Breeds Revolution -Me Link to comment Share on other sites More sharing options...
Tuan Le Posted December 17, 2003 Author Share Posted December 17, 2003 If you are able to use MySqlcc.exe to hit the database you can get oscommerce.sql to install manually. 1)Open a connection to the server and manually create the database. 2)using mysqlcc connect to the database and "open" it. At this point there should be no tables listed. 3)click on the database so it is highlighted and click on the SQL button in the toolbar. This will open a text box where you can enter SQL queries manually. 4) open oscommerce.sql and copy the contents of the file. 5) click i nthe SQL textbox in mysqlcc and paste the text from os~.sql The syntax highlighting should warn you if you accidentally copied incorrectly. click the excecute "!" button and the bell should start ringing for each successful query. at the bottom of the window you should see the prgress as mysql returns log entries for each query. when it completes refresh the tree view on the server window and you should see the tables for the database have been created correctly. Fred Hi Fred, That is exactly how I did it, step by step. Deleted the old database. Created a new one and connect to it. Open up the SQL query window and tell it to run/import from OScommerce.sql file. It went through without a single hiccup. However, I still do not have any luck running the web setup. Run(http://www.mywebsite.com/catalog/install). Chose not to import the database. Go through all the steps. Got to the last screen, "Catalog" or "Admin Tools". Either button will take me to a blank screen or error out. I have tried several times and re-verified all the variables each time to make sure they are correct. But still not working. :( That's why I would like to know if anyone here has ever got it to work on Win2003. I got the previous release 2.2 MS1 to work OK though. Thanks -Tuan Link to comment Share on other sites More sharing options...
JamesHenry Posted December 17, 2003 Share Posted December 17, 2003 I have WindowsXP, maybe I should try an older version of OSC. Imagination Breeds Revolution -Me Link to comment Share on other sites More sharing options...
JamesHenry Posted December 17, 2003 Share Posted December 17, 2003 Any idea's/ Imagination Breeds Revolution -Me Link to comment Share on other sites More sharing options...
Guest Posted December 18, 2003 Share Posted December 18, 2003 Manually edit the includes/configure.php and the admin/includes/configure.php files.See where you get. Use phpedit or something similar, not notepad. Hopethis helps. Link to comment Share on other sites More sharing options...
JamesHenry Posted December 19, 2003 Share Posted December 19, 2003 Alrigt, I manually configured those files, the good new's is that The Administration Panel works (no links work on it), however the catalog page doesn't. I think this problem could be solved, but with my lack of knowledge of PHP, i'm not always sure what i'm looking at. define('DIR_WS_HTTP_CATALOG', ''); define('DIR_WS_HTTPS_CATALOG', ''); I'm sure these lines have something to do with the category page, but im not sure what to put in there. Imagination Breeds Revolution -Me Link to comment Share on other sites More sharing options...
trendyfashion Posted December 20, 2003 Share Posted December 20, 2003 The fix is easy.....get a unix server..windows sux! The Wiki Docs: Read them, live them and be thankful for them! Link to comment Share on other sites More sharing options...
Guest Posted December 20, 2003 Share Posted December 20, 2003 the dir_ws_catalog really doesnt have much in dealing with how php works, that is a variable of the catalog path. if you take a look at the configure.php files, it explains what each line should contain. Link to comment Share on other sites More sharing options...
Tuan Le Posted December 20, 2003 Author Share Posted December 20, 2003 The fix is easy.....get a unix server..windows sux! Let's not start another flame war. Microsoft didn't get to where they are today because Windows sucks. :rolleyes: Link to comment Share on other sites More sharing options...
Guest Posted December 20, 2003 Share Posted December 20, 2003 define('DIR_WS_HTTP_CATALOG', '');define('DIR_WS_HTTPS_CATALOG', ''); Those should have values that look like '/' or '/catalog/', i.e. should start and end with a /. The URL of the store should be composed by contatenating HTTP_SERVER . DIR_WS_HTTP_CATALOG . FILENAME_DEFAULT which will look something like http://yourdomain.com/catalog/index.php, where HTTP_SERVER = http://yourdomain.com DIR_WS_HTTP_CATALOG = /catalog/ FILENAME_DEFAULT = index.php Your HTTPS_SERVER should map to the same place as your HTTP_SERVER. Hth, Matt Link to comment Share on other sites More sharing options...
Tuan Le Posted December 20, 2003 Author Share Posted December 20, 2003 the dir_ws_catalog really doesnt have much in dealing with how php works, that is a variable of the catalog path. if you take a look at the configure.php files, it explains what each line should contain. I did changed those two variables to reflect the correct path. However, it is still isn't working. :( I do have a copy running a Linux box though. Link to comment Share on other sites More sharing options...
Tuan Le Posted December 22, 2003 Author Share Posted December 22, 2003 TTT. Anyone? Link to comment Share on other sites More sharing options...
joeyjgarcia Posted December 22, 2003 Share Posted December 22, 2003 I'm not sure if this solves you problem, but I had a few problems because I used "localhost" in too many places. Check the config.inc.php file in the MySQL directory structure and in the Admin Panels->Configuration Page. Just a thought. 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.