5 replies
Does anyone know how to tell via cpanel when a database was first set up?

I was hoping the set up date would be shown in mysql, but I can't see it.

I'm trying to install a wordpress plug-in which is using a mysql database. It's giving me an error when I try to set it up. I've deactivated and deleted the plug-in (via filezilla), then re-uploaded it, but it's remembering its settings and the error message tells me "You have an error in your SQL syntax........"

If I could tell which database the plug-in had set up I would try deleting it, but I can't see one with a name related to the plug-in and I don't want to delete one that's being used elsewhere
#database #problem #sql
  • Profile picture of the author rosetrees
    Thanks Glen - off to check that right now.

    I found some ancient, unused databases which I've deleted. The plug-in isn't setting up it's own db - I just installed it on a test domain - where, rather annoyingly, it' working fine!
    {{ DiscussionBoard.errors[2218147].message }}
  • Profile picture of the author Istvan Horvath
    If a plugin requires the creation of a separate database - that's very bad and yo shouldn't use it. It is a good setup for later catastrophes

    A plugin might create its own tables in the existing WP database: knowing what the usual WP tables are, you can recognize them easily.

    A very well written plugin will use the existing tables, eventually adding some new rows.

    The last two cases might explain why you didn't see new databases. The "SQL syntax" doesn't necessarily means you have an issue in the DB itself. More likely it is a problem in the code connecting to the DB and/or a php/mysql version incompatibility.
    Signature

    {{ DiscussionBoard.errors[2220404].message }}
  • Profile picture of the author zorus
    yeah
    i'm with Istvan Horvath, is very weird that plugin, the plugin should create the database without worry you about that, I will try to find a similiar plugin.
    {{ DiscussionBoard.errors[2220617].message }}

Trending Topics