Enrolment

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

 
 
Picture of Michael |
Authorize.net Trans IDs are changing in October-Will it break moodle?
 
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: -
Picture of Michael |
Re: Authorize.net Trans IDs are changing in October-Will it break moodle?
 
Does anyone know if changing this from INT(10) to VARCHAR(255) would have any negative effects?

Thanks
M=
 
Average of ratings: -
Picture of Ethem Evlice
Ynt: Re: Authorize.net Trans IDs are changing in October-Will it break moodle?
 
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: -
Picture of Michael |
Re: Ynt: Re: Authorize.net Trans IDs are changing in October-Will it break moodle?
 
Thanks for the info on changing to bigint!



Thanks
M=
 
Average of ratings: -
Picture of Ethem Evlice
Re: Authorize.net Trans IDs are changing in October-Will it break moodle?
 
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: -
One poor developer...
Re: Authorize.net Trans IDs are changing in October-Will it break moodle?
Group DevelopersGroup Documentation writersGroup Moodle HQGroup Particularly helpful MoodlersGroup Testers
Hi,

this has been tracked as MDL-16715 and has been fixed for 18_STABLE, 19_STABLE and HEAD by Ethem Evlice. cool Now we support transids up to 20 digits!

Will be available in next weekly downloads.

Ciao smile
 
Average of ratings:Useful (1)