/install/oscommerce.sql

[as06tr]

Hello;

 

First time I setup to osCommerce. But gives some error mesagge.

The following error has occurred:

SQL file does not exist: /install/oscommerce.sql

But the file is still under catalog/install/oscommerce.sql So I will manul create table on oscommerce.sql with PhpMyAdmin but same error.

 

Please If you know about the solution help me.

 

Thank you!..

[spax]

If you are on a Windows server, you will probably need the full path to oscommerce.sql

 

Once you have created a database, you can manually populate it in phpmyadmin, using the oscommerce.sql file. Just click on the sql tab and paste the file in. Doing that means you can bypass that part of the installation.

[kevu]

I am a new user trying to insatall it at the first time. I have done by copying and pasting in the SQL tab and it worked. Now as you said how do I bypass the installation step like you said. How do I get to the next installation page?

thanks!

[kevu]

I am on a LINUX server[/b] by the way??

[spax]

If you have executed the sql successfully, just re-run the install process again from the start. Take care to uncheck the import test data checkbox, as you go through the install process. Manually enter the information you are asked for as you go along. If you are on a shared server, you should save sessions to the database so make sure you check that option. So long as you enter the correct info, you should be good to go within 10 minutes.

 

Good luck!

[kevu]

After several issues, It says I have sucessfully installed the OS commerce database. NOw where fo I go from here to the configuration page? I have done the post installation also. When I type the following url it asks me for the protected pasword then getting the following message??

http://www.nadanspices.com/catalog/admin/

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

P.S. How do I know that I am on a shared server?

Thnaks

[kevu]

Hello,

From my previous post, I am on a shared server.

After the sucessfull installation I clicked on the Administration Too or Catalog button, I will get the same database error message I posted previously. Do you know what I am doing wrong here? Do I need to do any other changes in any PHP files? Please help.

Thanks!

[msohail]

Dear Spax,

 

I am completly illiterate in IT, trying to install oscommerce on my server at home with windows server 2003 and IIS V6. I am having the same problem ie SQL file does not exist: /install/oscommerce.sql I have created a database, assign username and password. I managed to install phpmyadmin and can see this databse with 46files in it. Now I dont understand your following instructions:

 

Once you have created a database, you can manually populate it in phpmyadmin, using the oscommerce.sql file. Just click on the sql tab and paste the file in. Doing that means you can bypass that part of the installation.

 

Would you please make this more simple for me ie detailed steps for further installation. I would be grateful.

 

Thanks

 

msohail

[spax]

It is just a way of manually populating the database. If you can see your db has 46 tables, then you have already done that. Click on the database from the left drop down menu and all the tables will be displayed. Look down the bottom of the Records column, you should have around 940 records in a stock install.

 

If you look in the install directory, which is within the catalog directory, you will see a file named oscommerce.sql. If you don't have a complete db, once you have selected your db in phpmyadmin, click on the tab, top of the screen, labelled "SQL". There you will see a text area with a "Go" button underneath and a file locator, also with a "Go" button underneath.

You can either open up oscommerce.sql in a text editor, copy, then paste into the text area and hit the "Go" button or you can use the file locator, navigate to oscommerce.sql and hit that "Go" button.

 

But if your db is complete, you've no need to do either. If that is the case, open your configure.php files in the text editor and see if they are complete. If they aren't, re-run the installation process but uncheck the "import test data" checkbox. Enter the information as prompted.

 

When you say you are installing on your home server, do you intend to serve to the internet from home?

 

If you do, I would strongly recommend you do some serious reading before going ahead. Running a server takes a lot of knowledge and an extreme amount of time to keep it running and, more importantly, secure.

[msohail]

It is just a way of manually populating the database. If you can see your db has 46 tables, then you have already done that. Click on the database from the left drop down menu and all the tables will be displayed. Look down the bottom of the Records column, you should have around 940 records in a stock install.

 

