I've got a classic site which has lately been exhibiting a mistake that is strange since it's been untouched for a while. I recieve the next:

Unable to jump to row 0 on MySQL result index 8

What's the reason for this and just how must i repair it?

It's a PHP/MySQL site.

Basically remember properly, this error typically comes from a code segment such as the following:

// You probably have some code similar to this
$var = mysql_result( $result, 0, 'column_name');

Where either the query fails or even the column does not exist. Make sure that $result is really a valid MySQL resource to make certain the SQL applies, then make certain you are really getting is a result of the database prior to trying to call mysql_result.

Or, even better, using mysql_fetch_array rather than by hand fetching every column value (for those who have multiple posts came back in the query).

Try examining the end result before fetching it. If outcome is empty, skip fetching.

$result = mysql_query("SELECT * FROM table1");
if (!$result || !mysql_num_rows($result)) {
    die('Empty set.');
while ($row = mysql_fetch_array($result)) {
    // Your code here