dhis2-devs team mailing list archive

[Bharath <chbharathk@xxxxxxxxx>]

Public bug reported:

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

** Affects: dhis2
     Importance: Undecided
         Status: New

-- 
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