Newbie to osCommerce, problem with installation...

[Guest]

Hi there,

I'm sure this is a horrid question, and I only found 1 "sort of" match to it in my search (ok, I only went through the first couple of pages - it gets a little much after that):

 

Here's my problem: I've set up my database, username, hostname, etc. through my site hosts admin panel. However, I don't know how to access the database itself in order to create the tables that are apparently needed since I receive the following error upon trying to access the admin area:

 

1146 - Table 'mytablename.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

What in the world IS this, and how do I fix it? I've installed and configured quite a few cgi/perl scripts, and some of them have involved connecting to MySQL as well, but they were things where the script itself created the tables once I'd created the actual database so I'm a little lost on how to just get started.

 

Please be nice :oops:

 

Thanks in advance,

Laura

[Guest]

Check out http://www.oscdox.com for a nice install manual. You'll also want to check out phpMyAdmin. It's a web based GUI for working with the MySQL.

[addaction]

Laura,

 

You can create the tables with the .sql file included in the OSC download or via the auto installer.

[Guest]

I can't seem to access the .pdf at oscdox.com. It just hangs and hangs. I've tried it several times to no avail.

 

Does anyone have a copy they might be able to send me? I'd very much like to read through it.

 

Laura

[addaction]

What version did you install? Do you have phpMyadmin available in your account control panel?

[Guest]

I'm trying to install version 2.2. I don't believe I have access to phpmyadmin through my control panel, although I'm checking right now. I am uploading the program as well through my ftp program just in case.

 

Laura

[addaction]

Hi,

 

Contact me via AIM: addactionnet and I'll see if I can help you out. With 2.2 the install should be very easy.

[Guest]

It appears that I need to create some tables? But how do I know how many fields they'll need? Do I find that in the scripts themselves?

 

I am SO sorry for the stupid newbie questions. If I could access that document mentioned at oscdox.com I'd be much happier...

 

Laura :oops:

[addaction]

First you unzip all the files you from the file you downloaded from the OSC site. Then you upload the files to the server via FTP.

 

Next Chmod the configure.php files in both the catalog and admin directory to 777. Next create a database (no tables yet) and a user for the database via your account control panel that comes with your hosting

 

Next in your browser go to the install directory in your catalog directory. The URL should be something like: http://yourdomain/catalog/catalog/install/

 

This should give you the OSC install screen. Then fill out the requested info and click install new catalog.... This will create all the tables for you.

[Guest]

Thank you so much for letting me know how to get started. I can now access the admin area and have added a category and manufacture and a product...

 

however, I did just receive an error message upon previewing my first product that I'm not sure how to fix. Perhaps some guidance?

 

Warning: open_basedir restriction in effect. File is in wrong directory

in /home/myfiles/oscommerce/admin/admin/includes/functions/general.php on line 789

 

(where "myfiles" is actually my path which I didn't want to post)

 

I've looked through that particular file - general.php, and that line, but don't see what I should be changing, or if I should be changing another file that this particular line refers to.

 

I *think* I've set all the paths correctly. In fact, I've re-run the install program 3 times now trying to see what I might have done wrong.

 

Hmmm, I'm really looking forward to trying this thing out, and getting some of the hacks/mods installed as well. But I think I'd better get these little bugs fixed first.

 

Thanks in advance.

 

Laura