Problem with database connection

  • Anonymous

    21 years, 7 months ago

    I’ve installed 2 wp’s in the same database. I use to have the first wp’s tables at this database which was called “frozenro_main” and now I’ve moved all the tables to a new database called “frozenro_blog” and I altered the info in the wp-config.php file too, but now I’m getting this error at my blog page, the post shows up fine but above it is this error message:
    Database error: [Table ‘frozenro_main.wpsuomi_users’ doesn’t exist]
    SELECT * FROM wpsuomi_users WHERE user_login = ‘admin’
    It seems like the wp is trying to read from the previous database for some reason and the database (frozenro_main) exists but the tables aren’t there anymore! What can I do to make this error stop?

Viewing 9 replies - 1 through 9 (of 9 total)
  • midori

    (@midori)

    21 years, 7 months ago

    Very strange. The only place where your DB name is given is the config. Are you sure you made no mistake in the config ?

    Thread Starter Anonymous

    21 years, 7 months ago

    I am positive, I’ve checked it many times and the config file is ok, I tried to delete the whole thing and install it again but the same error. I can’t delete frozenro_main cause there are so many tables there (over 200) it would be too much work.

    Thread Starter Anonymous

    21 years, 7 months ago

    anybody? please help >_<

    Mark (podz)

    (@podz)

    21 years, 7 months ago

    “frozenro_main.wpsuomi_users”
    Can you see that table in the database ?
    Can you see a table called frozenro_main.wpsuomi_options ?

    Thread Starter Anonymous

    21 years, 7 months ago

    no there is no such table or any wp tables at “frozenro_main” database anymore :/ I’ve moved ALL the tables to “frozenro_blog” database. I can’t understand why it tries to read from the previous database >_< I’ve checked the tables in frozenro_blog and they’re all ok to my knowledge.

    Thread Starter Anonymous

    21 years, 7 months ago

    so there isn’t any solution?

    Mark (podz)

    (@podz)

    21 years, 7 months ago

    I think what has happened is that naming has got confused.
    You should have a db name, and a ‘table_prefix’
    The table_prefix that wp uses is set by the file wp-config.php. Open that and see what it is.

    Thread Starter Anonymous

    21 years, 7 months ago

    I’ve checked that too.. my table_prefix is wpsuomi_ and db name is frozenro_blog and that info is also in the wp-config.php file. But where does that db “frozenro_main” come up from?? there are no wp_tables in that database!! Is there some other file where might be the db name given?

    midori

    (@midori)

    21 years, 7 months ago

    I tried to find that, and it seems there are no other than the wp-config. You could use an editor with a global search possibility, and try on your own files…

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Problem with database connection’ is closed to new replies.