Hi Caveman, we are definitely not dropping mysql support, its just that most of the devs are using postgres so a function not being mysql-compliant might sneak in from time to time. I tested most of the application on mysql recently without trouble.
A common problem with aggregation earlier was the way the orgunit hierarchy was represented and stored, this is changed in 2.0.5 snapshot and is way less error-prone now. So please build yourself a war-file from trunk and test with that. If that doesn't work please send me a database dump and I will have a look. (On a sidenote a main reason for choosing postgres is the way dumps are restored - mysql uses single regular sql insert statements which might take days for very large databases while postgres uses more "native" copy statements which never takes more than minutes). cheers, Lars 2010/7/12 Orvalho Augusto <orvaq...@gmail.com>: > I need to have a repo/table that aggregates data as I asked before. I did > not find it on docs. > > Someone told me that can happens if a generate those resource tables. I try > to generate those tables and I get stuck on that error I reported. > > Good for me if I do not need to generate such tables and ask what I should > do? > > Caveman > > > 2010/7/12 Lars Helge Øverland <larshe...@gmail.com> >> >> Generating any of the resource tables don't affect the aggregation / >> report tables... >> >> >> >> On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto <orvaq...@gmail.com> >> wrote: >> > Thanks!!! >> > >> > Caveman >> > >> > >> > On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering >> > <jason.p.picker...@gmail.com> wrote: >> >> >> >> A very common mistake is not having generated the resource tables, >> >> namely "orgunitstructure". Consult the documentation for more details >> >> on how to generate these tables. >> >> >> >> Regards, >> >> Jason >> >> >> >> >> >> On Sun, Jul 11, 2010 at 4:27 PM, Orvalho Augusto <orvaq...@gmail.com> >> >> wrote: >> >> > I have a dataelement collected at a Health Centre level (eg: >> >> > ats_posfem) >> >> > in >> >> > one province and only in some particular districts. In unpredictible >> >> > future >> >> > at National level we will be collecting on every health centre. >> >> > >> >> > Now, my ignorance: How can I obtain the provincial total on Report >> >> > Table? I >> >> > have been battled with DHIS so far and nothing. >> >> > >> >> > Thanks guys >> >> > Caveman >> >> > >> >> > >> >> > _______________________________________________ >> >> > Mailing list: https://launchpad.net/~dhis2-devs >> >> > Post to : dhis2-devs@lists.launchpad.net >> >> > Unsubscribe : https://launchpad.net/~dhis2-devs >> >> > More help : https://help.launchpad.net/ListHelp >> >> > >> >> > >> >> >> >> >> >> >> >> -- >> >> -- >> >> Jason P. Pickering >> >> email: jason.p.picker...@gmail.com >> >> tel:+260968395190 >> > >> > >> > >> > >> > _______________________________________________ >> > Mailing list: https://launchpad.net/~dhis2-devs >> > Post to : dhis2-devs@lists.launchpad.net >> > Unsubscribe : https://launchpad.net/~dhis2-devs >> > More help : https://help.launchpad.net/ListHelp >> > >> > > > > > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp