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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via GitHub by niftynei
, 1 year ago
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
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)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.