Creating the mysql catalog on MySQL 4 running PHP 4

[MichaelT]

Can someone please help me with the creatinn of The MySQL table? Typical errors that I get are as follows:

 

[local host] ERROR 1064: 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 ';

CREATE TABLE address_book (

customers_id int DEFAULT '0' N

 

 

[local host] ERROR 1146: Table 'catalog.configuration' doesn't exist

[badjuju]

What are you trying to do?

Post the task you were performing before the error was received.

[MichaelT]

I simply used the MySQl console opened the SQL script and executed to run it for populating the table I manual had created. Because I have the MySQL console I did not have to go to a dos prompt command line to run the command to populate the table.

[wasson65]

I simply used the MySQl console opened the SQL script and executed to run it for populating the table I manual had created. Because I have the MySQL console I did not have to go to a dos prompt command line to run the command to populate the table.

 

Why not just let the osc install procedure run the oscommerce.sql file into the database?

 

Tim

[MichaelT]

I am not sure if I did something wrong or there is something I was not following but I tried the OSC install procedure and nothing happen. All I saw was text instructions on what to do, which I followed.

 

Can you help me there please?

[wasson65]

I am not sure if I did something wrong or there is something I was not following but I tried the OSC install procedure and nothing happen. All I saw was text instructions on what to do, which I followed.

 

Can you help me there please?

 

Here's how I install EP:

 

1. Create a database in mysql.

CREATE DATABASE oscdb;

Grant all on oscdb.* to username@localhost IDENTIFIED BY 'thepassword';

 

Then untar OSC in a web directory, and point my browser at ...webdirspath/catalog/admin/install/index.php (wherever it ends up), and away you go.

 

Did you get this far when you tried to install? Something very basic is not correct.

 

Tim

[MichaelT]

I beleive that there is a problem with the ecommerce 2.2 development version because that was what I originally had downloaded and tried to install. Given the problems I was having I then downloaded osCommerce 2.1 and I had no problem with running the MySQL script to load to the tables. The problem I am now having however is with the configuration of IIS5.0. I need to modify the config_top.php file to use IIS rather than Apache and theirin lies my problem. Can you assist me there?

 

Thanks

[wasson65]

I beleive that there is a problem with the ecommerce 2.2 development version because that was what I originally had downloaded and tried to install. Given the problems I was having I then downloaded osCommerce 2.1 and I had no problem with running the MySQL script to load to the tables. The problem I am now having however is with the configuration of IIS5.0. I need to modify the config_top.php file to use IIS rather than Apache and theirin lies my problem. Can you assist me there?

 

Thanks

 

Well, 2.1 is a real step backward. You're going to find that many of the contribs won't work on 2.1. I'm afraid I'm not able to be much help, II$ is in the minority here, and I stick with Apache. And 2.1 IIS users are going to be even more rare than 2.2 IIS users.