其他冇問題, 試過任何野都係正常, 但

發覺....profile睇view_warning_manager.php是空的, 沒有任何紀錄, 但該會員係有比警告的.........有什麼問題???

[ 本帖最後由 unyleung 於 2007-10-10 16:33 編輯 ]

依個有咩野需要?? 唔入都係一樣用到, 入面又冇任何設定, 好似入唔入都得

SQL: SELECT w.*, p.wnmessagepost, p.message, p.hidepost, p.tid, p.pid, t.subject FROM [Table]warninglog w LEFT JOIN [Table]posts p ON w.pid=p.pid LEFT JOIN [Table]threads t ON p.tid=t.tid WHERE w.pid=p.pid ORDER BY dateline DESC LIMIT 0, 20
Error: Unknown column 'p.wnmessagepost' in 'field list'
Errno.: 1054

點解會咁既??

ALTER TABLE `cdb_warninglog` CHANGE `username` `username` VARCHAR( 15 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL;
ALTER TABLE `cdb_warninglog` CHANGE `wnuser` `wnuser` VARCHAR( 15 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL;

升級吾到

正要考慮是否安裝這個…

thx

謝謝大大您的分享與提供
可否也開發個在6.0裡使用

感謝您的分享

Discuz! 訊息: MySQL 服務器出現錯誤

用戶: 〒琳千夜♂
時間: 2008-11-10 12:06am
程序: /ms/view_warning_manager.php

SQL: SELECT w.*, p.wnmessagepost, p.message, p.hidepost, p.tid, p.pid, t.subject FROM [Table]warninglog w LEFT JOIN [Table]posts p ON w.pid=p.pid LEFT JOIN [Table]threads t ON p.tid=t.tid WHERE w.pid=p.pid and w.wnuser='〒琳千夜♂'
錯誤: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (big5_chinese_ci,COERCIBLE) for operation '='
錯誤號: 1267


解咩 ?? 可以幫下我ma ?