Coupon Creating problem

[BenRoe]

Hello I'm getting

Es ist ein Fehler aufgetreten!
1146 Table 'AxelSchmallenbach_website_shop.#__virtuemart_products_en_gb' doesn't exist

upon creating a coupon. I think creating that table wouldn't be of help.

how can I solve that error?

[BenRoe]

who nobody knows that?

[Jörgen]

Vm version, Joomla version etc.

Jörgen @ Kreativ Fotografi

[BenRoe]

I put it in the Signature Juergen

1. do I have to create the table in the database?
2. why isn't it created automatically?

[Jörgen]

Signature is actually not a very Good place for this. It is like having your invoice connected with your current pricetable. Each time you open the invoice you Will get different result, nuff said.

You do not say if this is a new fault or connected to a broken install. Not do you Day if this is a multilanguage shop or using English as fall back. You do not say if you are using native coupons or an extension.
Based on what you do tell:
Under virtuemart tools you will find update and install tables. Execute this and see.

Jörgen @ Kreativ Fotografi

[BenRoe]

1. I'm using the default coupon integration.
2. updating the database in the update/migration section didn't work
3. the problem seems to occur in the german version of virtuemart only. they forgot to rewrite the coupon code to be set to db entry c014h_virtuemart_products_de_de instead of c014h_virtuemart_products_en_gb
4. i copied c014h_virtuemart_products_de_de table to a new table c014h_virtuemart_products_en_gb. even if this works, it could break somewhere in the VM installation.
5. next error is 1146 Table 'AxelSchmallenbach_website_shop.#__virtuemart_categories_en_gb' doesn't exist

6. it's better to re-write the code in VM from the VM developer team than this problem. Even if I manually copy all german tables to english tables, will it work?

[Jörgen]

I still guess this is an error in Your language setup.

Are You for example using english as fall back language ?

Check Your setting both in Joomla backend and VM back end.

Jörgen @ Kreativ Fotografi

[diri]

Check your setup.

'AxelSchmallenbach_website_shop.#__virtuemart_categories_en_gb' is syntax for <db_name>.<tbl_name>.

[Jörgen]

@diri

Thanks

I Did not look close enough. This looks faulty.

Jörgen @ Kreativ Fotografi

[BenRoe]

i will create the english tables now

[BenRoe]

copying the german tables to _virtuemart_products_en_gb and #__virtuemart_categories_en_gb solved the problem of the coupons creation

[Jörgen]

Glad to hear that it works.

I do still suspect that this is an configuration issue. I do not think that You have installed english in both Joomla and VM ?

Jörgen @ Kreativ Fotografi