ListComments bringt nur leeren Inhalt

Begonnen von ernie, 22 April 2007, 10:42:09

⏪ vorheriges - nächstes ⏩

0 Mitglieder und 1 Gast betrachten dieses Thema.

ernie

 :quest Vielleicht weiss jemand Rat? Wenn ich im Admin Menü die Kommentare "ändern" möchte, gehe ich über "Kommentare moderieren" - drücke ich darauf kommen keine "Kommentare", die es im System in den Newsbeiträgen gibt, sondern nur eine leere Seite.

Andi

Moin :)

kommen Meldungen, wenn der Debug-Modus eingeschaltet ist?
schön´s Grüssle, Andi

ernie

 :note: Hallo Andi, folgende Fehlermeldung:

Notice: Undefined index: user_ingroup in /var/www/vhosts/meinedomain.de/httpdocs/includes/mx_system.php on line 281

Notice: Undefined index: user_ingroup in /var/www/vhosts/meinedomain.de/httpdocs/includes/mx_api.php on line 759
      

Andi

Moin :)

der ausgegebene Fehler hat zwar nichts direkt mit dem Problem zu tun, ist aber doch recht schwerwiegend...

War das eine pragmaMx-Neuinstallation, oder wurden da irgendwelche Daten aus anderen Systemen (z.B. phpNuke) übernommen?

Schalte auch mal die Option "SQL-Fehler anzeigen?" aktiv und schau was kommt...
schön´s Grüssle, Andi

ernie

 :) Hallo Andi,

es war eine reine Neuinstallation... Ursprünglich auf einen anderen "Speicherplatz" = anderer Domain des Servers.

