TVA Intracommunautaire module installation problem

[ker]

Hi,

 

Hi I am trying to install the VAT Intracom module and I know I have to add fields in the database but I don't understand anything about it. I know that I can do it using MyPHPadmin but how?

 

Without those changes I will have this error forever:

 

"1054 - Unknown column 'ab.entry_tva_intracom' in 'field list'

 

select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_tva_intracom, 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 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 = '2' and ab.customers_id = '2' and c.customers_default_address_id = ab.address_book_id"

 

Before that my store was working pretty well but I forgot to backup and now there is no way for a customer to checkout.

 

Please help (with clear explanations for a rookie like me).

 

Thank you in advance

[FalseDawn]

Open phpMyAdmin (from your host's control panel), select your database from the dropdown on the left, click the "SQL" tab at the top, paste the SQL into the big text box. Click "go".

 

The SQL should be provided in the contribution and will look like

"ALTER TABLE blah blah ADD columnname blah blah"

 

 

If you don't know how to open phpMyAdmin, ask your host.

[ker]

Open phpMyAdmin (from your host's control panel), select your database from the dropdown on the left, click the "SQL" tab at the top, paste the SQL into the big text box. Click "go".

 

The SQL should be provided in the contribution and will look like

"ALTER TABLE blah blah ADD columnname blah blah"

If you don't know how to open phpMyAdmin, ask your host.

<{POST_SNAPBACK}>

 

 

Thank you for your help. It works now. The problem I had is that I used a contribution that was too old ad not valis for the version I use.

 

Regards