Hi there I just bougt your VM invoice center but i always get this error when installing:

JInstaller::install: SQL-Fehler DB function failed with error number 1054
Unknown column 'template_body' in 'field list' SQL=UPDATE `jos_vminvoice_config` SET `template_body` = IF(`template_body` IS NULL, '

{start_note}
{billing_address}
{shipping_address}

{invoice_cpt} {invoice_number}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}
{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}', `template_body`) WHERE id=1;
SQL =

UPDATE `jos_vminvoice_config` SET `template_body` = IF(`template_body` IS NULL, '

{start_note}
{billing_address}
{shipping_address}

{invoice_cpt} {invoice_number}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}
{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}', `template_body`) WHERE id=1;

Komponenten Installieren: SQL-Fehler! Fehlende oder nicht lesbare SQL-Datei. DB function failed with error number 1054
Unknown column 'template_body' in 'field list' SQL=UPDATE `jos_vminvoice_config` SET `template_body` = IF(`template_body` IS NULL, '

{start_note}
{billing_address}
{shipping_address}

{invoice_cpt} {invoice_number}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}
{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}', `template_body`) WHERE id=1;
SQL =

UPDATE `jos_vminvoice_config` SET `template_body` = IF(`template_body` IS NULL, '

{start_note}
{billing_address}
{shipping_address}

{invoice_cpt} {invoice_number}
{invoice_date_cpt}: {invoice_date}
{taxable_payment_date_cpt}: {taxable_payment_date}
{maturity_date_cpt}: {maturity_date}
{shipping_date_cpt}: {shipping_date}
{payment_type_cpt}: {payment_type}
{variable_symbol_cpt}: {variable_symbol}
{finnish_index_number_cpt}: {finnish_index_number}
{customer_number_cpt}: {customer_number}
{shopper_group_cpt}: {shopper_group}
{items}
{customer_note_cpt}: {customer_note}
{end_note}
{extra_fields}', `template_body`) WHERE id=1;

where is the fault? can you please help me find it?

I worked with the ENY version without any Problems?

kind regards
Lisa Seiler

I work with joomla 1.5.23 und VM 1.1.9

Hello. Probably that are remains of old VM Invoice installation. Please, delete all tables starting with jos_vminvoice_ from database.

Thank you I tired so much Yesterday .. and then I tested it with my second joomla site (there never was any VM invoice on it) and it worked (I deleted it then because i would need a second lizenence for that, do I ?) .. so i think your guess is the right. how can I search for these tables starting with jos_vminvoice? Im sorry but where do I habe to search them ? Hope my english is ok for you. Thank you for your quick response.

Do you have access to your phpMyAdmin? If not, you na write to your webserver provider and ask him for phpMyAdmin access or delete that tables for you (prefix jos_ can be different, but table names have vminvoice in them)

P.S. You can use 1 VM Invoice license on 2 sites you entered upon order: www.artio.net/e-shop/joomla-extensions/vm-invoice

Hey There
Thank you so much !!! I deleted the them in phpmyadmin and now it works without any problems.
Your Support is great, im happy I bought your VM invoice !!!

Thanks again !
Kind regards
Lisa