Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Can't Install database tables


Guest

Recommended Posts

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.

Link to comment
Share on other sites

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.

For ALL problems, please review this link first -> osCommerce Knowledge Base

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...