stream-chat-react-native icon indicating copy to clipboard operation
stream-chat-react-native copied to clipboard

SQL execution error: no such table channelQueries

Open 1987cr opened this issue 3 years ago • 2 comments

Describe the bug SQL error is shown the first time rendering the ChannelList component after a clean install

Dev environment info (please complete/provide the following information):

  • stream-chat-react-native 5.2.0
  • react-native 0.69.4
  • react-native-quick-sqlite 4.0.5
  • Any device

Screenshots Screenshot 2022-09-07 at 11 57 03

1987cr avatar Sep 07 '22 10:09 1987cr

@1987cr thanks for bringing this up. I am able to see how this issue could come up. We will add a fix for it soon and make a release :)

If you would like a quick fix for it urgently, you can call QuickSqliteClient.initializeDatabase() somewhere before rendering chat components or during app start. So that DB is initialized for sure before rendering chat components.

import { QuickSqliteClient } from 'stream-chat-react-native';

// This function only creates tables if they don't exist already.
QuickSqliteClient.initializeDatabase()

vishalnarkhede avatar Sep 08 '22 16:09 vishalnarkhede

@vishalnarkhede thanks for the quick follow up, I'll wait wor the release since it doesn't seem to be crashing or breaking anything atm, cheers!

1987cr avatar Sep 09 '22 09:09 1987cr

@1987cr The issue was not reproducible on our end. We've put all of our resources into finding the culprit, yet with no luck. We decided to give it some time (2 months) to see if it is just a "one of" or the "tip of the iceberg" and if other customers will experience the same issue.

No other customers have faced this issue, and therefore we will be closing this issue for now, due to overall inactivity. May other information or cases arise we will reopen this issue.

vanGalilea avatar Nov 09 '22 09:11 vanGalilea