n00b needs install help

[Jebus]

I'm new to osCommerce (which looks like an excellent package BTW - props to the devs!), but I'm stuck during the install process and haven't been able to figure out what I'm doing wrong. I've searched through the forums here, but haven't found anything really specific to what I need.

 

Here's what I've done so far... I've uploaded the 'catalog' folder to the root directory of my website (leaving the admin folder inside). Then when I ran the install I was stuck on the New Installation - Database Import screen that asks for the DB Server, Username, Password, and DB Name. I eventually got a little head-way by using 'localhost' as the DB Server, my username from the website for the Username, left password blank and put '/catalog/install/oscommerce.sql' for the DB Name.

 

After entering the information in this way, I no longer get the 'access denied' error, but now I get this error:

 

'You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '/install/oscommerce.sql' at line 1'

 

Can anyone help me out and point me in the right direction? I assumed that this package would be pretty straightforward to install, but obviously I'm missing something. Any help would be greatly appreciated! TIA

 

*edit* - I also forgot to mention that I had tried CHMODding '/catalog/admin/includes/configure.php' and '/catalog/includes/configure.php' to '777' - which didn't make a difference. I had then also tried CHMODding the entire 'catalog' folder to '777' - which also didn't make a difference. (this was done while I was getting the 'access denied' errors).

[fordhan]

I am new to this myself but learning fast - you need to have mysql running on the web server & then have a database in Mysql for storing the Oscommerce info - the database will have a name - e.g. I am testing with one called Oscom - the username is a username with correct access rights to this database

At the moment you are pointing the setup to the .sql file which is a load of text that tells Mysql what tables to create within the database so will never work

[Jebus]

Thanks for the reply fordhan. I thought that the oscommerce.sql file was the example database you can set up during the install. If not, is there one that I can use just to set everything up and then edit it later?

 

So should I talk to my webspace provider and see what they have to say about the mySQL that I need. As far as I know, the webspace I'm using is setup for PHP4 and mySQL. I had talked to them earlier, and they knew nothing about OsCommerce.

 

Sorry,... but I'm a complete n00b when it comes to mySQL and PHP (although I'm a quick learner!). Thanks again.

[Jebus]

^help!^ Still stuck on this step... Thanks

[fribhey]

Thanks for the reply fordhan. I thought that the oscommerce.sql file was the example database you can set up during the install. If not, is there one that I can use just to set everything up and then edit it later?

 

So should I talk to my webspace provider and see what they have to say about the mySQL that I need. As far as I know, the webspace I'm using is setup for PHP4 and mySQL. I had talked to them earlier, and they knew nothing about OsCommerce.

 

Sorry,... but I'm a complete n00b when it comes to mySQL and PHP (although I'm a quick learner!). Thanks again.

you have to have a mysql database set up for you from your host company. once a database is set up get the database name, host name, username and password for it. the included database file file will upload to the database that you have set up. basically the mysql file that is installed during start up sets up the database that you or your host sets up for oscommerce.

[Jebus]

Thanks fribhey,... I finally got it up and running! Between your post and another one that I just read, I got it figured out. I had to log into my siteadmin for my website and from there I was able to create a mySQL database.

 

Cheers and thanks again for the help guys!