Author Topic: Sofort Error  (Read 2697 times)

dorkus

  • Jr. Member
  • **
  • Posts: 67
Sofort Error
« on: September 07, 2014, 16:51:45 pm »
Hi everyone.

I really hope you can help me resolve the issue with sofort payment gateway.
Here's the conf:
Joomla 2.5.24
Virtuemart 2.6.6
PHP 5.4.32

Anyway -
Here is my problem:
Whenever I test-checkout with sofort we receive the following error message:
Quote
vmError: SOFORT error message: message Unauthorized, field: , code: 0401
Under this the usual Thank You message. The order is in the db and backend just fine. Just the user is not redirected to Sofort etc.

In plugin settings and in VM we have the correct code (no special chars) login:projectnumber:password

We cannot find errors in logs or anything.

Is there maybe something wrong in the database? Could anyone send a screenshot of the db column tables for "*_virtuemart_payment_plg_sofort" so i can compare? Reason why I ask this is that my paypal tables were messy as well for some reason missing a few columns.

Could you please help me debug and fix this?

Thanks so much!

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9222
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Sofort Error
« Reply #1 on: September 07, 2014, 21:08:10 pm »
the fields for 2.6.6 are


         'id' => 'int(11) UNSIGNED NOT NULL AUTO_INCREMENT',
         'virtuemart_order_id' => 'int(1) UNSIGNED',
         'order_number' => 'char(64)',
         'virtuemart_paymentmethod_id' => 'mediumint(1) UNSIGNED',
         'payment_name' => 'varchar(1000)',
         'payment_order_total' => 'decimal(15,5) NOT NULL',
         'payment_currency' => 'smallint(1)',
         'email_currency' => 'smallint(1)',
         'cost_per_transaction' => 'decimal(10,2)',
         'cost_percent_total' => 'decimal(10,2)',
         'tax_id' => 'smallint(1)',
         'sofort_custom' => 'varchar(255)',
         'security' => 'varchar(50)',
         'sofort_response_amount' => 'decimal(15,5) NOT NULL',
         'sofort_response_currency' => 'varchar(50)',
         'sofort_response_status' => 'varchar(50)',
         'sofort_response_status_reason' => 'varchar(50)',
         'sofort_response_transaction' => 'varchar(100)',
         'sofort_response_invoice' => 'varchar(1000)'

don't know if u speak German but found this on the German VM forum

http://forum.virtuemart.de/installation-updates-einrichtung-156/fehlermeldung-0401-a-1308/

GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

dorkus

  • Jr. Member
  • **
  • Posts: 67
Re: Sofort Error
« Reply #2 on: September 07, 2014, 21:59:28 pm »
hi,
i do speak german but unfortunately it doesnt help in my case....

tnx for the db info. it is exactly like mine.

any other ideas?

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9222
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: Sofort Error
« Reply #3 on: September 07, 2014, 22:09:05 pm »
the error message comes from sofort - ask them what it means?
turn on sofort debugging and check it's log - in the joomla log folder
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

dorkus

  • Jr. Member
  • **
  • Posts: 67
Re: Sofort Error
« Reply #4 on: September 07, 2014, 23:01:10 pm »
hey thanks!

it seems that i have to add a sofort gateway project - the test project was working flawlessly.

they started to charge a monthly for that as i have to subscribe to a business account. wow.

so bye bye sofort as payment option i guess...