Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Installation Problem


Guest

Recommended Posts

I'm trying to install the shopping cart (v 2.2) and am having problems with the msql database.

 

the auto-load function won't work because my host (iPowerWeb) says that i can only access the mysql databases thru something called 'phpmyadmin' which is part of cpanel6.

 

so i tried the manual installation and couldn't get the mysql commands to work. i kept getting a syntax error.

 

anybody have any ideas?

 

thanks

Link to comment
Share on other sites

phpmyadmin is used for manually managing the db but has nothing to do with direct OSC use

 

if you are having a problem connecting, then it sounds like your configure.php files (in admin/includes and catalog/includes) may not be setup properly or that your username/pw for the db may not be correct

Link to comment
Share on other sites

thanks for the response...

 

i called tech support and asked them for the mysql server info (i tried several things myself with no success). tech guy told me what i posted above re phpmyadmin. i'm relatively new at this and can believe whatever anyone tells me.

 

but, when i got into phpmyadmin and found the area where i could manually enter the mysql commands, i kept getting syntax errors when using the commands given with the osc instructions.

Link to comment
Share on other sites

using phpmyadmin to create the db is basically a 3 step process

 

1) create the db (with whatever name you like)

2) import the oscommerce.sql file in the install folder

3) go

 

but then all of this is handled in the catalog/install/install.php file which if you call if from a browser will step you thru the installation process - you need to know your mysql username and password and you can name the db anything you want

Link to comment
Share on other sites

importing the oscommerce.sql file is where i had the problem with the syntax errors. how do i do this?

 

i created the db, but couldn't import the above file.

 

i know my user name and p/w, but don't know the server (i tried using the ip of the server where my site is, but that didn't work). the instal.php file asks for the server info, which is why i called for tech support in the first place.

Link to comment
Share on other sites

my database name is 'sorrycha_osCommerce' and i tried to upload the .sql file using the following command (per the install file):

 

mysql sorrycha_osCommerce < . / install / oscommerce.sql

 

MySQL said:

 

 

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 'mysql sorrycha_osCommerce < . / install / oscommerce.sql' at

Link to comment
Share on other sites

I a not sure if it is the way you typed this here but

. / install / oscommerce.sql

should have no spaces and be like this

./install/oscommerce.sql

 

May this be a problem?

Link to comment
Share on other sites

nice try prosto, but nogo.

 

what you saw in my previous post was a copy and paste of the error message that was returned.

 

the original command had no spaces. i tried it again, making sure that there were no spaces, and got the same result.

Link to comment
Share on other sites

I see.

 

I sort of overlooked it - but you are using phpMyadmin right?

 

You can select your database there, go to SQL tab on the top, and you can either copy the contents of the oscommerce.sql into the text field there or browse to the file on your local machine and run it this way.

 

the command you are trying to execute is used when you are accessing mysql via command prompt (telnet or ssh).

Link to comment
Share on other sites

prosto,

 

it worked.

 

thank you, thank you, thank you.

 

it's amazing how easy things are when you know what you're doing.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...