Structure, Optimize and Repair

Darrell3831 · Worker Joined: Feb 18, 2004 Posts: 244

Nuke Sentinel 2.1.2

The three features called Database Structure, Database Optimize and Database Repair do not work at all if you have certain characters in your database name.

It's either the underscore _ or it's the hypen -.

I didn't bother to test which character because I have both in my database name.

In the Ensim control panel your database name is choosen automatically based on your domain name, plus the suffix you choose. (ie. nuke)

So you'll end up with quite a database name in some instances.

your-domain_org_-_nuke

That database name will not work using the standard queries built into nuke sentinel.

Using what Raven tought me a couple months ago while working with a different script I was able to fix Sentinel as well.

Here's what I did with ABDBOptimize.php

Line 47 is:

Code:

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

This query fails because of the special characters.

I changed it to this:

Code:

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

Now the option to optimize a database with speical characters in it will work instead of failing.

Structure, and Repair also do not work currently. I have not made the edits to these files yet, but I'm sure they will work after the database name is enclosed in back ticks.

Darrell