xProfile Signup Fields are not ordered the right way as soon as there are more than 9 signup fields

[imath]

This issue was reported on our support forum by :

• tamarazambrana see ​https://buddypress.org/support/topic/buddypress-8-0-0/#post-319276
• niftythree see ​https://buddypress.org/support/topic/buddypress-8-0-0/page/3/#post-319689

The reason for this wrong behavior is I forgot to convert the metadata as SIGNED into the MySQL order clause. My bad 😞

[imath]

In 12980:

xProfile: make sure signup fields are ordered the right way

As the signup_position xProfile meta is stored as a LONGTEXT into the db table, we need to convert it to a SIGNED when using this data to order signup fields.

Props tamarazambrana, niftythree

See #8500 (branch 8.0)

[imath]

In 12981:

xProfile: make sure signup fields are ordered the right way

As the signup_position xProfile meta is stored as a LONGTEXT into the db table, we need to convert it to a SIGNED when using this data to order signup fields.

Props tamarazambrana, niftythree

Fixes #8500 (trunk)

[imath]

Ticket retargeted after milestone deleted