ERROR schema name not found when activating WP Data Access

I’ve found out that the content of the schema_name field in information_schema.schemata is not the same as the name of the database in $wpdb->dbname.
As I can’t change information_schema of the DB, any other idea to fix that ?

Hey Peter,

Thank you for your answer.

I’ve been reading your php scripts and I think I’ve found out the “why” but now i’m searching for the “how” !
It seems you suppose that the schema_name field in information_schema.schemata should be the same than the dbname of the WP database (found in WPDA_Dictionary_Exist.php for instance).
Unfortunately in my Mysql DB the value of this field is “information_schema” (obtained via the following query “SELECT * FROM information_schema.schemata”) that is not the same as the DB name in the wp-config.php file.
The database is the WP database hosted at sql.free.fr.
I tried to modify the WPDA_Dictionary_Exist.php script (removing “WHERE schema_name = %s”) and it works but, of course, I’ve some other issues in other scripts using information_schema.
What can be the best and more evolutive way to solve this as I cannot change the information_schema data and cannot change the DB name. I don’t think that modifying all needed scripts is the good way…

Peter,

It’s local DB that contains the WP tables.
I’ve the error on …wp-admin/plugins.php when trying to activate WPDA.

Rgds,