Support » Plugin: WP Data Access » Error on activating WP Data Access

  • Resolved FGBmaster

    (@fgbmaster)


    Hey Peter,
    WordPress shows this message ERROR: Wrong arguments [schema name not found] when I try to activate the plugin on my localhost. No entry in my error log.
    Do you have any suggestion what to do?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter FGBmaster

    (@fgbmaster)

    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

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter FGBmaster

    (@fgbmaster)

    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

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    Thread Starter FGBmaster

    (@fgbmaster)

    Hi Peter,
    thanks for your effort.

    Best regards,
    Stefan

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Error on activating WP Data Access’ is closed to new replies.