URGENT URGENT Error Config File

[THDAdmin]

I installed a Mod called Optimize Database with easymod and then it required me to manually run the sql query, i ran it and it went successful, then i go to my Forum and on every page i click an Error Repot comes up



Heres my [optimize_database_cron.php]:

Code: Select all

/***************************************************************************
 *                            optimize_database_cron.php
 *                            -------------------
 *   begin                : Tuesday , Sep 23, 2003
 *   copyright            : (C) 2003 Sko22
 *   email                : [email protected]
 *
 *   $Id: optimize_database_cron.php,v 1.0.2 2003/10/06 09:27:30
 *
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

//
// Optimize database config
//
$sql = "SELECT * FROM " .  phpbb_optimize_db . " ";

$opt_result = $db->sql_query($sql);

if( !( $opt_row = $db->sql_fetchrow($opt_result) ) )
{
   message_die(GENERAL_ERROR, 'Could not obtain optimize database config', '', __LINE__, __FILE__, $sql);
}

if ( ( $opt_row['cron_enable'] == '1' ) && ( $opt_row['cron_lock'] == '1' ) )

{
   
   //
   // Lock cron for contemporary accesses
   //
   $sql = "UPDATE " . OPTIMIZE_DB_TABLE . " SET cron_lock = '0' ";

   if( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not lock optimize database cron', '', __LINE__, __FILE__, $sql);
   }

   $current_time = time();
   
   //
   // Check cron next
   //
   if ( $opt_row['cron_next'] <= $current_time )
   {
   ignore_user_abort();

   //
   // Get tables list
   //
   $list = mysql_list_tables($dbname);

   //
   // Optimize tables
   //
   while ( $tab = $db->sql_fetchrow($list) ) {
      
      foreach ($tab as $column_value) {
         $sql = "OPTIMIZE TABLE $column_value";
         if ( !$result = $db->sql_query($sql) )
            {
            message_die(GENERAL_ERROR, "Couldn't optimize database", "", __LINE__, __FILE__, $sql);
            }
        }
   
   }

   $sql = "UPDATE " . OPTIMIZE_DB_TABLE . " SET cron_next = " . ( $current_time + $opt_row['cron_every'] ) . ", cron_count = cron_count+1 ";

   if( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not update next optimize time', '', __LINE__, __FILE__, $sql);
   }
   }

}

else

{

//
// Unlock cron for contemporary accesses
//
$sql = "UPDATE " . OPTIMIZE_DB_TABLE . " SET cron_lock = '1' ";
if( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not unlock optimize database cron', '', __LINE__, __FILE__, $sql);
}

}

?>

Please Please Please Help

[WhiteWolfSix]

Please, check whether your table prefix is phpbb or not. If not, then do this:

Find:

Code: Select all

$sql = "SELECT * FROM " .  phpbb_optimize_db . " ";

Replace:

Code: Select all

$sql = "SELECT * FROM " .  {yourprefix}_optimize_db . " ";

{yourprefix} = replace with your real table prefix

[THDAdmin]

I always whenever installing a PhpBB always leave the prefix as default, just to make sure though i tried others but it didnt work. Any more suggestions.