Kommentare moderieren

[Gast]

Willkommen Gast. Bitte einloggen oder registrieren.

Einloggen mit Benutzername und Passwort

[lines]

In Diesem Thread http://www.pragmamx.org/Forum-topic-20515.html schon mal besprochen,
mit geht es genauso, Versionen:

MySQL-Version:     4.1.11-Debian_etch1-log
pragmaMx 0.1.10, 1.30.2.13/2008-02-02

Da hilft wohl Service Pack 2 auch nicht

Gruß Lines

[JoergK]

Hoi

Das im benannten Thread erwähnte SP2 ist ausschliesslich für pragmaMx 0.1.9 inkl. SP1 geeignet. Da Du bereits die V0.1.10 hast, benötigst Du es nicht, dann in dieser (z.Zt. aktuellen) Version sind alle früheren Service Packs anthalten.

Möglicherweise liegt es, ähnlich wie in diesem Thread erwähnt, an der MySQL-Version. Hier solltest Du sowieso mal mit Deinem Hoster sprechen, denn die letzte 4er Version ist die 4.1.22 (http://dev.mysql.com/downloads/mysql/4.1.html). Aktueller ist sowieso die 5er Reihe, deren aktuelle Version (für Ubuntu / Debian-etch) die 5.0.51a (http://dev.mysql.com/downloads/mysql/5.0.html#ubuntu) ist.

[lines]

Habe jetzt MySQL-Version:  5.0.32-Debian_7etch6 lt Pragma, der Fehler:

Code: [Select]  

Error sql_query():
qry: 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}_cpg1418_comments` WHERE `msg_body` <> '' ORDER BY `cdate` DESC LIMIT 0, 21;
descr: Illegal mix of collations for operation 'UNION' ( mysql 1271 )

details:

file: /admin/modules/comments.php # line: 192,  cmd: sql_query(
    SELECT 'downloads' as ctype,  ratingdbid as cid,  ratinglid a...),
file: /admin/modules/comments.php # line: 313,  cmd: ListComments(
    SELECT 'downloads' as ctype,  ratingdbid as cid,  ratinglid a...),
file: /admin/case/case.comments.php # line:  28,  cmd: include(
    SELECT 'downloads' as ctype,  ratingdbid as cid,  ratinglid a...,  /admin/modules/comments.php),
file: /admin.php # line: 830,  cmd: include(
    SELECT 'downloads' as ctype,  ratingdbid as cid,  ratinglid a...,  /admin/modules/comments.php,  /admin/case/case.comments.php),

und:

Code: [Select]  

Error sql_fetch_assoc():
descr: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

details:

file: /admin/modules/comments.php # line: 198,  cmd: sql_fetch_assoc(false),
file: /admin/modules/comments.php # line: 313,  cmd: ListComments(false),
file: /admin/case/case.comments.php # line:  28,  cmd: include(false,  /admin/modules/comments.php),
file: /admin.php # line: 830,  cmd: include(false,  /admin/modules/comments.php,  /admin/case/case.comments.php),

 
Dieter