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!
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/
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?
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
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...