java.lang.RuntimeException

java.sql.SQLException: Could not perform raw query for SELECT s.id as _id, s.name, s.color, count(case when m.id > -1 or messages.read = 1 then 1 end) as unread FROM streams as s LEFT JOIN messages as m ON s.id=m.stream group by s.name order by s.name COLLATE NOCASE

Samebug tips0

There are no available Samebug tips.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1

  • via GitHub by niftynei
    ,
  • Stack trace

    • java.lang.RuntimeException: java.sql.SQLException: Could not perform raw query for SELECT s.id as _id, s.name, s.color, count(case when m.id > -1 or messages.read = 1 then 1 end) as unread FROM streams as s LEFT JOIN messages as m ON s.id=m.stream group by s.name order by s.name COLLATE NOCASE at com.j256.ormlite.dao.RuntimeExceptionDao.queryRaw(RuntimeExceptionDao.java:483) at com.zulip.android.activities.ZulipActivity$17.call(ZulipActivity.java:625) at com.zulip.android.activities.ZulipActivity$17.call(ZulipActivity.java:621) at com.zulip.android.activities.ZulipActivity.setupListViewAdapter(ZulipActivity.java:638) at com.zulip.android.activities.ZulipActivity.checkAndSetupStreamsDrawer(ZulipActivity.java:747) at com.zulip.android.activities.ZulipActivity.onCreate(ZulipActivity.java:409) at android.app.Activity.performCreate(Activity.java:6251) at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1107) at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2369) at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2476)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    No Bugmate found.