Fork me on GitHub
Subscribe 1

Ticket #55 (fixed bug)

Number of Rows still shows all the rows in the database

  • Created: 2010-06-25 14:25:28
  • Reported by: Otomatic
  • Assigned to: Reines
  • Milestone: 1.4.1
  • Component: database
  • Priority: low

Hello,

Administration, Index, Database :
Number of Rows still shows all the rows in the database, even those that are not part of FluxBB.

Indeed, the query: (admin_index.php file, line 88)

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

accounts for all tables in the database.

To count only the tables related FluxBB, we must modify the query:

$result = $db->query("SHOW TABLE STATUS LIKE '".$db_prefix."%'") or error('Unable to fetch table status', __FILE__, __LINE__, $db->error());

History

Reines 2010-06-25 14:26:06

  • Status changed from open to fixed.

Thanks, fixed in 5840d8ec.