Moodle in English: Authorize.net Trans IDs are changing in October-Will it break moodle?

Authorize.net Trans IDs are changing in October-Will it break moodle?

by Michael | - Wednesday, 24 September 2008, 5:55 AM

We have received a notice from authorize.net saying that they will be expanding the range of Transaction IDs issued by their payment gateway in October 08, where previously the max was 2,147,483,647 they are changing their system to go beyond that.

In the mdl_enrol_authorize table the value for transid is INT(10) which I believe has a max value of 2,147,483,647.

Does anyone know what I'd need to change that to so that it doesn't break if it gets an ID over the max?

Thanks
M=

Average of ratings: -

Re: Authorize.net Trans IDs are changing in October-Will it break moodle?

by Michael | - Friday, 26 September 2008, 1:58 AM

Does anyone know if changing this from INT(10) to VARCHAR(255) would have any negative effects?

Thanks
M=

Average of ratings: -

Ynt: Re: Authorize.net Trans IDs are changing in October-Will it break moodle?

by Ethem Evlice - Saturday, 27 September 2008, 2:48 AM

Hi Michael,

You can change the field transid to bigint(255) on tables enrol_authorize & enrol_authorize_refunds, NOT varchar.

There is not negative effects.

I will commit to cvs ASAP. Thanks for the report.

Average of ratings: -

Re: Ynt: Re: Authorize.net Trans IDs are changing in October-Will it break moodle?

by Michael | - Saturday, 27 September 2008, 5:44 AM

Thanks for the info on changing to bigint!

Thanks
M=

Average of ratings: -

Re: Authorize.net Trans IDs are changing in October-Will it break moodle?

by Ethem Evlice - Saturday, 27 September 2008, 8:48 AM

Hi again,

Committed. Could you check out HEAD or MOODLE_19_STABLE?

Please test. If everything is ok, I will implement it to 18_stable and 17_stable, too.

Average of ratings: -