Customer Submit Info Error

[dvduval]

I've got everything pretty well set up, but when I placed a test order, I received an error message when I submitted the new customer info:

 

1054 - Unknown column 'address_book_id' in 'field list'



insert into address_book (customers_id, address_book_id, entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, entry_gender, entry_suburb, entry_zone_id, entry_state) values ('2', '1', 'first name', 'Last Name', '123 Upthe Creek Trail', '30000', 'Duluth', '223', 'm', '', '19', '')

[dvduval]

And on a second test I got this message:

 

1054 - Unknown column 'address_book_id' in 'where clause'



select entry_country_id, entry_zone_id from address_book where customers_id = '2' and address_book_id = '1'

[dvduval]

also getting this at customers.php

 

1054 - Unknown column 'a.address_book_id' in 'on clause'



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

[Ajeh]

Sounds like your address_book table is missing the field address_book_id

[dvduval]

Is it easy to add that field?

[dvduval]

I got it! Thanks!

[Ajeh]

Question is ... why was the field missing in the first place :shock: