walinejs / waline

💬 A Simple, Safe Comment System
https://waline.js.org/en/
GNU General Public License v2.0
2.21k stars 381 forks source link

[Bug]: 导入TiDB 的 SQL 数据只有 wl_Users 数据表 || [Bug]: The SQL data imported into TiDB is only the wl_Users data table #2585

Closed AkarinLiu closed 3 months ago

AkarinLiu commented 3 months ago

问题描述 | Describe the bug

复制 TiDB 的 SQL 脚本后,导入只有 wl_Users 数据表,其他的数据表没有创建成功。

问题网站 | Website URL

https://tidbcloud.com/console/clusters/10072868295899316623/sqleditor?orgId=1372813089209232624&projectId=1372813089454550142

服务部署在哪里? | Where your waline deploy?

Other

数据存储在哪里?| Where your comment data store?

TiDB


Problem description | Describe the bug

After copying the TiDB SQL script, only the wl_Users data table was imported, and other data tables were not created successfully.

Question Website | Website URL

https://tidbcloud.com/console/clusters/10072868295899316623/sqleditor?orgId=1372813089209232624&projectId=1372813089454550142

Where is the service deployed? | Where your waline deploy?

Other

Where is the data stored? | Where your comment data store?

TiDB

lizheming commented 3 months ago

TiDB 的 SQL 执行只能执行光标所在的当前行,所以你需要按行执行下才行。


TiDB's SQL execution can only execute the current row where the cursor is located, so you need to execute it row by row.

AkarinLiu commented 3 months ago

现在可以了,我全选代码后就行。

邮件来自 Outlook for Windows


发件人: Austin Lee @.> 发送时间: 2024年6月27日 18:58 收件人: walinejs/waline @.> 抄送: 阿卡林刘 @.>; Author @.> 主题: Re: [walinejs/waline] [Bug]: 导入TiDB 的 SQL 数据只有 wl_Users 数据表 || [Bug]: The SQL data imported into TiDB is only the wl_Users data table (Issue #2585)

TiDB 的 SQL 执行只能执行光标所在的当前行,所以你需要按行执行下才行。


TiDB's SQL execution can only execute the current row where the cursor is located, so you need to execute it row by row.

― Reply to this email directly, view it on GitHubhttps://github.com/walinejs/waline/issues/2585#issuecomment-2194385487, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AN3EBU25NUDA653EQVE4Q33ZJPV53AVCNFSM6AAAAABJ7OOOXCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOJUGM4DKNBYG4. You are receiving this because you authored the thread.Message ID: @.***>