Hi Knut Seems like something schizophrenic is happening. As far as I know MySQL does not support or use sequences. It uses auto-incrementing instead.
It looks almost like you're trying to import something from postgres sql to mysql. What are you doing when you get this error? Any chance that you have a mixed up config -eg using postgresql dialect but loading mysql driver? Bob 2009/8/30 Knut Staring <[email protected]> > Indeed. I wonder if someone knows what that query is, as it seems to want > to access the information_schema database, and not the DHIS2 database. > > I suppose DHIS2 needs for there to be a Sequences table in the MySql > information_schema base - does anyone know the details? And has anyone > encountered this problem before? Could it have to do with privileges for > that db? > > K > > On Sun, Aug 30, 2009 at 6:04 AM, Orvalho Joaquim Augusto < > [email protected]> wrote: > >> Well, this means that somewhere there is a query referincing a table with >> name 'sequences' and it does not exist on the database. >> >> Start by checking that. >> >> Caveman >> >> >> Knut Staring wrote: >> >>> I am getting the below error. >>> >>> * ERROR 14:11:12,988 could not get database metadata (SchemaUpdate.java >>> [main]) >>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table >>> 'sequences' in information_schema >>> >>> >>> -- >>> Cheers, >>> Knut Staring >>> >>> >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> Mailing list: >>> https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> >>> Post to : [email protected] >>> Unsubscribe : >>> https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> >>> More help : https://help.launchpad.net/ListHelp >>> >> >> >> > > > -- > Cheers, > Knut Staring > > _______________________________________________ > Mailing list: > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