Fehler ist wie folgend:

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}_cpg1410_comments` WHERE `msg_body` <> '' ORDER BY `cdate` DESC LIMIT 0, 21;
descr: Lost connection to MySQL server during query ( mysql 2013 )
details:

file: /admin/modules/comments.php # line: 198, cmd: sql_query(
    SELECT 'downloads' as ctype, ratingdbid as cid, ratinglid a...),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(
    SELECT 'downloads' as ctype, ratingdbid as cid, ratinglid a...),
file: /admin/case/case.comments.php # line:  27, cmd: include(
    SELECT 'downloads' as ctype, ratingdbid as cid, ratinglid a..., /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(
    SELECT 'downloads' as ctype, ratingdbid as cid, ratinglid a..., /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: update {prefix}_counter set count=count+1 where (type='total' and var='hits') or (var='Mozilla' and type='browser') or (var='Windows' and type='os')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 239, cmd: sql_query(update mx_counter set count=count+1 where (type='total' and var=...),
file: /header.php # line:  49, cmd: mxcounter(update mx_counter set count=count+1 where (type='total' and var=...),
file: /admin/modules/comments.php # line: 203, cmd: include(update mx_counter set count=count+1 where (type='total' and var=..., /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(update mx_counter set count=count+1 where (type='total' and var=..., /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(update mx_counter set count=count+1 where (type='total' and var=..., /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(update mx_counter set count=count+1 where (type='total' and var=..., /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: select count(hour) from {prefix}_stats where (year='2007') and (month='4') and (date='24')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 247, cmd: sql_query(select count(hour) from mx_stats where (year='2007') and (month=...),
file: /header.php # line:  49, cmd: mxcounter(select count(hour) from mx_stats where (year='2007') and (month=...),
file: /admin/modules/comments.php # line: 203, cmd: include(select count(hour) from mx_stats where (year='2007') and (month=..., /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(select count(hour) from mx_stats where (year='2007') and (month=..., /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(select count(hour) from mx_stats where (year='2007') and (month=..., /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(select count(hour) from mx_stats where (year='2007') and (month=..., /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
details:

file: /includes/mx_api_2.php # line: 248, cmd: sql_fetch_row(false),
file: /header.php # line:  49, cmd: mxcounter(false),
file: /admin/modules/comments.php # line: 203, cmd: include(false, /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(false, /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(false, /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(false, /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '0', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','0','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','0','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','0','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','0','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','0','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','0','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '1', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','1','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','1','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','1','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','1','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','1','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','1','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '2', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','2','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','2','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','2','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','2','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','2','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','2','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '3', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','3','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','3','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','3','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','3','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','3','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','3','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '4', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','4','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','4','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','4','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','4','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','4','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','4','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '5', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','5','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','5','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','5','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','5','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','5','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','5','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '6', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','6','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','6','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','6','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','6','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','6','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','6','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '7', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','7','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','7','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','7','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','7','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','7','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','7','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '8', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','8','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','8','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','8','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','8','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','8','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','8','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '9', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','9','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','9','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','9','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','9','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','9','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','9','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '10', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','10','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','10','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','10','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','10','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','10','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','10','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '11', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','11','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','11','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','11','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','11','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','11','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','11','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '12', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','12','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','12','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','12','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','12','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','12','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','12','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '13', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','13','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','13','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','13','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','13','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','13','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','13','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '14', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','14','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','14','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','14','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','14','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','14','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','14','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '15', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','15','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','15','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','15','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','15','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','15','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','15','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '16', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','16','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','16','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','16','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','16','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','16','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','16','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '17', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','17','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','17','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','17','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','17','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','17','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','17','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '18', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','18','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','18','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','18','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','18','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','18','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','18','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '19', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','19','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','19','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','19','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','19','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','19','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','19','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '20', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','20','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','20','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','20','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','20','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','20','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','20','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '21', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','21','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','21','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','21','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','21','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','21','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','21','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '22', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','22','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','22','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','22','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','22','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','22','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','22','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: REPLACE INTO {prefix}_stats values('2007', '4', '24', '23', '0')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 251, cmd: sql_query(REPLACE INTO mx_stats values('2007','4','24','23','0')),
file: /header.php # line:  49, cmd: mxcounter(REPLACE INTO mx_stats values('2007','4','24','23','0')),
file: /admin/modules/comments.php # line: 203, cmd: include(REPLACE INTO mx_stats values('2007','4','24','23','0'), /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(REPLACE INTO mx_stats values('2007','4','24','23','0'), /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(REPLACE INTO mx_stats values('2007','4','24','23','0'), /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(REPLACE INTO mx_stats values('2007','4','24','23','0'), /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: update {prefix}_stats set hits=hits+1 where (year='2007') and (month='4') and (date='24') and (hour='16')
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api_2.php # line: 255, cmd: sql_query(update mx_stats set hits=hits+1 where (year='2007') and (month='...),
file: /header.php # line:  49, cmd: mxcounter(update mx_stats set hits=hits+1 where (year='2007') and (month='...),
file: /admin/modules/comments.php # line: 203, cmd: include(update mx_stats set hits=hits+1 where (year='2007') and (month='..., /header.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(update mx_stats set hits=hits+1 where (year='2007') and (month='..., /header.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(update mx_stats set hits=hits+1 where (year='2007') and (month='..., /header.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(update mx_stats set hits=hits+1 where (year='2007') and (month='..., /header.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRENT_DATE, 5) < RIGHT(user_bday, 5)) AS user_age from {prefix}_users where uname='webworker' and pass='887b114a5228eb6388906eaa254ea3f0' and user_stat=1
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_api.php # line: 598, cmd: sql_query(select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRE...),
file: /includes/mx_system.php # line: 280, cmd: mxgetuserdata(select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRE...),
file: /includes/mx_themes.php # line: 180, cmd: mxgetallblocks(select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRE..., l),
file: /footer.php # line:  41, cmd: themefooter(select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRE..., l),
file: /admin/modules/comments.php # line: 306, cmd: include(select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRE..., l, /footer.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRE..., l, /footer.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRE..., l, /footer.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(select *, (YEAR(CURRENT_DATE) - YEAR(user_bday)) - ( RIGHT(CURRE..., l, /footer.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: SELECT block_id FROM {prefix}_groups_blocks WHERE (group_id=1)
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )
details:

file: /includes/mx_system.php # line: 305, cmd: sql_query(SELECT block_id FROM mx_groups_blocks WHERE (group_id=1)),
file: /includes/mx_themes.php # line: 180, cmd: mxgetallblocks(SELECT block_id FROM mx_groups_blocks WHERE (group_id=1), l),
file: /footer.php # line:  41, cmd: themefooter(SELECT block_id FROM mx_groups_blocks WHERE (group_id=1), l),
file: /admin/modules/comments.php # line: 306, cmd: include(SELECT block_id FROM mx_groups_blocks WHERE (group_id=1), l, /footer.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(SELECT block_id FROM mx_groups_blocks WHERE (group_id=1), l, /footer.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(SELECT block_id FROM mx_groups_blocks WHERE (group_id=1), l, /footer.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(SELECT block_id FROM mx_groups_blocks WHERE (group_id=1), l, /footer.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: SELECT * FROM {prefix}_blocks WHERE (active=1) AND (active = 1) AND ((view = 0) OR (view = 2)) AND (position <> 'r') AND position NOT IN('c', 'd') ORDER BY position, weight ASC
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ( mysql 2002 )
details:

file: /includes/mx_system.php # line: 325, cmd: sql_query(SELECT * FROM mx_blocks
                  WHERE (active=1) AND (active = 1)...),
file: /includes/mx_themes.php # line: 180, cmd: mxgetallblocks(SELECT * FROM mx_blocks
                  WHERE (active=1) AND (active = 1)..., l),
file: /footer.php # line:  41, cmd: themefooter(SELECT * FROM mx_blocks
                  WHERE (active=1) AND (active = 1)..., l),
file: /admin/modules/comments.php # line: 306, cmd: include(SELECT * FROM mx_blocks
                  WHERE (active=1) AND (active = 1)..., l, /footer.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(SELECT * FROM mx_blocks
                  WHERE (active=1) AND (active = 1)..., l, /footer.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(SELECT * FROM mx_blocks
                  WHERE (active=1) AND (active = 1)..., l, /footer.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(SELECT * FROM mx_blocks
                  WHERE (active=1) AND (active = 1)..., l, /footer.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: select main_module from {prefix}_main WHERE main_module <> ''
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ( mysql 2002 )
details:

file: /includes/mx_api.php # line: 805, cmd: sql_query(select main_module from mx_main WHERE main_module <> ''),
file: /includes/mx_api.php # line: 762, cmd: mxgetmainmodulename(select main_module from mx_main WHERE main_module <> ''),
file: /themes/hallotheme/functions.php # line: 460, cmd: mxmoduleallowed(select main_module from mx_main WHERE main_module <> '', Search),
file: /themes/hallotheme/functions.php # line: 246, cmd: mx_theme_searchform(select main_module from mx_main WHERE main_module <> '', Search),
file: /includes/mx_themes.php # line: 207, cmd: theme_replace_end(select main_module from mx_main WHERE main_module <> '', Search, <center>
<table style="width: 980px; text-align: left; margin-le...),
file: /footer.php # line:  41, cmd: themefooter(select main_module from mx_main WHERE main_module <> '', Search, <center>
<table style="width: 980px; text-align: left; margin-le...),
file: /admin/modules/comments.php # line: 306, cmd: include(select main_module from mx_main WHERE main_module <> '', Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(select main_module from mx_main WHERE main_module <> '', Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(select main_module from mx_main WHERE main_module <> '', Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(select main_module from mx_main WHERE main_module <> '', Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
details:

file: /includes/mx_api.php # line: 806, cmd: sql_fetch_row(false),
file: /includes/mx_api.php # line: 762, cmd: mxgetmainmodulename(false),
file: /themes/hallotheme/functions.php # line: 460, cmd: mxmoduleallowed(false, Search),
file: /themes/hallotheme/functions.php # line: 246, cmd: mx_theme_searchform(false, Search),
file: /includes/mx_themes.php # line: 207, cmd: theme_replace_end(false, Search, <center>
<table style="width: 980px; text-align: left; margin-le...),
file: /footer.php # line:  41, cmd: themefooter(false, Search, <center>
<table style="width: 980px; text-align: left; margin-le...),
file: /admin/modules/comments.php # line: 306, cmd: include(false, Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(false, Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(false, Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(false, Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


Error sql_query():
qry: SELECT m.mid, m.title FROM {prefix}_modules AS m LEFT JOIN {prefix}_groups_modules AS g ON m.mid = g.module_id WHERE ((title = 'News') OR (view = 0 AND active=1) OR (view = 1 AND g.group_id=1 AND active=1) OR (view = 2)) ORDER BY m.title ASC
descr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ( mysql 2002 )
details:

file: /includes/mx_api.php # line: 777, cmd: sql_query(SELECT m.mid, m.title
             FROM mx_modules AS m LEFT JOI...),
file: /themes/hallotheme/functions.php # line: 460, cmd: mxmoduleallowed(SELECT m.mid, m.title
             FROM mx_modules AS m LEFT JOI..., Search),
file: /themes/hallotheme/functions.php # line: 246, cmd: mx_theme_searchform(SELECT m.mid, m.title
             FROM mx_modules AS m LEFT JOI..., Search),
file: /includes/mx_themes.php # line: 207, cmd: theme_replace_end(SELECT m.mid, m.title
             FROM mx_modules AS m LEFT JOI..., Search, <center>
<table style="width: 980px; text-align: left; margin-le...),
file: /footer.php # line:  41, cmd: themefooter(SELECT m.mid, m.title
             FROM mx_modules AS m LEFT JOI..., Search, <center>
<table style="width: 980px; text-align: left; margin-le...),
file: /admin/modules/comments.php # line: 306, cmd: include(SELECT m.mid, m.title
             FROM mx_modules AS m LEFT JOI..., Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(SELECT m.mid, m.title
             FROM mx_modules AS m LEFT JOI..., Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php),
file: /admin/case/case.comments.php # line:  27, cmd: include(SELECT m.mid, m.title
             FROM mx_modules AS m LEFT JOI..., Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(SELECT m.mid, m.title
             FROM mx_modules AS m LEFT JOI..., Search, <center>
<table style="width: 980px; text-align: left; margin-le..., /footer.php, /admin/modules/comments.ph..., /admin/case/case.comments....),


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

file: /admin/modules/comments.php # line: 204, cmd: sql_fetch_assoc(false),
file: /admin/modules/comments.php # line: 320, cmd: listcomments(false),
file: /admin/case/case.comments.php # line:  27, cmd: include(false, /admin/modules/comments.ph...),
file: /admin.php # line: 664, cmd: include(false, /admin/modules/comments.ph..., /admin/case/case.comments....),

Andi

Hi :)

oki, die ersten beiden hätten gereicht....

Knackpunkt ist das:
Zitatdescr: Lost connection to MySQL server during query ( mysql 2013 )
und das:
Zitatdescr: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ( mysql 2002 )

Falls sich das nicht irgendwann alleine erledigt, dann wende dich an deinen Provider und frage, was mit dem sql-Server los ist. Da stimmt was nicht ;)
schön´s Grüssle, Andi

maverik

moin moin

wenn da mal nicht wieder die sql version hupt  :gruebel: 

eventuell version 4.1.10a auf dem server  :quest, in der version haben wir uns doch mit der weißen seite rumgeschlagen welche auf einen bug in der mysql version bezogen wurde.

ich hatte die gleiche version und auch eine weiße seite, seitdem update auf mysql 5.0.27 schnurrt es wie ein kätzchen


so long maverik

ernie

 :smile: Danke euch... Maverik, Du hast Recht... Es ist eine ältere MySQL mit Plesk auf meinem Server... Da kann ich so ohne weiteres nicht die MySQL updaten, sondern muss mir die Patches von SW Soft vornehmen, wenn nicht sogar Plesk updaten... Mist... :red: :mad2: