Hi all,
Hope this is the correct thread to post this on, so appologies if it's not.
When my customers create and account, or when my customers sign in with their account, when ever they add a product to the cart and try to check out they get this error:
1054 Unknown column 'ab.entry_telephone' in 'field list'
in:
[select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, co.countries_id, co.countries_name, co.countries_iso_code_2, co.countries_iso_code_3, co.address_format_id, ab.entry_state, ab.entry_telephone from (customers c, address_book ab ) left join zones z on (ab.entry_zone_id = z.zone_id) left join countries co on (ab.entry_country_id = co.countries_id) where c.customers_id = '1' and ab.customers_id = '1' and c.customers_default_address_id = ab.address_book_id]
Now correct me if i'm wrong, it's basically saying there is no column in the address_book field of the database. If this is the case, does this mean i have to add a column for entry_telephone ?
If so, is there any info on how to do this?
I am aware this is a very dangerous thing to do on a live store so depending on the skill level required, i may have to seek help.
Thanks in advance
Nic.




