Error on activating WP Data Access

Hi,

Which database are you using? Can you perform the following SQL statement:
SELECT * FROM information_schema.schemata
What result do you get?

Best regards,
Peter

Hi Peter,
I am using sqlite. The result of the statement is
no such table: information_schema.schemata: SELECT * FROM information_schema.schemata

Regards
Stefan

Hi Stefan,

Then I guess sqlite is handling the information_schema differently. Are you using some kind of virtual machine that I can download to test? Maybe I can fix this issue…

Best regards,
Peter

Hi Peter,
I have nothing to send to you and I’m not familiar with information_schema, but https://en.wikipedia.org/wiki/Information_schema says: sqlite doesn’t provide information_schema.
I assume, the plugin wants to check weather a table is present and has the needed columns or something like that? These Informations can be read by pragma-statements, see https://www.sqlite.org/pragma.html.
Hope you can help anyway. My production-site has no access to mysql, maria-db or similar database ?? And I would likely have a look on your plugin. It seems to be exactly what I need.

Regards
Stefan

Hi Stefan,

So far I’ve tested the plugin with MySQL and MariaDB. I’m not familiar with sqlite, but I will have a look at it. I’ll do some research and let you know the results are.

Best regards,
Peter

Hi Stefan

Just an advice.

I think it’s better to move to mysql / mariadb. Sqlite is simple rdbms but it doesn’t support process concurrency which what apache and php usually use. Unless you use fpm maybe it will be safer, but I’m not sure about the thread safety of sqlite itself.

In short it might corrupt your db when use by multiple user/connection.

Hi Stefan,

I did some research on sqlite…

MySQL and MariaDB store their dictionary information in information_schema. The plugin heavily relies on this schema to generate the necessary pages. Unfortunately sqlite does not use such a schema. So you will not be able to use the plugin with sqlite. Sorry!

I saw that sqlite uses sqlite_master to store dictionary information. It might be possible to create the (MySQL) views the plugin needs and give them the same name. But I don’t have the time to test this.

I’m closing this topic. Sorry Stefan! Maybe you can update to MySQL…?

Best regards,
Peter

Hi Peter,
thanks for your effort.

Best regards,
Stefan