New Install - 1146 - Table 'gekko_behe.address_book' doesn't exist

[Gshot]

Hi Guys,

 

Just installed a new store, then tried to sign up as a customer to test.

 

After clicking submit on the sign up page I get -

 

1146 - Table 'gekko_behe.address_book' doesn't exist

 

insert into address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, entry_suburb, entry_zone_id, entry_state) values ('3', 'ktiyuit', 'ituittu', 'ytryrytr', 'ytryrtytry', 'ytrytrytr', '222', '', '0', 'ytrytry')

 

[TEP STOP]

 

 

Also in 'Customers' in Admin I get -

 

1146 - Table 'gekko_behe.address_book' doesn't exist

 

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id

 

[TEP STOP]

 

 

 

Any help would be great, thanks in advance.

[Gshot]

Solved

 

The installation didnt create the address_book table.

 

so I downloaded a new version from oscommerce.com and used the oscommerce.sql file, well this part of it -

 

DROP TABLE IF EXISTS address_book;

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)

);

 

 

An I ran it as a query in phpmyadmin

 

Alls working ;)