Can't Install database tables

[Guest]

I tried this before but I deleted everything and tried a fresh install. Decided to save some time and install the database tables first just to see if it would work.

This is the FIRST error I get:

Error

 

SQL query:

 

CREATE TABLE address_book(

address_book_id int NOT NULL AUTO_INCREMENT ,

customers_id int NOT NULL ,

entry_gender char( 1 ) NOT NULL ,

entry_company varchar( 32 ) ,

entry_firstname varchar( 32 ) NOT NULL ,

entry_lastname varchar( 32 ) NOT NULL ,

entry_street_address varchar( 64 ) NOT NULL ,

entry_suburb varchar( 32 ) ,

entry_postcode varchar( 10 ) NOT NULL ,

entry_city varchar( 32 ) NOT NULL ,

entry_state varchar( 32 ) ,

entry_country_id int DEFAULT ''0 '' NOT NULL ,

entry_zone_id int DEFAULT ''0 '' NOT NULL ,

PRIMARY KEY ( address_book_id ) ,

KEY idx_address_book_customers_id( customers_id )

);

 

MySQL said: Documentation

#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 '0'' NOT NULL,

entry_zone_id int DEFAULT ''0'' NOT NULL,

PRIMARY KEY (addre' at line 13

 

If I go in and delete the single quotes then it will go to the next table and same thing. This is everything I have on this server that I am aware of:

Welcome to phpMyAdmin 2.7.0-pl2

 

MySQL 4.1.20 running

 

Operating System: Redhat Linux

Kernel Version: 2.6.17.6_NEW

Apache/PHP Version: Apache/1.3.34 (Unix) FrontPage/5.0.2.2510 PHP/5.0.4

Perl Version: v5.8.5

MySQL Version: 4.1.12

Send Mail Version: 8.13.1

 

Any ideas? If not I am just going to have to scrap oscommerce all together. I have done many zen-cart installs without this kind of problems but I wanted to give oscommerce a try. I still do.

[Guest]

nobody has any ideas????

[dmnalven]

What version of osC is this? Have you researched the 1064 error? And I believe that early versions of the mySQL 4 series had issues.

 

I have often needed to hand edit sql files to get past the syntax error messages. Usually the table wide defaults like character sets, engine and auto_increment, but I have seen the DEFAULT keyword cause more than my share of problems.

 

Test some simple similar syntax directly on the server, using the mysql or mysqladmin cli interface, to get a feel for accepted syntax. Then do global edits of the table creation scripts.

 

I'm new to osC, but I thought that I saw that there was automated help for this.

[Guest]

What version of osC is this? Have you researched the 1064 error? And I believe that early versions of the mySQL 4 series had issues.

 

I have often needed to hand edit sql files to get past the syntax error messages. Usually the table wide defaults like character sets, engine and auto_increment, but I have seen the DEFAULT keyword cause more than my share of problems.

 

Test some simple similar syntax directly on the server, using the mysql or mysqladmin cli interface, to get a feel for accepted syntax. Then do global edits of the table creation scripts.

 

I'm new to osC, but I thought that I saw that there was automated help for this.

 

 

If there is autohelp I haven't found it yet, I have put several zen-cart installs on this server before and although I know there are some differences, and it may have dropped a table or two that I had to go in and put in manually I have never had an entire file get rejected like this.

[Guest]

What version of osC is this? Have you researched the 1064 error? And I believe that early versions of the mySQL 4 series had issues.

 

I have often needed to hand edit sql files to get past the syntax error messages. Usually the table wide defaults like character sets, engine and auto_increment, but I have seen the DEFAULT keyword cause more than my share of problems.

 

Test some simple similar syntax directly on the server, using the mysql or mysqladmin cli interface, to get a feel for accepted syntax. Then do global edits of the table creation scripts.

 

I'm new to osC, but I thought that I saw that there was automated help for this.

 

 

It is the latest version, I just downloaded from the site. I could get it to finally accept all the tables but not the info for them at the end of the sql file.