Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need Help about Oscommerce and MySQL user setup


yky623

Recommended Posts

Posted

Hi,

 

I found a useful book and I'm trying to setup oscommerce on local. I've no information about systems like mysql, apache, php. I'm just trying to learn a little bit by myself. The book tells me to download and install apache, mysql, php. I did these. After installing Mysql server it tells me to create a new user with less privileges instead off root. (instructions are given for mysql 4.1 and I have installed Mysql 5) Here is the code written there;

 

mysql> insert into user values (

-> 'localhost',

-> 'oscommerce',

-> Password('password'),

-> 'Y','Y','Y','Y','Y','Y','Y',

-> 'N','N', 'N','N', 'N','N', 'N','N', 'N','N', 'N',

-> 'N','N', 'N','N', 'N','N', 'N','N', 'N','N');

 

When I input this code i receive the following error;

ERROR 1136 (21S01): Column count doesn't match value count at row 1.

 

How can I overcome this and which privileges do you think i should assign to oscommerce?

 

The other problem is that I cannot install oscommerce anyway (I tried with root). I get to the localhost\catalog\index.php, two boxes are already checked but nothing changes when I hit continue. Any idea is welcome since I don't know much about these.

Posted

My suggestion would be to install xampp. It includes Apache, mySQL and phpmyadmin which is the tool to manage your database. Everything is packaged together for ease of installation.

Archived

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

×
×
  • Create New...