the plugin not work

Hmm… Does it related? https://sae.sina.com.cn/doc/php/mysql.html

Ok… As a quick fix try this:

1. Open file “/db/migrations/wp_testing/_BaseMigration.php” in plugin editor.

2. Find there these strings:

protected function get_wp_table_engine()
    {
        $engine = $this->field('
            SELECT ENGINE FROM information_schema.TABLES
            WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "' . WP_DB_PREFIX . 'posts"
        ');
        if (empty($engine)) {
            $engine = 'InnoDB';
        }
        return $engine;
    }

3. Replace them to:

protected function get_wp_table_engine()
    {
        return 'InnoDB';
        $engine = $this->field('
            SELECT ENGINE FROM information_schema.TABLES
            WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "' . WP_DB_PREFIX . 'posts"
        ');
        if (empty($engine)) {
            $engine = 'InnoDB';
        }
        return $engine;
    }

Will it repeat then?

Yes, It’s related with SAE. It’s working as your guid. Thank you very much!

saintbird, let’s not close it.

I want to fix it in more robust way. As on next update it will break you again.

Can you give me your login info or suggest some way to research it on your side? I dont’ have a MySQL cluster near at hand.

saintbird, I tried today to register at sina but failed. I’m already at weibo, but to register on sina I need China local phone. Russian is not good there.

Can you give me temp admin access to your WP install? I will try to research how to avoid “SELECT ENGINE FROM information_schema.TABLES” error on your host. I have some thoughts.

Or you can try these queries:

* SELECT ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "wp_posts" — should fail
* show create table wp_posts — may be will not fail?
* show table status like 'wp_posts' — may be will not fail?

Hi Alexander

Thanks for your great support!

My current SAE account is related to company, I can’t give this to you. But I can register a new account for you. Could you give me you email address? I will send the account info to you via email.

Yes. Tnx

[email protected]

My main need there is ability to query MySQL under same account rights as your wordpress works.

Email sent. Please check it.

Can’t save/edit anything there — it needs some security key. Or may be account non-verified.

I dont’ think my Russian local passport will be ok there )

Fixed in release 0.14.

I’m used more stable good old “show table status”.