Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: perl DBI statement

by cbtshare (Monk)
on Dec 04, 2016 at 13:53 UTC ( [id://1177156]=note: print w/replies, xml ) Need Help??


in reply to perl DBI statement

I enabled tracing and got the following, so it does seem to be doing the correct thing, but it still wont insert it because of the duplicate key error
>count_params statement INSERT INTO FACEBOOK_281938224734 (id_code, en +try_time, parent_id_code, author_name, author_code, author_url, autho +r_image_url, entry_url, entry_types, status_code, entry_text, entry_d +ata, last_update, pull_time, queue_code) VALUES (?, ?, ?, ?, ?, ?, ?, + ?, ?, ?, ?, ?, ?, ?, ?) <- dbd_st_prepare <- prepare= ( DBI::st=HASH(0x2715148) ) [1 items] at rdscopy.pl li +ne 92 -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x2714c50)~0x27 +14fb0) -> dbd_st_fetch dbd_st_fetch for 270acc0, chopblanks 0 dbd_st_fetch result set details imp_sth->result=2796450 mysql_num_fields=15 mysql_num_rows=11 mysql_affected_rows=11 dbd_st_fetch for 270acc0, currow= 1 <- dbd_st_fetch, 15 cols <- fetchrow_array= ( '1638749309730588_179606465732333322385' '201 +6-11-18 23:08:41' undef 'Brdef+Meqtl' '1638749323230323239730588' 'ht +tps://www.facebook.com/1638749323309730323588' 'http://graph.facebook +.com/163874933230973323230588/picture' 'https://www.facebook.com/br32 +efmdsdtl/photos/a.1638973239786374207.1073741828.1638749309733230588/ +179606463232357332385/?type=3' 'REMOTE MENTION' 'MOD' 'Merci+%C3%A0+n +os+partenfdfaires+Vinfdfs+Phifdflippe+Dansasdurand%2C+Geordsdges+Dubo +eddfdeuf+Casasnada%2C+Oldass+Stydsle+Pildsdssner+et+Mol32son+Coors+Ca +nada+%21' '{"pictures":["https:\/\/scontent.xx.fbcdn.net\/v\/t1.0-9\/ +p720x720\/15036683_1796064323657332385_7424094774323638414550_n.jpg?o +h=dd7f1b67541992213b5a5741844a9bce&oe=58BB5ABA"],"is_hidden":false,"a +ttachments":{"data":[{"description":"Merci \u00e0 nos partenaires Vin +s Philippe Dandurand, Georges Duboeuf Canadsaada, dOssld Stdyldsde Pi +lsndsder et Moldsdsson Coors Canaeweda !","description_tags":[{"id":" +152972788101632","length":23,"name":"Vinasds Philsdsdsippe Danduran32 +323d","offset":24,"type":"page"},{"id":"2490763333338560306","length" +:22,"name":"Geewerges Duwewef Caneweeada","offset":49,"type":"page"}, +{"id":"281938224734","length":17,"name":"Old Style Pilsner","offset": +73,"type":"page"}],"media":{"image":{"height":720,"src":"https:\/\/sc +ontent.xx.fbcdn.net\/v\/t1.0-9\/p720x720\/15036683_17933233332385_742 +4094774638414550_n.jpg?oh=dd7f1b67541992213231844a9bce&oe=58BB5ABA"," +width":720}},"target":{"id":"1796064657332385","url":"https:\/\/www.f +acebook.com\/brefmtwqwl\/photos\/a.1638979ewe4207.1073ewe828.16387ew3 +09730588\/179606...' '2016-11-18 23:31:10' '2016-11-18 23:32:56' unde +f ) [15 items] row1 at rdscopy.pl line 100 -> execute for DBD::mysql::st (DBI::st=HASH(0x2715148)~0x270b6e0 ' +1638749sas30588_17960646sasa85' '2016-11-18 23:08:41' undef 'Brqqef+M +twwl' '163874930sas588' 'https://www.facebook.com/1638732323730588' ' +http://graph.facebook.com/16323a30588/picture' 'https://www.facebook. +com/bresasfmtl/photos/a.163897932374207.1073323828.1638749323588/1796 +0332357332385/?type=3' 'REMOTE MENTION' 'MOD' 'Merci+%C3%A0+nos+parte +nasasires+Visns+Phaassilippe+Dandsaurand%2C+Georsasages+Duboeasauf+Ca +naasada%2C+Olasad+Stydsdsle+Pilsnasaer+et+Molsosasan+Coor323s+Canada+ +%21' '{"pictures":["https:\/\/scontent.xx.fbcdn.net\/v\/t1.0-9\/p720x +720\/15033283_179606432332385_7424094774632350_n.jpg?oh=dd7f1b6754199 +2213b5a5741844a9bce&oe=58BB5ABA"],"is_hidden":false,"attachments":{"d +ata":[{"description":"Merci \u00e0 nos partenaires Vinsdss Philippsss +de Danduraasasnd, Geaaorgaases Dssaoeuf sssanada, Oasld Stasasyle Pil +snasaer et Molsdsdson Cosdsors Candsdsdada !","description_tags":[{"i +d":"1529727823232","length":23,"name":"Vsds Phdsdsppe Dandurand","off +set":24,"type":"page"},{"id":"249076338522306","length":22,"name":"Ge +sdsdes Dudsdsuf Canada","offset":49,"type":"page"},{"id":"2813333734" +,"length":17,"name":"Old Style Pilsner","offset":73,"type":"page"}]," +media":{"image":{"height":720,"src":"https:\/\/scontent.xx.fbcdn.net\ +/v\/t1.0-9\/p720x720\/1533683_17963332385_7424094333414550_n.jpg?oh=d +d7f1b6754133333b5a5741844a9bce&oe=58BB5ABA","width":720}},"target":{" +id":"179606465733335","url":"https:\/\/www.facebook.com\/brdsdstl\/ph +otos\/a.1638933374207.10333828.1339730588\/179606...' '2016-11-18 23: +31:10' '2016-11-18 23:32:56' undef) Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph Called: dbd_bind_ph -> dbd_st_execute for 2715190 >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets mysql_st_internal_execute MYSQL_VERSION_ID 50614 >parse_params statement INSERT INTO FACEBOOK_281933334734 (id_code, en +try_time, parent_id_code, author_name, author_code, author_url, autho +r_image_url, entry_url, entry_types, status_code, entry_text, entry_d +ata, last_update, pull_time, queue_code) VALUES (?, ?, ?, ?, ?, ?, ?, + ?, ?, ?, ?, ?, ?, ?, ?) Binding parameters: INSERT INTO FACEBOOK_281938224734 (id_code, entry_ +time, parent_id_code, author_name, author_code, author_url, author_im +age_url, entry_url, entry_types, status_code, entry_text, entry_data, + last_update, pull_time, queue_code) VALUES ('1638749333388_179606463 +33385', '2016-11-18 23:08:41', NULL, 'Bddssf+Mddl', '163874332322388' +, 'https://www.facebook.com/16387433333388', 'http://graph.facebook.c +om/16387423333730588/picture', 'https://www.facebook.com/bdsstl/photo +s/a.163893233207.1073741828.16387493232588/179623385/?type=3', 'REMOT +E MENTION', 'MOD', 'Merci+%C3%A0+nos+partenaires+Vins+Philippe+Dandsd +durand%2C+Georgdsdses+Duboesdsuf+Candsdsasdda%2C+Old+St3dsdyle+Pilsns +dser+et+Molson+Coors+Canada+%21', '{\"pictures\":[\"https:\\/\\/scont +ent.xx.fbcdn.net\\/v\\/t1.0-9\\/p720x720\\/150323683_17923385_7424032 +3550_n.jpg?oh=dd7f1b67541992213b5a5741844a9bce&oe=58BB5ABA\"],\"is_hi +dden\":false,\"attachments\":{\"data\":[{\"description\":\"Merci \\u0 +0e0 nos partenaires Vins Phfdpe Dandfurand, Georgfdfada, Odfd Pilr !\ +",\"description_tags\":[{\"id\":\"152972788101632\",\"length\":23,\"n +ame\":\"Vins Phfdpe Danfdnd\",\"offset\":24,\"type\":\"page\"},{\"id\ +":\"2490765450306\",\"length\":22,\"name\":\"Geofdes Dubff Canada\",\ +"offset\":49,\"type\":\"page\"},{\"id\":\"28193825434\",\"length\":17 +,\"name\":\"Old Style Pilsner\",\"offset\":73,\"type\":\"page\"}],\"m +edia\":{\"image\":{\"height\":720,\"src\":\"https:\\/\\/scontent.xx.f +bcdn.net\\/v\\/t1.0-9\\/p720x720\\/1503er83_1796064re43332385_7424094 +75454414550_n.jpg?oh=dd7f1b67541992213b534349bce&oe=58BreBA\",\"width +\":720}},\"target\":{\"id\":\"1796064rer332385\",\"url\":\"https:\\/\ +\/www.facebook.com\\/brefdfmtl\\/photos\\/a.16434786374207.104341828. +1638749309730588\\/1796064657332385\\/?type=3\"},\"title\":\"Timeline + Photos\",\"type\":\"photo\",\"url\":\"https:\\/\\/www.facebook.com\\ +/brefmtl\\/photos\\/a.1638974344207.107374434828.163874930343588\\/17 +960643432385\\/?type=3\"}]}}', '2016-11-18 23:31:10', '2016-11-18 23: +32:56', NULL) --> do_error Duplicate entry '1638749309730588_1796064657332385' for key 'PRIMARY' +error 1062 recorded: Duplicate entry '1638749309730588_17960646573323 +85' for key 'PRIMARY' <-- do_error IGNORING ERROR errno 1062 <- dbd_st_execute returning imp_sth->row_num 18446744073709551614 !! ERROR: 1062 'Duplicate entry '1638749309730588_1796064657332385 +' for key 'PRIMARY'' (err#0) <- execute= ( undef ) [1 items] at rdscopy.pl line 102 DBD::mysql::st execute failed: Duplicate entry '1638749309730588_17960 +64657332385' for key 'PRIMARY' at /home//rdscopy.pl line 102. DBD::mysql::st execute failed: Duplicate entry '1638749309730588_17960 +64657332385' for key 'PRIMARY' at /home/ardscopy.pl line 102. -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x2714fb0)~INNER)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1177156]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others goofing around in the Monastery: (3)
As of 2024-04-24 02:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found