• Registered: 2004-05-26
  • Posts: 10

Topic: Error: Unable to delete from online list.

I succesfully installed the forum then i got this error msg when i tried to get into forum index page. I tried many boards but this one looks good to me please help.

  • Registered: 2004-05-26
  • Posts: 10

Re: Error: Unable to delete from online list.

Okey i solved that problem. For other who s gonna have this problem im writing the answer.

Anyhow the installation didnt create the tables for online. I created them manually from MysQL. You need to add these :

case 'mysql':
$sql = 'CREATE TABLE '.$db_prefix."online (
                    user_id INT(10) UNSIGNED NOT NULL DEFAULT '0',
                    ident VARCHAR(200) NOT NULL DEFAULT '',
                    logged INT(10) UNSIGNED NOT NULL DEFAULT '0'

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Error: Unable to delete from online list.

Very odd. It just didn't create the online table? In that case, it's probably a bug in MySQL. At least I can't see anything wrong with this code:

switch ($db_type)
{
    case 'mysql':
        $sql = 'CREATE TABLE '.$db_prefix."online (
                user_id INT(10) UNSIGNED NOT NULL DEFAULT '0',
                ident VARCHAR(200) NOT NULL DEFAULT '',
                logged INT(10) UNSIGNED NOT NULL DEFAULT '0'
                ) TYPE=HEAP;";
        break;

    case 'pgsql':
        $sql = 'CREATE TABLE '.$db_prefix."online (
                user_id INT NOT NULL DEFAULT '0',
                ident VARCHAR(200) NOT NULL DEFAULT '',
                logged INT NOT NULL DEFAULT '0'
                )";
        break;
}

$db->query($sql) or exit('Unable to create table '.$db_prefix.'online. Please check your settings and try again. <a href="JavaScript: history.go(-1)">Go back</a>.');
"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

4 Reply by Joe Dirt

  • Joe Dirt
  • Guest

Re: Error: Unable to delete from online list.

i dont know where im gonna to place it pleas write back in email pleas i need help..

  • From: Canada, Qc
  • Registered: 2004-11-02
  • Posts: 4

Re: Error: Unable to delete from online list.

Hello,

I got the same error (Error: Unable to delete from online list.) after the installation.  I fix the problem by adding somes permissions to the MySQL user.