Symphony.

Hi,

I have found out a sorting bug using a datasource

I'm using Symphony 2.2.3 and member extension.

To reproduce :

• create a member section with a username
• include a timezone field

• create a user and affect him +03:00 timezone

• create a section Post

• add to it a Date field

• add to it a selectbox link field pointing into the member section

• insert a post entry

• change timezone to +02:00 for the user

• insert another post entry

• create a datasource for posts

• create a page to list posts

=> on the end you will see that the order isn't correct, it doesn't take in consideration the timezone of the date that is indeed stored on the database.

EntryId      date                   local         gmt
988 | 2011-10-10T20:33:01+03:00 | 1318267981 | 1318267981 |
989 | 2011-10-10T19:36:18+02:00 | 1318268178 | 1318268178 |
990 | 2011-10-10T20:45:00+03:00 | 1318268700 | 1318268700 |

the order received was 989, 988, 990 which is obiviously not correct.

ploplop :P

I don't have account to post this bug on github, can some1 do it pls ?

Getting a Github account is painless and free, and is probably the best thing if you want to follow development and post bugs.

As for this issue, I think it's resolved on the latest 2.2.x branch, which is soon to be Symphony 2.2.5.