If you look in the install directory, which is within the catalog directory, you will see a file named oscommerce.sql. If you don't have a complete db, once you have selected your db in phpmyadmin, click on the tab, top of the screen, labelled "SQL". There you will see a text area with a "Go" button underneath and a file locator, also with a "Go" button underneath.

You can either open up oscommerce.sql in a text editor, copy, then paste into the text area and hit the "Go" button or you can use the file locator, navigate to oscommerce.sql and hit that "Go" button.

 

But if your db is complete, you've no need to do either. If that is the case, open your configure.php files in the text editor and see if they are complete. If they aren't, re-run the installation process but uncheck the "import test data" checkbox. Enter the information as prompted.

 

When you say you are installing on your home server, do you intend to serve to the internet from home?

 

If you do, I would strongly recommend you do some serious reading before going ahead. Running a server takes a lot of knowledge and an extreme amount of time to keep it running and, more importantly, secure.

 

 

Thank you very much for making these steps simpler for me. I tried all these different measures but not moved forward at all.

 

I can see 46 tables in the database and yes there are 934 records in it. Does this means my database is complete?

 

I also tried to copy and paste oscommerce.sql file (after opening in wordpad) from the install directory into SQL query box as you said but getting this message;

 

import.php: Missing parameter: import_type (FAQ 2.8)

import.php: Missing parameter: format (FAQ 2.8)

 

I followed all the instructions mentioned in FAQ 2.8 but did not work. I also checked file import.php in phpmyadmin and following is the setting, is this coreect?

 

// Are we just executing plain query or sql file? (eg. non import, but query box/window run)

if (!empty($sql_query)) {

// run SQL query

$import_text = $sql_query;

$import_type = 'query';

$format = 'sql';

 

 

unset($sql_query);

} elseif (!empty($sql_localfile)) {

// run SQL file on server

$local_import_file = $sql_localfile;

$import_type = 'queryfile';

$format = 'sql';

unset($sql_localfile);

} elseif (!empty($sql_file)) {

 

// Check needed parameters

PMA_checkParameters(array('import_type', 'format'));

 

// We don't want anything special in format

$format = PMA_securePath($format);

 

// Import functions

require_once('./libraries/import.lib.php');

 

// Create error and goto url

if ($import_type == 'table') {

$err_url = 'tbl_import.php?' . PMA_generate_common_url($db, $table);

$goto = 'tbl_import.php';

} elseif ($import_type == 'database') {

$err_url = 'db_import.php?' . PMA_generate_common_url($db);

$goto = 'db_import.php';

} elseif ($import_type == 'server') {

$err_url = 'server_import.php?' . PMA_generate_common_url();

$goto = 'server_import.php';

 

// Do the real import

$plugin_param = $import_type;

require('./libraries/import/' . $format . '.php');

 

 

} elseif ($finished && !$error) {

if ($import_type == 'query') {

$message = $strSuccess;

 

I have copied only lines with $import_type from this file. Is there a need to change any of these settings?

 

There was no file locator window (in phpmyadmin) underneath the

sql query box, but this is availble with import option. I checked the box for sql file and directed to oscommerce.sql file in install directory but got the same message as above.

 

I also looked into configure.php files

These are three in number in 3 diff places ie

catalog/admin/includes/configure.php

catalog/includes/configure.php

extras/win32/configure.php

 

Which one to check and how will I know it is complete.

Should I look for server, username, password and database lines filled in it

 

or for the following line which is present in only one file ie in win32 directory

define('CONFIGURE_STATUS_COMPLETED', 1);

 

I also tried to re-run the installation process and unchecked the "import test data" checkbox. Entered the information as prompted, leaving HTTP Cookie Path and SSL connection box empty.

I reach to step 7 where it says:

New Installation

osCommerce Configuration

The configuration was successful!

And there are two tabs ie cataloge and administration tool. When I press these I get the following message: No input file specified.

 

Now I dont know what to do.

 

I am sorry I have bombarded you with so many questions.

Your help is greatly appreciated.

 

Once again many thanks for your help.

 

msohail