dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #15539
[Bug 910733] Re: Dashboard: message - getting exception
** Changed in: dhis2
Assignee: (unassigned) => Thu Tran (tran-hispvietnam)
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/910733
Title:
Dashboard: message - getting exception
Status in DHIS 2 - District Health Information Software:
New
Bug description:
In 2.6, when click on 'Messages' option on left side menu getting
following exception (mysql as backend):
Exception (org.springframework.jdbc.BadSqlGrammarException):
StatementCallback; bad SQL grammar [select mc.messageconversationid,
mc.uid, mc.subject, mc.lastupdated, ui.surname, ui.firstname, ( select
isread from usermessage where
usermessage.usermessageid=mu.usermessageid and
mu.messageconversationid=mc.messageconversationid ) as isread from
messageconversation mc left join messageconversation_usermessages mu
on mc.messageconversationid=mu.messageconversationid left join
usermessage um on mu.usermessageid=um.usermessageid left join userinfo
ui on mc.lastsenderid=ui.userinfoid where um.userid=1 order by
mc.lastupdated desc offset 0 limit 300]; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'offset 0 limit
300' at line 1
Caused by (com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException):
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'offset 0 limit 300' at line 1
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/910733/+subscriptions
References