[OGo-Users] strange ordering of appointments

[Adam Tauno Williams]

> I recognized that the sort order of appointments in the WebUI is sometimes 
> not correct. I have seen the wrong order, an appointment starting e.g. 14:00 
> is listed behind an appointment that starts e.g. 18:00, under the following 
> conditions:
> 1. The later appointment is "old", that means, created some weeks ago
> 2. the earlier appointment is "new", that means, just created
> 3. both appointments are not whole day, but in the afternoon (appointments 
> in the morning doesn't seem to have that problem)
> 4. you have to have the "all intranet" team view, week overview (switching 
> to an other team, where participants are on both appointments, then the sort 
> order changes to the correct one), also other teams with a large number of 
> members seem to have the same problem, but the count of members doesn't seem 
> to be the problem, but the count of appointments by the members of the team 
> seem to be the problem. E.g. I have a team, with 60 members, where the sort 
> order is mixed up, then I exchange some members, and the sort order is 
> fixed. This was reproducible by exchanging the same accounts. It might have 
> sth. to do with the appointment assignment. There were the same number of 
> appointments on that day with both test group, so I assume the number of 
> appointments per day does not matter.
> 5. the day overview does not seem to have that problem
> has someone seen this before, or can try to reproduce it? 

I haven't noticed it, but I almost exclusively use the month view.  I'll
try to test it.

Would be useful to run your test with SQL debugging enabled to see if
there is ordering in the query.

> I just only walked 
> back two weeks and created an appointment for me, took the "all intranet" 
> week overview and saw the appointment order mixed up.
> I have seen this behavior on opensuse 10.1 with OGo, 1.1.6-r1764.0, and on 
> opensuse 10.2 with OGo r1949.1, both using the same database.