id_code: 862012249 entry_time: 2016-10-28 23:36:08 parent_id_code: 783924049_861760507288022 author_name: Lia+nik+son author_code: 1294333813357 author_url: https://www.facebook.com/120357 author_image_url: http://graph.facebook.com/17/picture entry_url: https://business.facebook.com/28262849 entry_types: COMMENT status_code: MOD entry_text: +so%2C++it%27s+the+home+team%21 entry_data: false,"can_comment":false} last_update: 0000-00-00 00:00:00 pull_time: 2016-11-16 18:53:40 queue_code: NULL #### id_code: 281938224734_10154342971729735 item_name: pull_run_id item_value: 1480804468 item_data: NULL #### DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/rdscopy.pl line 199. DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/rdscopy.pl line 199 #### #get Id_Codes based on entry time my $feed_table_ext_idcode = $dbh2->prepare("SELECT id_code FROM $feed_table WHERE entry_time >= ?"); $feed_table_ext_idcode->execute($time); my $feed_table_ext_results = $dbh2->prepare("SELECT * from $feed_table_ext WHERE id_code = ?"); while (my @row = $feed_table_ext_idcode->fetchrow_array()) { #print "@row\n"; $feed_table_ext_results->execute(@row); } #### Returned after querying facebook_321_ext table in production and need to copy them to staging ************************** 24. row *************************** id_code: 281938224734_10154342971729735 item_name: PRE_MOD_Krttime item_value: 1480804542 item_data: NULL *************************** 25. row *************************** id_code: 281gfg154342971729735 item_name: PRE_MOD_SetQueue item_value: UNKNOWN item_data: NULL *************************** 26. row *************************** id_code: 281938224734_101gf29735 item_name: PRE_MOD_SetQueue_time item_value: 1480804587 item_data: NULL *************************** 27. row *************************** id_code: 281938224734_10154342971729735 item_name: PRE_MOD_Textalfggtect item_value: POSITIVE item_data: NULL *************************** 28. row *************************** id_code: 281938224734_10154342971729735 item_name: PRE_MOD_TgfentDetect_time item_value: 1480804573 item_data: NULL *************************** 29. row *************************** id_code: 281938224734_10154342971729735 item_name: pull_run_id item_value: 1480804468 item_data: NULL *************************** 30. row *************************** id_code: 281938224734_10154342971729735 item_name: pugfme item_value: 1480804471 item_data: NULL #### my $ext_insert = $dbh3->prepare("INSERT IGNORE INTO $feed_table_ext (id_code, item_name, item_value, item_data) VALUES (?, ?, ?, ?)") or die $dbh3->errstr; while (my @insert_ext = $feed_table_ext_results->fetchrow_array()) { $ext_insert->execute(@insert_ext) or die $sth_insert->errstr; }