老師:
7.2.1 分類管理技巧
我是全新安裝 tadnews 1.3, 一開始只新增一個分類 "公告", 卻出現以下信息:
[color=0000FF]Errors [/color]
Notice: Undefined index: enable_post_group in file /modules/tadnews/admin/admin_function.php line 127
Warning: implode() [function.implode]: Invalid arguments passed in file /modules/tadnews/admin/admin_function.php line 127
Notice: Undefined index: setup in file /modules/tadnews/admin/admin_function.php line 129
Warning: Invalid argument supplied for foreach() in file /modules/tadnews/admin/admin_function.php line 129
Notice: Undefined variable: setup in file /modules/tadnews/admin/admin_function.php line 132
[color=0000FF]Queries [/color]
SET NAMES 'utf8'
SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM session WHERE sess_id = 'ms3q5pibcjva9qa9qcf07229v5'
SELECT * FROM users WHERE uid = '1'
SELECT * FROM modules WHERE dirname = 'tadnews'
SELECT * FROM config WHERE (conf_modid = '3') ORDER BY conf_order ASC
[color=FF0000]insert into tad_news_cate (of_ncsn,nc_title,enable_group,enable_post_group,sort,not_news,setup) values('0','��','','','1','0','')
[b]Error number: [/b]1364
[b]Error message: [/b]Field 'cate_pic' doesn't have a default value [/color]
SELECT COUNT(*) FROM banner
SELECT * FROM banner LIMIT 0, 1
SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM banner
SELECT * FROM banner LIMIT 0, 1
Total: 12 queries
[color=0000FF]Blocks [/color]
Total: 0 blocks
[color=0000FF]Extra [/color]
Included files: 56 files
Memory usage: 3795048 bytes
我自己沒有遇到這個問題,看看老師有空的時候是否幫您看看!?
不過您的中文編碼好像有點問題!
老師的模組,目前已經以支援2.33版為主了!
2.33支援big5與utf8的語系,這部份你要設定好喔!
建議再試試看先!
謝謝建議。
因為我是獨立安裝 Apache, MySQL, PHP 的, 說不定是設定上出錯。
我檢查了 mainfile.php:
// Set the database charset if applicable
if (defined("XOOPS_DB_CHARSET")) die();
define( 'XOOPS_DB_CHARSET', [color=0000FF]'utf8'[/color] );
在 phpMyAdmin 內檢查, table 'xoops_tad_news_cate' 內的欄位如 nc_title, enable_group 也是 utf8_general_ci, 應該沒有問題吧?
頭也大了, 不知哪裡出錯?!
試了安裝 tadgallery 1.3, 成功安裝後,嘗試新增分類,卻出現以下信息:
[color=FF0000]insert into tad_gallery_cate (of_csn,title,passwd,enable_group,enable_upload_group,sort,mode,show_mode) values('0','abcdef','','','1','1','instant','thubm')
Error number: 1364
Error message: Field 'cover' doesn't have a default value[/color]
翻查 tadnews 的 admin_function.php, 134 行的 insert into tad_news_cate, 並沒有給予 cate_pic 欄位任何值, 但 cate_pic 是定義做 not null 及沒有 default value。
那麼這句 insert 句子有什麼可能會成功呢?