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.