search includes views, causes hang

[Scott M. Sanders]

Searching includes views (v_), which for me causes it to hang indefinitely.

I changed the do around line 53 to the following to exclude them; now it works for me:

    if(!stristr($tables_r['Tables_in_'.strtolower($database)], 'v_')) {
     $tables[] = $tables_r['Tables_in_'.strtolower($database)];
    }

Ideally the sql query would initially exclude them, but adding a NOT LIKE to it threw a MySQL error.

My server OS is CentOS 5.5, PHP 5.2.10, and MySQL 5.0.84.

[Scott M. Sanders (scottmsanders)]

Sorry, this is better:

if(substr($tables_r['Tables_in_'.strtolower($database)], 0, 1) != "v_") {
  $tables[] = $tables_r['Tables_in_'.strtolower($database)];
}

[Scott M. Sanders (scottmsanders)]

Rather "0, 2".

[Eric Amundson (sewmyheadon)]

Thanks for the reports, Scott. We'll take a look at it and let you know
if we have any questions.

On 1/26/11 7:20 AM, Scott M Sanders wrote:
> Rather "0, 2".
>