安裝Event元件後出現錯誤
- Mike Ho@dogneighbor.com
-
Topic Author
- 訪客
-
2006-07-25 17:53 #3390
來自 Mike Ho@dogneighbor.com
Mike Ho@dogneighbor.com created the topic: 安裝Event元件後出現錯誤
安裝過程順利
第一次按下manage event時帶到設定頁，設定後再按manage event 出現以下錯誤：
是我的mySQL問題嗎
mySQL 5.0
PHP 5
Joomla v1.0.10 中文stable
第一次按下manage event時帶到設定頁，設定後再按manage event 出現以下錯誤：
DB function failed with error number 1054
Unknown column 'a.checked_out' in 'on clause' SQL=SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname FROM jos_events AS a, jos_categories AS cc LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_groups AS g ON g.id = a.access WHERE a.catid=cc.id ORDER BY a.catid LIMIT 0,50是我的mySQL問題嗎
mySQL 5.0
PHP 5
Joomla v1.0.10 中文stable
Please 登入 to join the conversation.
- Mike Ho@dogneighbor.com
-
Topic Author
- 訪客
-
2006-07-26 02:52 #3401
來自 Mike Ho@dogneighbor.com
Mike Ho@dogneighbor.com replied the topic: 安裝Event元件後出現錯誤
找到了解決方法
修改 admin.event.main.php
$where[] = "a.catid=cc.id"; $database->setQuery( "SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname" [code]$where[] = "a.catid=cc.id";
$database->setQuery( "SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname"
修改 admin.event.main.php
$where[] = "a.catid=cc.id"; $database->setQuery( "SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname" [code]$where[] = "a.catid=cc.id";
$database->setQuery( "SELECT a.*, cc.name AS category, u.name AS editor, g.name AS groupname"
Please 登入 to join the conversation.