Author Topic: Coupon Creating problem  (Read 2848 times)

BenRoe

  • Beginner
  • *
  • Posts: 20
  • A beginner
  • Skype Name: benjamin_roehling
Coupon Creating problem
« on: September 09, 2020, 12:55:47 pm »
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

  • Beginner
  • *
  • Posts: 20
  • A beginner
  • Skype Name: benjamin_roehling
Re: Coupon Creating problem
« Reply #1 on: September 10, 2020, 19:30:21 pm »
who nobody knows that?
Joomla 3.9.21 - VirtueMart 3.8.4 10335 - PHP 7.3.2

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3632
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Coupon Creating problem
« Reply #2 on: September 10, 2020, 21:35:35 pm »
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

  • Beginner
  • *
  • Posts: 20
  • A beginner
  • Skype Name: benjamin_roehling
Re: Coupon Creating problem
« Reply #3 on: September 11, 2020, 02:17:20 am »
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

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3632
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Coupon Creating problem
« Reply #4 on: September 11, 2020, 06:51:06 am »
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

  • Beginner
  • *
  • Posts: 20
  • A beginner
  • Skype Name: benjamin_roehling
Re: Coupon Creating problem
« Reply #5 on: September 12, 2020, 01:03:22 am »
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

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3632
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Coupon Creating problem
« Reply #6 on: September 12, 2020, 09:16:52 am »
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

  • Jr. Member
  • **
  • Posts: 124
  • VirtueMart Version: most recent dev version (trunk)
Re: Coupon Creating problem
« Reply #7 on: September 12, 2020, 09:17:55 am »
Check your setup.

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

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3632
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Coupon Creating problem
« Reply #8 on: September 12, 2020, 09:20:11 am »
@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

  • Beginner
  • *
  • Posts: 20
  • A beginner
  • Skype Name: benjamin_roehling
Re: Coupon Creating problem
« Reply #9 on: September 12, 2020, 15:04:14 pm »
i will create the english tables now
Joomla 3.9.21 - VirtueMart 3.8.4 10335 - PHP 7.3.2

BenRoe

  • Beginner
  • *
  • Posts: 20
  • A beginner
  • Skype Name: benjamin_roehling
Re: Coupon Creating problem
« Reply #10 on: September 12, 2020, 15:08:47 pm »
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

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3632
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Coupon Creating problem
« Reply #11 on: September 12, 2020, 15:32:50 pm »
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.