iHello to all the good people of NukeCops forums.
i've been around here for a few days, searched the forums all over, and didn't find the soultion, so maybe one of you will.
the site was working perfect for a year when just a week ago, my host company decided I should move for better servers because i'm gaining too much bandwidth. since then, my problems started.
I'm using Nukof (the Israeli fork of Nuke) based on ver 5.4.
Php 4.3.1
MySQL 3.23.56
Windows 2000 Servers (my host's support told me they never had Unix servers, so that couldn't be a security issue)
I can see my index.php, so i guess config.php and nuke.sql are ok (i've checked them for 10 times now.. )
here are the errors:
in article.php, it shows:
Code:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Webspace\disk42\abulehleh.co.il\abulehleh.co.il\www\rotem\nuke\article.php on line 26
Warning: Cannot modify header information - headers already sent by (output started at C:\Webspace\disk42\abulehleh.co.il\abulehleh.co.il\www\rotem\nuke\article.php:26) in C:\Webspace\disk42\abulehleh.co.il\abulehleh.co.il\www\rotem\nuke\article.php on line 55
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Webspace\disk42\abulehleh.co.il\abulehleh.co.il\www\rotem\nuke\includes\sql_layer.php on line 273
You have an error in your SQL syntax near 'order by counter desc limit 0,1' at line 1
and here comes the code itself (i belive it related to some scoring addon the guys made it added..)
Code:
<?php
/************************************************************************/
/* NuKOF: The Hebrew Web Portal System (http://nukof.dotkof.org) */
/* =========================== */
/* */
/* Copyright (c) 2002 by Shlomi Atar (shlomi@dotkof.org) and */
/* Yossi Ben-Mashiach (yossi@dotkof.org) - the founders of */
/* Dotkof (dotkof.org) - The First Israeli Computer news Slash site */
/* http://dotkof.org */
/* */
/* Based On PHP NUKE (http://phpnuke.org), by */
/* Francisco Burzi (fbc@mandrakesoft.com) */
/* */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
require_once("mainfile.php");
// Before all actions, see if there is a row for story in scoring table
$q = "SELECT * FROM nuke_scoring WHERE sid=$sid";
$result = mysql_query($q);
if(mysql_num_rows($result) == 0) {
$q = "INSERT INTO nuke_scoring VALUES($sid, 0,0,0)";
mysql_query($q);
$vote_num = 0; $vote_total = 0; $vote_avg = 0;
} else {
$result = mysql_fetch_array($result);
$vote_num = $result[vote_num];
$vote_total = $result[vote_total];
}
/* This is a list for automatic related links on article internal page */
/* For this I used a multi-dimensional array so we can show the links titles */
/* as we want, doesn't matter the case of the string in the article. You can */
/* add or remove links from this array as you wish to fit your needs */
global $multilingual, $currentlang;
if ($multilingual == 1) {
$querylang = "AND (alanguage='$currentlang' OR alanguage='')"; /* the OR is needed to display stories who are posted to ALL languages */
} else {
$querylang = "";
}
$result2 = sql_query("select sid, title, acomm from $prefix"._stories." where topic=$topic $querylang order by counter desc limit 0,1", $dbi);
list($topstory, $ttitle, $acomm) = sql_fetch_row($result2, $dbi);
case 0:
$score_txt .= "<i>קוד הצבעה לא תקין</i><br>";
break;
case 1:
$score_txt .= "<i>כבר הצבעת לכתבה זו</i><br>";
break;
case 2:
$score_txt .= "<i>הצבעת בהצלחה</i><br>";
}
themesidebox("ניקוד הכתבה", $score_txt);
echo "</td></tr></table>\n";
cookiedecode($user);
if ((($mode != "nocomments") OR ($acomm == 0)) AND ($articlecomm == 1)) {
$thetitle = $title;
// include("comments.php");
$r_action = "show_bottom";
include("resp.php");
}
include ("footer.php");
?>
(if you can see, there's some hebrew text inside)
I did the debug thing, and all the rows appears on the SQL database.
besides this, all the modules gives me the "Sorry, you can't access this file directly..." and the search always give me the last 10 items that were added (no matter what i search for..)
for conclusion, phpnuke stopped loving me..
i've read the Idiots Guide and asked my host to set the files permissions. but when i asked them to change php.ini, they said they couldn't do it because it will affect all others users.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
