News:

Looking for documentation? Take a look on our wiki

Main Menu

Sofort Error

Started by dorkus, September 07, 2014, 16:51:45 PM

Previous topic - Next topic

dorkus

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:
QuotevmError: 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

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 https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

dorkus

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

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 https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

dorkus

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...