Scrolling Fourm block

Nuke Soldier Joined: Jan 31, 2003 Posts: 15 Location: USA

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /httpd/html/d2/sitename/includes/sql_layer.php on line 301

after installing the Scrolling Fourm block I created a new block and moved it to the right. Then I went to look at it in the home page and it split my screen in half, and gave me this error Question

* sql_fetch_row(&$res,$row)
* given a result identifier, returns an array with the resulting row
* Needs also a row number for compatibility with PostgreSQL
*/

function sql_fetch_row(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
line# 301 $row = mysql_fetch_row($res);
return $row;
break;;

I just wanted to take time to thank all of you that maintain this site you do a great job in keeping up with the users that have problems Exclamation

Keep up the good work guys, you are apreciated Exclamation

By me at least anyway....

Posted: Fri Feb 07, 2003 5:39 pm

Change lines 300-303 of sql_layer.php to:

Code:

case "MySQL":
if ($row = mysql_fetch_row($res)) {
return $row;
} else {
print (mysql_error());
}
break;;

This will not fix the problem but will return a better error report which usually will tell you what is wrong with the actual sql query.

Nuke Soldier Joined: Jan 31, 2003 Posts: 15 Location: USA

I figured it wouldn't fix the problem, it was just going to print the error assoiated with the problem, but in this case it still gave me the same error.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /httpd/html/d2/sitename/includes/sql_layer.php on line 301.
My screen is still split in half too....
Should I run a debug???? to see the error????

Nuke Soldier Joined: Jan 31, 2003 Posts: 15 Location: USA

I ran a de bug and I don't know if it means a hill of beans but here is the stuff.

SQL query: SELECT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id FROM nuke_bbtopics t, nuke_bbforums f where t.forum_id=f.forum_id and f.auth_view=0 ORDER BY t.topic_last_post_id DESC LIMIT 20

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /httpd/html/d2/sitename/includes/sql_layer.php on line 301

Posted: Fri Feb 07, 2003 6:51 pm

What version of Nuke did you use it for and have you checked if both those tables exist?

Nuke Soldier Joined: Jan 31, 2003 Posts: 15 Location: USA

6.0... what tables?

Posted: Fri Feb 07, 2003 7:02 pm

nuke_bbtopics and nuke_bbforums

Nuke Soldier Joined: Jan 31, 2003 Posts: 15 Location: USA

I have nuke_bbtopics but no nuke_bbFourms.

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Run analyzer for us, we'll get the details much faster.

Nuke Soldier Joined: Jan 31, 2003 Posts: 15 Location: USA

Ran analyze.php

phpBB2 Port Values for sitename Theme ID Style Name Template Name

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /httpd/html/sitename/analyze.php on line 429

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /httpd/html/sitename/analyze.php on line 434

I also got this error should I pay attention to this? Laughing

WARNING! WARNING! WARNING! Vulnerable MySQL Client On Your Server!
MySQL Client Version Reason For Vulnerability
3.23.52 A vulnerability has been discovered in MySQL that may cause a denial of service. It has been reported that, under certain circumstances, a malicious MySQL client may be able to trigger a condition in which MySQL attempts to free the same memory twice. MySQL Daemon can be crashed unless upgraded. Details can be found by clicking --> here. Until that is resolved, PHP-Nuke should be the least of your worries.

I have been away for a couple of days. Later guys!

Posted: Sun Feb 09, 2003 4:01 pm

As i understand it the scrolling block is meant for sites using the phpBB port, if the two tables i mentioned are not there i would say you don't have the port installed.

Nuke Soldier Joined: Jan 31, 2003 Posts: 15 Location: USA

Where could I get that and what would I need I'm confused on the bbport what is it and what does it do? I see one download to upgrade on your site is that what I need? Nukebbsql?

Posted: Sun Feb 09, 2003 6:09 pm

The bbtonuke forum is the one we are posting this on, and it's available at http://bbtonuke.sourceforge.net/

Guest

Where does one adjust this? I ask because on Netscape 6 the scrolling text in too small to read, though in IE it's fine.

Guest

Anyone point me in the right direction on this? I'm struggling to adjust the font size inside the scrolling forums block. What I'm trying to find out is where this is set. The forums stylesheet? The site stylesheet? Somewhere else?