Print Page - Order by Length(code) fix

Title: Order by Length(code) fix
Post by: SleePy on May 09, 2008, 09:59:54 PM

Link to Mod (http://custom.simplemachines.org/mods/index.php?mod=1187)

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.

See http://docs.simplemachines.org/index.php?topic=1079 for more information

Title: Re: Order by Length(code) fix
Post by: Apllicmz on May 09, 2008, 10:57:37 PM

good work man
thank you

Title: Re: Order by Length(code) fix
Post by: ne.miguelito on May 10, 2008, 08:39:08 PM

Thanks

Title: Re: Order by Length(code) fix
Post by: LadyC on June 03, 2008, 03:15:23 AM

worked like a charm!

Title: Re: Order by Length(code) fix
Post by: Cal O'Shaw on March 09, 2010, 06:52:43 PM

Hello,

We don't have this problem appearing on our site, but concerned when we eventually upgrade to 2.0.0 (quite happy with 1.1.11 thank you very much).

Our mySQL is v5.0.90.

Grazie,

Cal

Simple Machines Community Forum

Customizing SMF => Modifications and Packages => Topic started by: SleePy on May 09, 2008, 09:59:54 PM