1 頁 (共 1 頁)

[問題] 無法刪除版面

發表於 : 2005-05-16 20:45
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

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

發表於 : 2005-05-18 15:49
心靈捕手
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 看看.