ok next problem

[nannyspetals]

i get this problem when i go to instal but the file its asking for is in the right place as i can see it any help?

 

New Installation

 

Database Import

 

The following error has occurred:

 

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

[mr_biggles]

i get this problem when i go to instal but the file its asking for is in the right place as i can see it any help?

 

New Installation

 

Database Import

 

The following error has occurred:

 

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

<{POST_SNAPBACK}>

 

 

whats the url ?

[nannyspetals]

http://nannyspetals.com/catalog/install/install.php?step=3

 

this?

 

it has changed now instead of as much txt now all i get is

 

The following error has occurred:

 

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

 

 

but the file clearly does exsit

[nannyspetals]

The following error has occurred:

 

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

 

if theres a post i can look at for this please point me in the right direction or if someone knows how i can solve this error please type :huh:

[mr_biggles]

Sorry m8,

 

i had it installed automagically by my CPanel, didnt go through all this stuff.

 

When i follwed your link both boxes were checked (ticked) i clicked continue - all worked and was asked to input the database info.

 

Does your error occur after this point?

 

double check the database info is correct?

 

am guessing a bit here but, yes, the .sql file is there.

 

Good Luck !

 

Ian

[davecove]

The following error has occurred:

 

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

 

if theres a post i can look at for this please point me in the right direction or if someone knows how i can solve this error please type  :huh:

<{POST_SNAPBACK}>

 

What OS vesion are you installing on?

 

Dave

[nannyspetals]

i get this msg after ive put in my database info and click instal or wat ever the button says is there a way round this ?

[nannyspetals]

im using xp

[nannyspetals]

ok i put my data in press continue i get

New Installation

 

Database Import

 

A test connection made to the database was successful.

 

Please continue the installation process to execute the database import procedure.

 

It is important this procedure is not interrupted, otherwise the database may end up corrupt.

 

The file to import must be located and named at:

 

/install/oscommerce.sql

 

then i press continue and i get the error msg

[♥Vger]

There are two possible reasons that I know of for getting this error.

 

1. You haven't set folder permissions to 755 for the install folder, so the install can't read that the sql file is there.

 

2. You are installing on a Windows server - and they generally can't find their own way home.

 

If installing on a Windows server the best thing to do is a manual install. Access the blank database you created via phpMyAdmin (click the SQL tab), use the Browse function to locate the sql file on your computer, then click 'Go'.

 

Then edit the two configure.php files manually.

 

Vger

[nannyspetals]

i cant change my folder to 755 i do it all then it just goes back to 700 any idea why? ill try the other way tho cheers

[♥Vger]

Save yourself a lot of grief in the future and switch to an Apache web server now, with a Unix or Linux Operating System. I know that osCommerce will work with Windows servers - but only if Windows will allow it to work.

 

Hosting companies that use Windows servers are so scared of the dynamic scripting abilities of PHP that they do everything they can to restrict its functionality - PHP in Safe Mode, Register Globals off, File Uploads disallowed etc. On top of that because it's a Windows server you can't use .htaccess files, and you can't use the chmod command via FTP to alter file permissions - and it's a lot slower doing it via the File Manager in a web hosting control panel.

 

All this adds up to a lot of wasted time on your part, and all because you have to find workarounds to problems that don't exist on an Apache server.

 

Vger

[nannyspetals]

ok i done what you said and got this msg

 

Error

SQL query:

 

# $Id: oscommerce.sql,v 1.84 2003/05/27 17:32:16 hpdl Exp $

#

# osCommerce, Open Source E-Commerce Solutions

# http://www.oscommerce.com

#

# Copyright © 2003 osCommerce

#

# Released under the GNU General Public License

#

# NOTE: * Please make any modifications to this file by hand!

# * DO NOT use a mysqldump created file for new changes!

# * Please take note of the table structure, and use this

# structure as a standard for future modifications!

# * Any tables you add here should be added in admin/backup.php

# and in catalog/install/includes/functions/database.php

# * To see the 'diff'erence between MySQL databases, use

# the mysqldiff perl script located in the extras

# directory of the 'catalog' module.

# * Comments should be like these, full line comments.

# (don't use inline comments)

DROP TABLE IF EXISTS address_book

MySQL said:

 

#1046 - No Database Selected

[♥Vger]

No, it's not seeing the database or else you've provided the wrong name for the database.

 

Read the Quick Install Guide link below my name. You may see something there that you have not done.

 

Vger

[nannyspetals]

ok ive delted it all how do i go about getting an appache server and a unix or linx os

[lazyfish]

hello everyone

Im a newbie trying to install osc

My problem is I'm making this shopping cart for a client and just bought a new domain for them which they paid for 2years.And that server is a windows based web server.

I uploaded osc's catalog file to the web server, wrote the url to the browser and then started the installation.I've created a mysql account using the cp of hosting company.OSC is able to connect to mysql db but after that step, i get the same error

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

 

now as you know i cant go out there and tell them to change the server that they bought a week ago.I'm pretty stuck here and i'm thinking about installing a offline server with mysql php IIS and all those things but I dont have alot of time.

PLEASE HELP ME :)

thx alot

[Guest]

For everyone (like me) who is new and hitting this problem and not finding the information they want in the forums: SQL file does not exist: /install/oscommerce.sql (Step 3)

 

Here is some help :)

 

I use Windows 2000, PHP5 manual install of ISAPI (not CGI), and IIS 5.0

 

The PHP installer installs a CGI version of PHP. When I set up a server with the CGI, no error. However, when I set up the server with the ISAPI, I get the above error. After digging around, I found this on the forums: http://www.oscommerce.com/forums/index.php?sho...68entry743068

 

I do not know PHP and did not want to start modding files because I want to make sure my server works so there are no issues later. This looked like a hack to me and I was uninterested in making the changes. I started looking into the code and PHP manuals, finally finding this: http://www.php.net/manual/en/function.getenv.php

 

If you read down to "renko's" comment, you will learn that the "getenv()" function does not work in the ASAPI installation of PHP with IIS! He suggests to use $_SERVER[] instead, which is exactly the fix outlined by Phwoarr in the first link.

 

So, for users with the "SQL file does not exist: /install/oscommerce.sql" error using Win2K, make sure you do a PHP CGI installation (works from the windows installer or manually) rather than ISAPI. If you must use the ISAPI (which I am doing) then make sure to apply the necessary changes Phwoarr posted. They are legit. Just be aware than any contributions you install, or anything else, should be scanned for the offending getenv() function call. Or, you could switch to Win2K and Apache, or Linux and Apache.

 

Here is some help in return from all I have gotten from previous posters :D

 

Pualee