Link Point error

[mhaggag]

Hey Dr. Byte, THANKS. I did that and now I'm getting a different error:

1265 Data truncated for column 'lp_trans_num' at row 1
in:
[update air_orders set lp_trans_num ='562B541D-450C3309-821-15DEDA' where orders_id = '1']


Me think the 2nd lin eof your SQL statement caused (changed) something.
PLEASE ... a fix...!!

Thanks

[mhaggag]

OK, I think I was able to figure this one on my own, I went back to mySQL and entered the following SQL line (which I figured-out by looking at the linkpoint API php script):
alter table air_orders change lp_trans_num lp_trans_num varchar(64) not null default "";

And voila... checkout succeeds, money in the bank and zen doesn't crash on my head.

Lesson learned: gotta be careful changing those tables, columns and values (varchar should be used not an integer).

Thanks for help. I think I'm in business now and I hope to become rich selling on the Internet!!!

[wolftone]

Hey

Thanks for the input

This might come in useful if I get past the other error.

As additional info, I am running the latest version of Zen and the the files for the linkpoint that I downloaded form Zen, and the PEM file from my merchant people.

Blessings

Martin

[mhaggag]

Hey Wolftone,
Just a thought here:
Per the Readme file that came with the linkpoint module:

REQUIREMENTS:

*LinkPoint or YourPay Account (naturally)
*cURL is required and MUST be compiled into PHP
*Port 1129 is used for bidirectional communication with the gateway, so must be open on your host's router
*PEM RSA Key File (Provided by LinkPoint)

If you are NOT communicating at all with the linkpoint server, check with your web hosting provider that they have TCP port 1129 open for you.
Also, check with them they have OpenSSL insatlled and enabled for your site.

Hope that helps.

[ctcentralinfo]

I uninstalled linkpoint to try to reinstall the data and I am getting this error message:

1054 Unknown column 'avs_response' in 'zen_linkpoint_api'
in:
[ALTER TABLE zen_linkpoint_api ADD r_error varchar(250) NOT NULL default '' after avs_response]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[ctcentralinfo]

I tried this patch:

ALTER TABLE orders change lp_avs lp_avs VARCHAR( 25 ) NOT NULL DEFAULT '';
ALTER TABLE orders change lp_trans_num lp_trans_num int(11) NOT NULL DEFAULT 0;

I got this error message:

Error Failed: 2
Error ERROR: Cannot CHANGE column lp_avs because it does not exist.
Error ERROR: Cannot CHANGE column lp_trans_num because it does not exist.