[問題] 無法刪除版面

phpBB Installation & Usage Support
phpBB 2 安裝於各類型作業平台之問題討論;外掛問題,請到相關版面依發問格式發表!
(發表文章請按照公告格式發表,違者砍文)

版主: 版主管理群

版面規則
本區是討論關於 phpBB 2.0.X 架設安裝上的問題,只要有安裝任何外掛,請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表,違者砍文)
主題已鎖定
help
星球公民
星球公民
文章: 189
註冊時間: 2002-08-09 02:01
來自: 香港
聯繫:

[問題] 無法刪除版面

文章 help »

其實已經發生一般長時間,2.04 果時
這個版面有 6xxx 個 Post,一刪除就出現已下問題
已經 Update to 2.15 版本 ...
一般錯誤
Could not obtain list of posts to prune

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet'

SELECT post_id FROM phpbb_posts WHERE forum_id = 31 AND topic_id IN (2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712,
.
.
.
.
.
10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882)

Line : 69
File : prune.php
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8547
註冊時間: 2004-04-30 01:54
來自: Taiwan

Re: [問題] 無法刪除版面

文章 心靈捕手 »

help 寫:其實已經發生一般長時間,2.04 果時
這個版面有 6xxx 個 Post,一刪除就出現已下問題
已經 Update to 2.15 版本 ...
一般錯誤
Could not obtain list of posts to prune

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet'

SELECT post_id FROM phpbb_posts WHERE forum_id = 31 AND topic_id IN (2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712,
.
.
.
.
.
10882, 2710, 2711, 2712, 10882, 2710, 2711, 2712, 10882)

Line : 69
File : prune.php
建議您:
試試直接進入資料庫, 將該版面刪除.
  • phpMyAdmin-> phpbb( 資料庫)-> phpbb_forums( 資料表)->( 搜尋) forum_id = 31 -> 刪除
  • 或者是直接下刪除指令, 如下:

    代碼: 選擇全部

    DELETE FROM `phpbb_forums` WHERE `forum_id` = 31 
    
ps.
1. 執行刪除前, 請先備份資料庫;
2. 如果還是出現錯誤, 那麼建議您:
先( 搜尋) 刪除引言部份的主題: 2710, 2711, 2712, 10882 看看.
施比受有福,祝福您好運! ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
主題已鎖定

回到「phpBB 2 安裝與使用」