Ich hab gerade mal geschaut wie die Funktion "Kommentare moderieren" funktioniert. Und musste leider feststellen: Gar nicht.
MySQL error (1271):
Illegal mix of collations for operation 'UNION'
query:
SELECT 'downloads' as ctype, ratingdbid as cid, ratinglid as parent, ratingcomments as `comment`, ratingtimestamp as `cdate`, ratinguser as `user`, ratinghostname as host, '' as subject
FROM `{prefix}_downloads_votedata`
WHERE `ratingcomments` ''
UNION
SELECT 'links' as ctype, ratingdbid as cid, ratinglid as parent, ratingcomments as `comment`, ratingtimestamp as `cdate`, ratinguser as `user`, ratinghostname as host, '' as subject
FROM `{prefix}_links_votedata`
WHERE `ratingcomments` ''
UNION
SELECT 'reviews' as ctype, cid, rid as parent, comments as `comment`, FROM_UNIXTIME(`date`) as `cdate`, username as `user`, '' as host, '' as subject
FROM `{prefix}_reviews_comments`
WHERE `comments` ''
UNION
SELECT 'news' as ctype, tid as cid, sid as parent, comment, FROM_UNIXTIME(`reply_date`) as `cdate`, name as `user`, host_name as host, subject
FROM `{prefix}_comments`
WHERE `comment` ''
UNION
SELECT 'polls' as ctype, tid as cid, pollID as parent, comment, `date` as `cdate`, name as `user`, host_name as host, subject
FROM `{prefix}_pollcomments`
WHERE `comment` ''
UNION
SELECT 'egallery' as ctype, cid, pid as parent, comment, `date` as `cdate`, name as `user`, '' as host, '' as subject
FROM `{prefix}_gallery_comments`
WHERE `comment` ''
UNION
SELECT 'copper' as ctype, msg_id as cid, pid as parent, msg_body as `comment`, msg_date as `cdate`, msg_author as `user`, msg_raw_ip as host, msg_hdr_ip as subject
FROM `{prefix}_cpg148_comments`
WHERE `msg_body` ''
ORDER BY `cdate` DESC
LIMIT 0, 21;
in admin/modules/comments.php on line 193
was issn hier los ?
pragmaMx Support Forum
