‘Interference’ from other mysql db

  • I’m in the process of moving my blog from MT to WP and things have gone quite well so far (you can see my MT blog here and my WP blog here). But I’m using PHPQuotes in my menu, and that seems to interfere with the running of wp includes, like archives, categories or comments.
    I get this error message:
    <i>[Table ‘chocolat_quotes.wp_categories’ doesn’t exist]
    SELECT cat_ID, cat_name, category_nicename, category_description, category_parent FROM wp_categories WHERE cat_ID > 0 ORDER BY cat_ID asc</i>
    or varations of it, so obviously the functions call on the quotes database instead of the wp database.
    I really don’t know anything about php, so I’m quite lost trying to figure out how to fix this, other than stop using PHPQuotes. Any help would be greatly appreciated!

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

  • The easiest solution is to set them up using the same database.

    Thread Starter shirasade

    (@shirasade)

    Is there a way to copy the data from one database to another? Maybe using phpMyAdmin? I really don’t know anything about mysql…

    You certainly should be able to export tables and re-import them into the other db.
    However, you should be able to use multiple DBs, so long as all the WP code, and the third party code, make proper calls to the mysql interfaces passing the database handle to be accessed. If the handle isn’t provided, mysql calls default to the last-opened db (I think), thus the sql error you are seeing would lead me to believe you have uncovered something in WP (or a plugin) that isn’t doing db calls ‘correctly’.
    -d

    Thread Starter shirasade

    (@shirasade)

    It definitely looks as if it’s just calling on the last-opened db… Strange that no one noticed that before me! Being the amateur that I am, I guess I’ll have to do the db switch – it probably won’t be easy to fix the error otherwise.
    Thanks a lot for the help, though!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘‘Interference’ from other mysql db’ is closed to new replies.