For Consideration in Future Updates

Worker Joined: Feb 18, 2004 Posts: 244

Hi,

In NukeSentinel 2.2.0 there are a couple database querries that don't work for all possible database names.

ABDBOptimize.php Line 44 is:

Code:

$result = $db->sql_query("SHOW TABLE STATUS FROM ".$dbname);

At your discretion this might be improved by:

Code:

$result = $db->sql_query('SHOW TABLE STATUS FROM `'.$dbname.'`');

The same is true of ABDBStructure.php Line 44 and ABDBRepair.php line 43.

Thanks for a great script!

Sincerely,
Darrell

registered · Posted: Wed Apr 27, 2005 9:20 pm

Darrell,

I've been finding that several places in many of the NSN/Nuke scripts the ` needs to be used. Over the next days/weeks I plan on going thru each script and update the queries to have these. I beleieve, as you have pointed out, that it will cure many issues that are run into. Long story short, you can count on this in the pl5 release Smile

Posted: Thu Apr 28, 2005 6:37 am

That's Great!

Thanks. Smile