[Bug] 部署服务端数据库模式不能全文检索了

[m-guo]

📦 Environment

Vercel

📌 Version

v1.2.3

💻 Operating System

macOS

🌐 Browser

Chrome

🐛 Bug Description

服务端数据库模式下不能本地数据库那行全文检索了，连话题也无法搜索了

📷 Recurrence Steps

No response

🚦 Expected Behavior

No response

📝 Additional Information

No response

[lobehubbot]

👀 @m-guo

Thank you for raising an issue. We will investigate into the matter and get back to you as soon as possible. Please make sure you have given us as much context as possible.\ 非常感谢您提交 issue。我们会尽快调查此事，并尽快回复您。 请确保您已经提供了尽可能多的背景信息。

[arvinxx]

哪里的搜索挂了？我可以搜的呀

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Where is the search broken? I can search it

[m-guo]

command + K 搜索

我部署的环境可以在多端设备上同步数据，文字和图片都同步过去了；但是搜索框单个字符都搜索不到。

[shog86]

我Vercel服务端部署的，确实搜不出来，对话内容和助手名字都搜不出来

[xwydq]

服务端数据库模式下不能本地数据库那行全文检索了，连话题也无法搜索了

请问服务端数据库模式部署时 一直报错：

$ bun run db:migrate
$ MIGRATION_DB=1 tsx scripts/migrateServerDB/index.ts
❌ Database migrate failed: ErrorEvent {
  [Symbol(kTarget)]: WebSocket {
    _events: [Object: null prototype] {
      error: [Function],
      message: [Function],
      close: [Function],
      open: [Function]
    },
    _eventsCount: 4,
    _maxListeners: undefined,
    _binaryType: 'arraybuffer',
    _closeCode: 1006,
    _closeFrameReceived: false,
    _closeFrameSent: false,
    _closeMessage: <Buffer >,
    _closeTimer: null,
    _errorEmitted: true,
    _extensions: {},
    _paused: false,
    _protocol: '',
    _readyState: 3,
    _receiver: null,
    _sender: null,
    _socket: null,
    _bufferedAmount: 0,
    _isServer: false,
    _redirects: 0,
    _autoPong: true,
    _url: 'wss://35.232.28.18/v2',
    _req: null,
    [Symbol(shapeMode)]: false,
    [Symbol(kCapture)]: false
  },
  [Symbol(kType)]: 'error',
  [Symbol(kError)]: Error: unable to verify the first certificate
      at TLSSocket.onConnectSecure (node:_tls_wrap:1674:34)
      at TLSSocket.emit (node:events:518:28)
      at TLSSocket._finishInit (node:_tls_wrap:1085:8)
      at ssl.onhandshakedone (node:_tls_wrap:871:12) {
    code: 'UNABLE_TO_VERIFY_LEAF_SIGNATURE'
  },
  [Symbol(kMessage)]: 'unable to verify the first certificate'
}
error: script "db:migrate" exited with code 1
error: script "build-migrate-db" exited with code 1
error: script "postbuild" exited with code 1
Error: Command "bun run build" exited with 1

---

是什么原因

[m-guo]

在话题搜索框里可以进行全文检索。版本 v1.3.5

我的部署环境完全使用官方文档的步骤和用到的服务（数据库）。

[shog86]

在话题搜索框里可以进行全文检索。版本 v1.3.5

我的部署环境完全使用官方文档的步骤和用到的服务（数据库）。

这儿搜索是有结果的，但你在助手列表那里（也就是首页）搜索有结果吗，我就搜看到的助手名字（里的一个词）都没任何结果显示

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Full-text search can be performed in the topic search box. Version v1.3.5

My deployment environment completely uses the steps of the official documentation and the services (database) used.

Do you have any results for your search? I just searched for the name of the assistant (one word in it) but no results were displayed.

[m-guo]

在话题搜索框里可以进行全文检索。版本 v1.3.5 我的部署环境完全使用官方文档的步骤和用到的服务（数据库）。

这儿搜索是有结果的，但你在助手列表那里（也就是首页）搜索有结果吗，我就搜看到的助手名字（里的一个词）都没任何结果显示

没有啊，这个单子原本就是反馈这个问题的，我这个只是补充下信息。

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

 Full text search can be performed in the topic search box. Version v1.3.5 My deployment environment completely uses the steps of the official documentation and the services (database) used.

The search here yields results, but does your search in the assistant list (that is, the home page) yield any results? I just searched for the assistant name (one word in it) and no results were displayed.

No, this list was originally for feedback on this issue. I am just adding information.

[Aliang-code]

应该是要指定这个

# 指定 Postgres database driver 为 node
DATABASE_DRIVER=node

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

This should be specified

#Specify Postgres database driver as node
DATABASE_DRIVER=node

[m-guo]

应该是要指定这个

# 指定 Postgres database driver 为 node
DATABASE_DRIVER=node

我的情况确实是没有配置这个，翻了下文档，是应该添加这个环境变量。

但是我添加完，然后重新部署之后还是无法搜索，一样的现象。

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

This should be specified

# Specify Postgres database driver as node
DATABASE_DRIVER=node

In my case, this was indeed not configured. After reading the documentation, I found that this environment variable should be added.

But after I added it and redeployed it, I still couldn't search, the same phenomenon.

[m-guo]

应该是要指定这个

# 指定 Postgres database driver 为 node
DATABASE_DRIVER=node

我的情况确实是没有配置这个，翻了下文档，是应该添加这个环境变量。

但是我添加完，然后重新部署之后还是无法搜索，一样的现象。

我使用的 Vercel 提供的那个 Vercel Postgres，这个应该不需要配置DATABASE_DRIVER，所以还是不知道哪里的问题。

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

This should be specified

# Specify Postgres database driver as node
DATABASE_DRIVER=node

In my case, this is indeed not configured. I looked through the documentation and found that this environment variable should be added.

But after I added it and redeployed it, I still couldn't search, the same phenomenon.

The Vercel Postgres provided by Vercel that I use should not need to be configured with DATABASE_DRIVER, so I still don’t know what the problem is.

[arvinxx]

是 bug ，我近期修下

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

It's a bug, I'll fix it soon

[80imike]

是 bug ，我近期修下

v1.15.6 这个 bug 依旧存在，现在是还没有修复吗？ @arvinxx

部署环境为 docker

[CloudPassenger]

The same problem occurs in my senerio, using Vercel + Neon Postgres deployment

[arvinxx]

@80imike @CloudPassenger 还没修，近期修复

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

@80imike @CloudPassenger Not fixed yet, will be fixed soon

[80imike]

@80imike @CloudPassenger 还没修，近期修复

这个问题 1.9.22 还没有修复呀，期待尽快修复，没有搜索的确不方便

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

@80imike @CloudPassenger Not fixed yet, will be fixed soon

This problem has not been fixed in 1.9.22. We hope it will be fixed as soon as possible. It is really inconvenient not to search.

[zcsunt]

same problem

[80imike]

再来看看，期待早日修复

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Let’s take another look and look forward to an early fix.

[m-guo]

期待早日修复，还是很重要的功能的。

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Looking forward to an early fix, it is still a very important function.

[80imike]

这个 bug 修复优先级有点低呀，这都 4 个月了还没有修

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

The priority of fixing this bug is a bit low. It has not been fixed for more than 4 months.

[arvinxx]

@80imike 这个月后半月弄下，其实也困扰我😅

[lobehubbot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

@80imike I got it done in the second half of this month, it actually bothers me too😅