WP Tables Query picking wrong db

  • I keep getting the error that my table in MYSQL query does not exist. For some reason, it keeps picking up my WordPress database and not my new custom MYSQL database. I made sure I highlighted it when I picked the QUERY tab and wrote my query. It works if I use the TABLE tab, but when I choose the QUERY tab since I need to pick certain recs for the table, it shows my custom DB in the drop down, but when it runs, it seems to default all the time to the WordPress database. No way to stop this? Else I have to go back to WPDATATABLES. Thanks!

Viewing 1 replies (of 1 total)
  • Plugin Author Ian Sadovy

    (@iansadovy)

    Hello @al9000nj,
    Thank you for the question.
    Please check that in the query you specify full table names, i.e. mycustomdb.mytable. Otherwise, query will be performed on the default db, which is wp db.
    Let me know if it helps.

    Regards,
    Ian

Viewing 1 replies (of 1 total)
  • The topic ‘WP Tables Query picking wrong db’ is closed to new replies.