MODX Staff
MODX Staff
Kyle, I have commited the GROUP BY fix to my SVN branch, it works fine for the sorting problems and nobody who has implemented it has reported any adverse effects so I’m happy it does the job
Here is one bug I would personally like to see fixed:
http://modxcms.com/bugs/task/512
the new MODx Light theme works PERFECT for me
MODx Green seems to have a problem, I m on FF 2.0 RC1 and IE 6.0, Tree Icons are messed up, context menu is not working in both browsers.
Same for MODx theme.
I am attaching the screenshots.
I was just making screenshots to show the same thinks I noticed that some break character or mabe something else was present in the top left corner I hilighted the space to show also the icons are packt togetter with no H-spacing at all.
I never switch Captcha on for the Manager. I have no idea how many users out there do use this feature. I’m not mad happy on the default "3 false logins blocks the user for an hour" thing, it strikes me that people could go to /manager on lots of sites and deliberately screw up the predictable "admin" account at crucial moments.
However, I do like that admins have the choice. I’d rather that they could switch off the blocking, but admins can always change the logins to 60 and the time to 10 minutes or so if they want to rely on Captcha instead.
So: don’t remove it, but yes it needs to be in a better place than in that picture.
Sounds good garry, I wonder if this will error on other versions of mysql though.
I was under the assumption that if you grouped by a field all other fields had to be calculated fields. Maybe this restriction doesn’t exist in mysql though.
If it works under all versionas that great though
Quote from: Dimmy at Oct 06, 2006, 03:01 AM
I was just making screenshots to show the same thinks I noticed that some break character or mabe something else was present in the top left corner I hilighted the space to show also the icons are packt togetter with no H-spacing at all.
I like this theme. Is this the theme called "MODx" ?
MODX Staff
MySQL uses something called ’GROUP BY with hidden fields’ as long as mySQL is not running in ONLY_FULL_GROUP_BY mode which I don’t believe is a common mySQL mode.
In SQL (AFAIK) only non-aggregated columns are listed inside the Group By clause. So if the column is not using one of those aggregated functions then it should be present inside the Group By. This again might have some performance impact on large number of records but I could be wrong here. Not 100% on how MySQL operates in regards to Group By
This discussion is closed to further replies. Keep calm and carry on.