1 Topic by DesT

  • DesT
  • Junior Member
  • Offline
  • Registered: 2006-09-17
  • Posts: 3

Topic: Error of table in administration

Hello,


installation complete ok! but if i want to enter administration, i have an error :

An error was encountered
Error: Unable to fetch table status.


And i dont find this table in install.php


Thanks for your help

  • From: U.S.A.
  • Registered: 2005-08-26
  • Posts: 1,607

Re: Error of table in administration

Please enable debug mode and paste the full error. smile

Looking for a certain modification for your forum? Please take a look here before posting.
  • From: Ottawa, Canada
  • Registered: 2006-09-05
  • Posts: 308

Re: Error of table in administration

"Unable to fetch table status" is caused in admin_index.php and it happends when a mysql server doesn't return it's version information correctly. I suggest opening admin_index.php and remove these lines:

// 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';
}

PS I take no responsibility for what goes wrong, if something does ;p

echo "deadram"; echo; fortune;

4 Reply by DesT (edited by DesT 2006-09-17 19:29)

  • DesT
  • Junior Member
  • Offline
  • Registered: 2006-09-17
  • Posts: 3

Re: Error of table in administration

ok, i try it


with debug mode :

An error was encountered
File: /mnt/111/sdb/6/9/somare.ludovic/exile/forum/admin_index.php
Line: 120

PunBB reported: Unable to fetch table status

Database reported: Incorrect database name 'xxxxxxx.ludovic' (Errno: 1102)

* 'xxxxxxx.ludovic' i have change it because it's my first name. But it s ok in error

5 Reply by DesT

  • DesT
  • Junior Member
  • Offline
  • Registered: 2006-09-17
  • Posts: 3

Re: Error of table in administration

It's ok!

Thank you wink