Strange where clause being generated
-
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 SELECTh9uLc_term_relationships.* FROMh9uLc_term_relationshipsWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_term_taxonomy.* FROMh9uLc_term_taxonomyWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_terms.* FROMh9uLc_termsWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_usermeta.* FROMh9uLc_usermetaWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_users.* FROMh9uLc_usersWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_posts.* FROMh9uLc_postsWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_term_relationships.* FROMh9uLc_term_relationshipsWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_term_taxonomy.* FROMh9uLc_term_taxonomyWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_terms.* FROMh9uLc_termsWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_usermeta.* FROMh9uLc_usermetaWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 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 SELECTh9uLc_users.* FROMh9uLc_usersWHERE 1=1 AND ( (meta_id> ‘24238’ ) ) ORDER BYmeta_idLIMIT 100 made by do_action(‘wp_ajax_wpmdb_migrate_table’), call_user_func_array, WPMDB->ajax_migrate_table, WPMDB->export_tableAny help would be appreciated. Thanks!
Mike
The topic ‘Strange where clause being generated’ is closed to new replies.