dhis2-devs team mailing list archive

[Thu Tran <910733@xxxxxxxxxxxxxxxxxx>]

** Changed in: dhis2
       Status: New => Fix Committed

-- 
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:
  Fix Committed

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