Arrgh... errors

[CD999]

General Category

An Error Has Occurred!

2: mysql_num_rows(): supplied argument is not a valid MySQL result resource
((path)\yabbse\Sources\BoardIndex.php ln 176)

Everything else works, but anything that tries to call the posting (most recent post in the admin panel, etc) gives me a similar error.

[Chris Cromer]

Could you show me your line 176 in your BoardIndex.php?

[CD999]

Alright

Code Select Expand

class="bordercolor">

[David]

Line 176 is actually

Code Select Expand

$rowmem = mysql_fetch_row($result3);
in context

Code Select Expand

if ($latestPostID != '-1') {
                                $result3 = mysql_query("SELECT memberName,realN$
                                $rowmem = mysql_fetch_row($result3);
                                $latestPostRealName = isset($rowmem[1])?$rowmem$
                        }

[CD999]

odd. In context, my Line 176 is

Code Select Expand

<table border="0" width="100%" cellspacing="0" cellpadding="0" class="bordercolor"><tr><td>
<table border=0 width="100%" cellspacing="1" cellpadding="5" class="bordercolor">
  <tr>
    <td class="titlebg" colspan="2"><b>$txt[20]</b></td>
    <td class="titlebg" width="6%" align="center"><b>$txt[330]</b></td>
    <td class="titlebg" width="6%" align="center"><b>$txt[21]</b></td>
    <td class="titlebg" width="22%" align="center"><b>$txt[22]</b></td>
  </tr>


[mediman]

i have had a user with the same prob!

the solution: it was the disk quota! if your yabbse can write on disc then this error appears! try with ftp to upload a file to your yabbse folder, maybe you have also a disk quota error!

mediman

[CD999]

That isn't the problem either. I just checked. I don't have a disk quota except for the size of my HD. This is being hosted on my own PC.

[mediman]

try to empty (clear) "log_boards" this will fix your prob!

mediman

[CD999]

that didnt work either... this just happened one day out of nowhere.

[mediman]

have you cleared all logs? in db, not only in admin center? and have you tried to repair the table "log_clicks" table?

[mediman]

try to optimze your tables with our script , maybe any tables have to many space usage!

mediman

Code Select Expand

<?

$db_name = "";
$db_user = "";
$db_passwd = "";
$db_server = "localhost";

mysql_connect("$db_server","$db_user","$db_passwd");
$vers = mysql_get_server_info();
echo "We found a MySQL Server with Version <b>$vers</b> installed!<br>";
optimize();

function optimize() {
global $db_name;
mysql_select_db($db_name);
$tables=mysql_list_tables($db_name);
while (list($bla)=mysql_fetch_array($tables)) {
$result = mysql_query("OPTIMIZE TABLE $bla")or die("Invalid query");
echo "Table <font color=blue>".$bla."</font> analyzed and optimized!<br>";
}
}

?>

[CD999]

  everything that has been suggested doesn't work. i am considering reinstalling and starting over again.

[mediman]

can i have a link to the board?

mediman

[CD999]

http://24.128.153.169/yabbse/

it's nothing much, just a little board I made for a friend.

[CD999]

sorry, I kinda forgot i had it set for registered users only

login: test p/w:test