INTERAC via Beanstream Support Thread

[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

[renej]

When I look through the table I see all Canadian Provinces listed under 38.

[swguy]

This is a query. Paste it in the query window.

[swguy]

Please run the command I gave you and paste in the results.

[renej]

Full Texts  	zone_id 	zone_country_id 	zone_code 	zone_name
	Edit 	Delete 	66 	38 	AB 	Alberta
	Edit 	Delete 	67 	38 	BC 	British Columbia
	Edit 	Delete 	68 	38 	MB 	Manitoba
	Edit 	Delete 	69 	38 	NL 	Newfoundland
	Edit 	Delete 	70 	38 	NB 	New Brunswick
	Edit 	Delete 	71 	38 	NS 	Nova Scotia
	Edit 	Delete 	72 	38 	NT 	Northwest Territories
	Edit 	Delete 	73 	38 	NU 	Nunavut
	Edit 	Delete 	74 	38 	ON 	Ontario
	Edit 	Delete 	75 	38 	PE 	Prince Edward Island
	Edit 	Delete 	76 	38 	QC 	Quebec
	Edit 	Delete 	77 	38 	SK 	Saskatchewan
	Edit 	Delete 	78 	38 	YT 	Yukon Territory

[swguy]

Edit includes/modules/payment/interac.php. Go to line 197. It says

    $province_code_order = (in_array($order->billing['country']['iso_code_2'], array('CA', 'US')) ? zen_get_zone_code($order->billing['country']['id'], $order->billing['state'], '--') : '--');

change this to

    $province_code_order = (in_array($order->billing['country']['iso_code_2'], array('CA', 'US')) ? zen_get_zone_code($order->billing['country']['id'], $order->billing['zone_id'], '--') : '--');

(So you change the last 'state' to 'zone_id') Retest.

[renej]

Still not working, the error after going through the online banking is:
No data - Your INTERAC® card could not be authorized for this reason. Please correct the information and try again or contact us for further assistance.

The Interac_Debug_Input.log file contains:
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 --215 iso_code_2 delivery country id delivery state zone_code --


Thanks!
Rene

[ruffendz]

Hello...i have install this wonderful addon but am having a problem when it comes to completing the transaction. I have searched this forum and others for the answer...but no luck and am hoping that some on can help me please. The mod works great, the customers are able to complete and pay for the items(s) via INTERAC online...but when the customer leaves their bank website...it sends them back to my website logged out of their account with no Payment success message and order conformation and no emails are generated to the store owner or customer. Also when i check my store admin to check for the order there is no record of it anywhere. When i log into my bean stream account it shows the transactions as being successfully processed. I am really confused please help

[swguy]

When you set up your account did you give Beanstream the correct 3 URLs as described in the README file?