my $table_results= $dbh2->prepare("SELECT * from $feed_table WHERE entry_time >= $time"); $table_results->execute(); #Prepare insert statement $sth_insert = $dbh3->prepare("INSERT IGNORE INTO $feed_table (id_code,entry_time,parent_id_code,author_name,author_code,author_url,author_image_url,entry_url,entry_types,status_code,entry_text,entry_data,last_update,pull_time,queue_code) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)") or die $dbh3->errstr; while (my @insert = $table_results->fetchrow_array()) { $sth_insert->execute(@insert) or die $dbh->errstr; #I get no errors } #### Warning: Using a password on the command line interface can be insecure. *************************** 1. row *************************** id_code: 10153812429735_10154227424399735 entry_time: 2016-10-24 21:13:32 parent_id_code: 28193we4734_10153815104343735 author_name: Chweweles+Lawevin author_code: 102057rw81019807 author_url: https://www.facebook.com/1020dfdfw81019807 author_image_url: http://graph.facebook.com/102fdf1019807/picture entry_url: https://business.facebook.com/2819gf4734/posts/101gfg815100339735?comment_id=101db8699735 entry_types: PHOTO COMMENT status_code: MOD entry_text: dfdppe+Lafdvin entry_data: {"is_hidden":false,"can_hide":true,"can_remove":true,"can_comment":true} last_update: 0000-00-00 00:00:00 pull_time: 2016-11-16 19:07:27 queue_code: NULL #### Use of uninitialized value $insert[14] in join or string at /home/anw/rds/rdscopy.pl line 99. 862010910596315 2016-10-28 23:32:50 78i4045071669_861799288022 Sally+Hill+Deehan 10154kjip13891 https://www.facebook.com/101o8ukuk9002413891 http://graph.facebook.com/10154o8jkjy413891/picture https://business.facebook.com/2819iukjk734/posts/86176kkjkj288022?comment_id=862010910596315 REMOTE MENTION COMMENT MOD Go+Cubs%21 {"is_hidden":false,"can_hide":false,"can_remove":false,"can_comment":false} 0000-00-00 00:00:00 2016-11-16 18:53:39 Use of uninitialized value $insert[14] in join or string at /home/aw/rds/rdscopy.pl line 99.