WordPress.org

1. Anonymous
   Unregistered
   Posted 7 years 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?

2. midori
   Member
   Posted 7 years 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 ?

3. Anonymous
   Unregistered
   Posted 7 years 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.

4. Anonymous
   Unregistered
   Posted 7 years ago #

   anybody? please help >_<

5. Mark (podz)
   Support Maven
   Posted 7 years ago #

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

6. Anonymous
   Unregistered
   Posted 7 years 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.

7. Anonymous
   Unregistered
   Posted 7 years ago #

   so there isn't any solution?

8. Mark (podz)
   Support Maven
   Posted 7 years 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.

9. Anonymous
   Unregistered
   Posted 7 years 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?

10. midori
    Member
    Posted 7 years 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...

Topic Closed

This topic has been closed to new replies.