Topic: Admin pane issues

I try to load the admin_index.php page, on a fresh install, and it tells me this:

An error was encountered
Error: Unable to fetch online count.

Whats happened?

Thanks in advance.

~Chad

Super Tech Audio Netcast
[img]http://img.vsig.org/chad.gif[/img]

Re: Admin pane issues

Enable debug mode, paste the full error

Re: Admin pane issues

An error was encountered
File: /mnt/w0001/d13/s17/b0298d19/www/whatistheamazon.com/microsec/admin_index.php
Line: 96

PunBB reported: Unable to fetch online count

Database reported: Lost connection to MySQL server during query (Errno: 2013)

~Chad

Super Tech Audio Netcast
[img]http://img.vsig.org/chad.gif[/img]

Re: Admin pane issues

http://punbb.org/forums/viewtopic.php?id=11845
Netfirms should reallu upgrade their version of MySQL

Re: Admin pane issues

Thanks Smartys

So there isn't very much I can do about it then?

~Chad

Super Tech Audio Netcast
[img]http://img.vsig.org/chad.gif[/img]

Re: Admin pane issues

You can comment out the line that displays the error wink

Re: Admin pane issues

I get a blank page then.. big_smile

Is there a way I can just change where the Administration link goes?  So i can have it go to admin_options.php instead?

thanks

~Chad

Super Tech Audio Netcast
[img]http://img.vsig.org/chad.gif[/img]

Re: Admin pane issues

FIND

// Get number of current visitors
$result = $db->query('SELECT COUNT(user_id) FROM '.$db->prefix.'online WHERE idle=0') or error('Unable to fetch online count', __FILE__, __LINE__, $db->error());
$num_online = $db->result($result);

REPLACE WITH

$num_online = 0;

Re: Admin pane issues

no dice.

An error was encountered
Error: Unable to fetch version info.

~Chad

Super Tech Audio Netcast
[img]http://img.vsig.org/chad.gif[/img]

Re: Admin pane issues

Enable debug mode wink

11

Re: Admin pane issues

Riight!  Forgot! big_smile

An error was encountered
File: /mnt/w0001/d13/s17/b0298d19/www/whatistheamazon.com/microsec/admin_index.php
Line: 106

PunBB reported: Unable to fetch version info

Database reported: Lost connection to MySQL server during query (Errno: 2013)

~Chad

Super Tech Audio Netcast
[img]http://img.vsig.org/chad.gif[/img]

Re: Admin pane issues

Chad92 wrote:

Riight!  Forgot! big_smile

An error was encountered
File: /mnt/w0001/d13/s17/b0298d19/www/whatistheamazon.com/microsec/admin_index.php
Line: 106

PunBB reported: Unable to fetch version info

Database reported: Lost connection to MySQL server during query (Errno: 2013)

FIND

    default:
        $result = $db->query('SELECT VERSION()') or error('Unable to fetch version info', __FILE__, __LINE__, $db->error());
        $db_version = $db->result($result);
        break;

REPLACE WITH

    default:
        $db_version = 'Fake';
        break;

13

Re: Admin pane issues

still, nothing sad

An error was encountered
File: /mnt/w0001/d13/s17/b0298d19/www/whatistheamazon.com/microsec/admin_index.php
Line: 117

PunBB reported: Unable to fetch table status

Database reported: Lost connection to MySQL server during query (Errno: 2013)

thanks for you help with this so far, Smartys!  big_smile

~Chad

Super Tech Audio Netcast
[img]http://img.vsig.org/chad.gif[/img]

Re: Admin pane issues

FIND

// Collect some additional info about MySQL
if ($db_type == 'mysql' || $db_type == 'mysqli')
{
    $db_version = 'MySQL '.$db_version;

    // Calculate total db size/row count
    $result = $db->query('SHOW TABLE STATUS FROM `'.$db_name.'`') or error('Unable to fetch table status', __FILE__, __LINE__, $db->error());

    $total_records = $total_size = 0;
    while ($status = $db->fetch_assoc($result))
    {
        $total_records += $status['Rows'];
        $total_size += $status['Data_length'] + $status['Index_length'];
    }

    $total_size = $total_size / 1024;

    if ($total_size > 1024)
        $total_size = round($total_size / 1024, 2).' MB';
    else
        $total_size = round($total_size, 2).' KB';
}

REPLACE WITH

// Collect some additional info about MySQL
if ($db_type == 'mysql' || $db_type == 'mysqli')
{
    $db_version = 'MySQL '.$db_version;
}

15

Re: Admin pane issues

Hi Smartys,

Thanks for your help!

That last fix didn't work, but it turns out that the project I'm working on this for is moving companies anyway.  I switched where the Administration link goes, so it is temporary now.  Thanks once again for the help you provided, I'm sure it will help other unlucky Netfirms customers.

~Chad

Super Tech Audio Netcast
[img]http://img.vsig.org/chad.gif[/img]

Re: Admin pane issues

Smartys wrote:

http://punbb.org/forums/viewtopic.php?id=11845
Netfirms should reallu upgrade their version of MySQL

According to their latest newsletter, they just have. It's about time.

Looking for a certain modification for your forum? Please take a look here before posting.