pphlogger schwarz

[zzz]

alle paar Monate das gleiche spiel. Der ppphlogger bekommt ab und zu Probleme und ist ein paar Tage schwarz mit folgenden Fehlermeldungen schwarz auf schwarz.

Code: Alles auswählen

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 18 in /srv/www/htdocs/web870/html/stats/stats/libraries/functions.lib.php on line 1667

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web870/html/stats/stats/include/get_csscolors.inc.php on line 18

Warning: Cannot modify header information - headers already sent by (output started at /srv/www/htdocs/web870/html/stats/stats/libraries/functions.lib.php:1667) in /srv/www/htdocs/web870/html/stats/stats/include/head.inc.php on line 13

Warning: Cannot modify header information - headers already sent by (output started at /srv/www/htdocs/web870/html/stats/stats/libraries/functions.lib.php:1667) in /srv/www/htdocs/web870/html/stats/stats/include/head.inc.php on line 14

Warning: Cannot modify header information - headers already sent by (output started at /srv/www/htdocs/web870/html/stats/stats/libraries/functions.lib.php:1667) in /srv/www/htdocs/web870/html/stats/stats/include/head.inc.php on line 16

kennst das jemand und hat einer eine Lösung für dieses Problem... Immer neuinsstallieren macht wenig Spaß.

[kill_bill]

Hm, wenn ich mir den Quelltext von functions.lib.php anschaue (so um die Line 1667) finde ich da folgendes:

Code: Alles auswählen

function resetCssIDs() {
	
	// restore cssid in pphl_settings
	$sql = "SELECT value FROM ".PPHL_TBL_SETTINGS." WHERE setting = 'cssid'";
	$res = mysql_query($sql);
	$cssid_setting = mysql_result($res, 0, 0);
	$sql = "SELECT * FROM ".PPHL_TBL_CSS." WHERE id = $cssid_setting AND userid = 0";
	$res = mysql_query($sql);
	if (!@mysql_num_rows($res)) { // if cssid in pphl is not valid, choose first id in pphl_css
		$sql = "SELECT id FROM ".PPHL_TBL_CSS." WHERE userid = 0";
		$res2 = mysql_query($sql);
		$cssid_setting = mysql_result($res2, 0, 0);
		$sql = "UPDATE ".PPHL_TBL_SETTINGS." SET value = '$cssid_setting' WHERE setting = 'cssid'";
		$res2 = mysql_query($sql);
	}

Es scheint so, als würde aus welchen Gründen auch immer
$cssid_setting = mysql_result($res2, 0, 0);
zu keinem Ergebnis führen.
Dort wird eigentlich nachgeschaut, welches Farbset gewählt wurde...

Kleiner Lösungsvorschlag:

if (!@mysql_num_rows($res)) { // if cssid in pphl is not valid, choose first id in pphl_css
$sql = "SELECT id FROM ".PPHL_TBL_CSS." WHERE userid = 0";
$res2 = mysql_query($sql);
$cssid_setting =@mysql_result($res2, 0, 0);
if (!$cssid_setting){ $cssid_setting=1; }
$sql = "UPDATE ".PPHL_TBL_SETTINGS." SET value = '$cssid_setting' WHERE setting = 'cssid'";
$res2 = mysql_query($sql);
}

Das Farbset würde dann im Notfall auf Farbset Nr. 1 zurückspringen.
Den Wert $cssid_setting kannst Du natürlich auch nach belieben ändern.

Poste mal, ob das geholfen hat.

[marc75]

$cssid_setting =@mysql_result($res2, 0, 0);
if (!$cssid_setting){ $cssid_setting=1; }

Die Frage ist eher, warum liefert es kein Ergebnis mehr.

benutze mal:

echo mysql_error();