This was fixed in SMF 1.1.12. This package is no longer necessary.
This package purpose is to provide a work around for the length code bug in mysql.
To get around this issue this mod requires permission to alter tables. It needs these permissions so it can perform addition of a temp column to sort by before dropping it. Most users should have this permission if the mysql user they installed SMF with has not had its rights changed.
This fix is for SMF 1.x only. SMF 2.0 already incorporates a similar fix to this to provide a work around. SMF 1.0 is not supported but you are welcome to try it if you still need to use SMF 1.0.