[BUG] GetMessageLIst failed:no such table

[GeminiR]

OpenIM SDK Version

io.openim:android-sdk:3.8.3 ; io.openim:core-sdk:3.8.3

OpenIM Server Version

3.8.3

SDK Platform

Android SDK

Device Model

Samsung SM-A3460

Operating System Version

Android 14

Bug Description and Steps to Reproduce

when I entered the chat page，I got this error：

error *errors.withStack not implement CodeError:
GetMessageList failed: no such table: chat_logs_si_13428675705
50263810_afaq-m.rizwan10005

Screenshots Link

No response

[FGadvancer]

Hello, could you please collect the complete log information from when this error occurred? You can give the open-im-sdk-core log file located under the app package to help me troubleshoot the issue. Also, please confirm that you are using the Android native SDK, correct?

[GeminiR]

Sorry for the delayed reply. I first pulled the openIm logs from AndroidStudio Logcat. I suspect that the creation of the database table is problematic because my user ID contains special characters. Please help troubleshoot this issue.

openim_name_error.log

[mo3et]

I've identified the cause: The period (.) is a special delimiter in SQLite that separates identifiers, specifically splitting the table name from the column. This behavior cannot be resolved — it can only be avoided by not using this symbol.

Just like this:

2025-08-04 14:57:39.772 ERROR   [PID:58264]     [3.8.0]                              [log/sql_logger.go:86]                              sql exec detail                                          {"operationID": "initOperationID_1754290659581", "gorm": "openim-sdk-core/pkg/db/chat_log_model.go:184", "elapsed time": "0.141250(ms)", "rows": 0, "sql": "SELECT * FROM `chat_logs_si_1342867570550263810_afaq-m`.`rizwan10005` ORDER BY send_time DESC,seq DESC LIMIT 40", "error": "no such table: chat_logs_si_1342867570550263810_afaq-m.rizwan10005"}