バージョンアップ後に
http://***/app/index.php/board?bat=upgrade0.6.0
を行いました
管理画面より掲示板一覧の掲示板名をクリックすると
以下のエラー
DETECT DATE:2009-08-12T18:46:36+09:00
MESSAGE:Invalid query(SQLSTATE[HY000]: General error: 1 no such column: response_id)
EXCEPTION TYPE:SOY2DAOException
LOCATION:/soycms/common/lib/soy2_build.php(2925)
SOY CMS Version:1.2.5a
SOY CMS DBType:sqlite
PHP Version:5.2.8
PHP SAPI NAME:apache2handler
PHP SAFE MODE:yes
USER_AGENT:Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.4506.2152; Sleipnir/2.8.5)
PATH_INFO:/board/Response/2
STACK TRACE
-----------------------
0:SOY2DAO->executeQuery
argument[0]:SOY2DAO_Query ["select thread_id,id,name,email,submitdate,hash,body,host,response_id from soyboard_response where thread_id = :threadId AND ID >= :offset AND ID < (:offset + :viewcount)"]
argument[1]:Array
/soycms/common/lib/soy2_build.php(3357) : eval()'d code(119)
-----------------------
1:SOYBoard_ResponseDAOImpl->getByThreadId
argument[0]:String("2")
argument[1]:1
argument[2]:100
/soycms/app/webapp/board/src/logic/ResponseLogic.class.php(37)
-----------------------
2:ResponseLogic->getByThreadId
argument[0]:String("2")
argument[1]:1
argument[2]:100
/soycms/app/webapp/board/pages/Response/IndexPage.class.php(25)
-----------------------
3:IndexPage->IndexPage
argument[0]:Array
/soycms/common/lib/soy2_build.php(5284)
-----------------------
4:SOY2HTMLFactory::createInstance
argument[0]:String("Response.IndexPage")
argument[1]:Array
/soycms/app/webapp/board/admin.php(100)
新規作成を実行すると
以下のエラーが発生します。
DETECT DATE:2009-08-12T18:43:24+09:00
MESSAGE:Invalid query(SQLSTATE[HY000]: General error: 1 no such column: response_id)
EXCEPTION TYPE:SOY2DAOException
LOCATION:/soycms/common/lib/soy2_build.php(2925)
SOY CMS Version:1.2.5a
SOY CMS DBType:sqlite
PHP Version:5.2.8
PHP SAPI NAME:apache2handler
PHP SAFE MODE:yes
USER_AGENT:Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.4506.2152; Sleipnir/2.8.5)
PATH_INFO:/board/Thread/Create
STACK TRACE
-----------------------
0:SOY2DAO->executeQuery
argument[0]:String("SELECT MAX(response_id) AS last FROM soyboard_response WHERE thread_id = :threadId")
argument[1]:Array
/soycms/common/lib/soy2_build.php(3357) : eval()'d code(100)
-----------------------
1:SOYBoard_ResponseDAOImpl->getLastResponseId
argument[0]:String("2")
/soycms/app/webapp/board/src/logic/ResponseLogic.class.php(11)
-----------------------
2:ResponseLogic->insert
argument[0]:String("2")
argument[1]:Array
/soycms/app/webapp/board/pages/Thread/CreatePage.class.php(10)
-----------------------
3:CreatePage->doPost
/soycms/common/lib/soy2_build.php(7424)
-----------------------
4:WebPage->prepare
/soycms/common/lib/soy2_build.php(7408)
どちらも掲示板一覧と詳細設定、掲示板の削除は正常のようです。
掲示板自体の書き込みは行えず送信をしてもスレッドが作られないようです。