ERROR: Invalid table name or not authorized after moving site

  • Resolved andyrayner

    (@andyrayner)


    3 years, 1 month ago

    `Hello, First of all thanks for a great plugin.

    I’ve copied a live site to a testing domain as a backup, but I can’t seem to get WP Data Access to work correctly.
    I copied the files and the database to the new server, then went through and edited all the usual stuff in the database & config. WordPress is working fine.

    I’ve been through the wpdt tables as well and amended the references the old database, including “target_schema_name” to match the new details, but I think I must be missing something as I get the above error wherever a shortcode appears.

    Also in the WPDT admin panel on the data designer page there are no select boxes beside the tables in the list, and on the publications page the select boxes are replaced with a little info tab saying “SCHEMA, TABLE OR COLUMN NAME VALIDATION NOT POSSIBLE (CLICK TO READ MORE AND FIX)” I read the page but I’m no wiser as to what the problem might be. The database name doesn’t seem to have any problem characters in so I’m kind of unsure where to look next.

    Any help appreciated.
    Andrew.

Viewing 1 replies (of 1 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Andrew,

    Thanks for reaching out!

    When you install WordPress on two different servers (production and test), both servers have their own database. When you export/import publications, projects and/or templates from one server to another, WP Data Access changes the database names of publications, projects and templates that use tables and/or views in the WordPress database. This is automatically done for you when you export on the source server and import on the destination server. Not if you just copy records. The simplest way to solve this issue, it to delete the publications, projects and templates on your test server, export them on your production server and then import them again on your test server. That will solve the issue.

    You can also use the Data Explorer and the Query Builder to update tables manually. Here are the repository tables where publications, projects and templates are stored:
    wp_wpda_publisher > pub_schema_name
    wp_wpda_project_page > page_schema_name
    wp_wpda_project_table > wpda_schema_name
    The column name behind the table contains the database name. When you query the tables, you’ll see the database name of your production server which you just need to replace with the database name of your test server.

    Hope this helps! Let me know if you need further assistance,
    Peter

Viewing 1 replies (of 1 total)
  • The topic ‘ERROR: Invalid table name or not authorized after moving site’ is closed to new replies.