class Pman_Core_UpdateDatabase_MysqlEngineCharset {
var $dburl;
- var $schema;
- var $links;
+ var $schema = array();
+ var $links = array();
function __construct()
{
$ff->generateDataobjectsCache(true);
$this->dburl = parse_url($ff->database);
+ print_R($ff->PDO_DataObject);exit;
+
$dbini = 'ini_'. basename($this->dburl['path']);
$iniCache = $ff->DB_DataObject[$dbini];
+ if (!file_exists($iniCache)) {
+ return;
+ }
$this->schema = parse_ini_file($iniCache, true);
$this->links = parse_ini_file(preg_replace('/\.ini$/', '.links.ini', $iniCache), true);
T.table_name = '{$tbl}' -- COLLATE utf8_general_ci
");
- $ce->fetch();
+ if (!$ce->fetch()) {
+ continue;
+ }
if($ce->csname == 'utf8' && $ce->collatename == 'utf8_general_ci'){
echo "utf8: SKIP $tbl\n";
$db = DB_DataObject::factory('core_enum')->getDatabaseConnection();
- $views = $db->getListOf( 'views');
+ $views = $db->getListOf( 'views'); // needs updated pear...
$ce = DB_DataObject::factory('core_enum');
- $ce->query("select engine from information_schema.tables where table_schema='{$ce->database()}' and table_name = '{$tbl}'");
+ $ce->query("
+ select
+ engine
+ from
+ information_schema.tables
+ where
+ table_schema='{$ce->database()}'
+ and
+ table_name = '{$tbl}'
+ ");
- $ce->fetch();
+ if (!$ce->fetch()) {
+ continue;
+ }
if($ce->engine == 'InnoDB' ){
echo "InnoDB: SKIP $tbl\n";