INTERAC via Beanstream Support Thread

[renej]

Anybody???? Anything???? Hellooooooo...

[renej]

Still can't figure it out. If anyone has any idea please let me know. We've sold lots of courses via Credit Card, but the Interac does not work. It gets to the bank and the account gets charged for the amount, but then the bank refunds the money back into the account.

Rene

[davecool]

I am experiencing the same issue. I have been in contact with Beanstream, they've seen the error and they looked at my debug logs. They say it all looks good to them. If we put the account back into testing mode, it all runs perfectly. It's only once live that it stops working.

Here's what I got from Beanstream support:

The logs below look fine, what you're seeing there is the initial request to our system, followed by the redirect we send back to send the customer to the Interac system. This is all working from what I can see, and a test I did up to the Interac login page worked as well. This indicates that the urls are correct as well.

Without being able to do a live test it's hard to see exactly what the error that Zencart is capturing, the screenshot indicates there was an error but does not show the actual error from our response, which would have an ID and a message associated with it.

What I would recommend is making a post on the Zencart support forum describing the issue, as it sounds like there's some sort of problem with the module itself, or perhaps the configuration of it. Ask if there's any additional logging happening that you could send to us, or any way to see the actual error response from our system on the 2nd part of the transaction. The person that created the module posts under the name "swguy" on the forums, he's likely to respond if you're looking for assistance with it.

If you can get additional information from the Zencart logs or a more specific error message then we can look further into it, unfortunately with the information provided I don't see anything wrong with the setup on our end or with the actual IOP url setup.

swguy, are you available to help diagnose this one?

Thanks,
David

[swguy]

Please download version 1.0.1 and set debug to "Log File". This will create a file called Interac_Debug_Input.log in your cache directory that will help us see what the problem is.

[renej]

Done!

Here is the contents of the log file:

199 iso_code_2 CA billing country id 38 billing state Newfoundland zone_code --215 iso_code_2 delivery country id delivery state zone_code --

All one line, no line breaks.

Rene

[swguy]

In phpMyAdmin, please execute the command

select * from zones where zone_country_id = 38;

(If you use a prefix like "zen_" make this "from zen_zones")

[renej]

In phpMyAdmin, please execute the command

select * from zones where zone_country_id = 38;

(If you use a prefix like "zen_" make this "from zen_zones")

I'm in phpMyAdmin, where do I run this command? All I can find is an area to run a query.

Thanks!
Rene