News:

Support the VirtueMart project and become a member

Main Menu

Coupon Creating problem

Started by BenRoe, September 09, 2020, 12:55:47 PM

Previous topic - Next topic

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?
Joomla 3.9.21 - VirtueMart 3.8.4 10335 - PHP 7.3.2

BenRoe

Joomla 3.9.21 - VirtueMart 3.8.4 10335 - PHP 7.3.2

Jörgen

Vm version, Joomla version etc.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

BenRoe

#3
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?
Joomla 3.9.21 - VirtueMart 3.8.4 10335 - PHP 7.3.2

Jörgen

#4
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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

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?
Joomla 3.9.21 - VirtueMart 3.8.4 10335 - PHP 7.3.2

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

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

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

BenRoe

i will create the english tables now
Joomla 3.9.21 - VirtueMart 3.8.4 10335 - PHP 7.3.2

BenRoe

copying the german tables to _virtuemart_products_en_gb and #__virtuemart_categories_en_gb solved the problem of the coupons creation
Joomla 3.9.21 - VirtueMart 3.8.4 10335 - PHP 7.3.2

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

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.