• Hi,

    Was trying to migrate my db today when I ran into a strange problem I’ve never had before. Some of the tables were missing after migration no matter how many times I ran it. Must be a bug in the application but I can’t figure out on my own, there is just too much code to dig through. I did find a clue in the debug log though, a bunch of lines like this:
    [30-Sep-2016 22:15:55 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_term_relationships.* FROM h9uLc_term_relationships WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:15:55 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_term_taxonomy.* FROM h9uLc_term_taxonomy WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:15:56 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_terms.* FROM h9uLc_terms WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:15:56 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_usermeta.* FROM h9uLc_usermeta WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:15:57 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_users.* FROM h9uLc_users WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:24:24 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_posts.* FROM h9uLc_posts WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:24:24 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_term_relationships.* FROM h9uLc_term_relationships WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:24:25 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_term_taxonomy.* FROM h9uLc_term_taxonomy WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:24:26 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_terms.* FROM h9uLc_terms WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:24:26 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_usermeta.* FROM h9uLc_usermeta WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table
    [30-Sep-2016 22:24:27 UTC] WordPress database error Unknown column ‘meta_id’ in ‘where clause’ for query SELECT h9uLc_users.* FROM h9uLc_users WHERE 1=1 AND ( ( meta_id > ‘24238’ ) ) ORDER BY meta_id LIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_table

    Any help would be appreciated. Thanks!

    Mike

The topic ‘Strange where clause being generated’ is closed to new replies.