SQL database problem

by 5 replies
6
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
#programming #database #problem #sql
  • 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!
  • 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.
  • 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.
Join the discussion

Next Topics on Trending Feed