Content-Type: text/html; charset=ISO-8859-1 DBI 1.622-ithread default trace level set to 0x0/15 (pid 8028 pi 5a7f78) at pl.pl line 16 -> DBI->connect(DBI:mysql:bcpadb:instance28854.db.xeround.com:18847, maxwell 175, ****, HASH(0x2284890)) -> DBI->install_driver(mysql) for MSWin32 perl=5.016001 pid=8028 ruid=0 euid =0 install_driver: DBD::mysql version 4.021 loaded from C:/strawberry/perl/v endor/lib/DBD/mysql.pm New 'DBI::dr' (for DBD::mysql::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x227acd0)=>DBI::dr=HASH(0x227aa30), DBD::mys ql::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::mysql::dr, 152, 0) thr#5a7f78 dbih_setup_attrib(DBI::dr=HASH(0x227aa30), Err, Null!) SCALAR(0x227a6d0) (al ready defined) dbih_setup_attrib(DBI::dr=HASH(0x227aa30), State, Null!) SCALAR(0x21a05f8) ( already defined) dbih_setup_attrib(DBI::dr=HASH(0x227aa30), Errstr, Null!) SCALAR(0x227a6a0) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x227aa30), TraceLevel, Null!) 0 (already def ined) dbih_setup_attrib(DBI::dr=HASH(0x227aa30), FetchHashKeyName, Null!) 'NAME' ( already defined) install_method DBI::db::mysql_fd install_method DBI::db::mysql_async_result install_method DBI::db::mysql_async_ready install_method DBI::st::mysql_async_result install_method DBI::st::mysql_async_ready <- install_driver= DBI::dr=HASH(0x227acd0) >> connect DISPATCH (DBI::dr=HASH(0x227acd0) rc2/3 @5 g2 ima8001 pid#802 8) at C:/strawberry/perl/vendor/lib/DBI.pm line 658 !! warn: 0 CLEARED by call to connect method -> connect for DBD::mysql::dr (DBI::dr=HASH(0x227acd0)~0x227aa30 'bcpadb:ins tance28854.db.xeround.com:18847' 'maxwell175' **** HASH(0x20cc350)) thr#5a7f78 New 'DBI::db' (for DBD::mysql::db, parent=DBI::dr=HASH(0x227aa30), id=HASH(0 x226b190)) dbih_setup_handle(DBI::db=HASH(0x226b2f8)=>DBI::db=HASH(0x226b100), DBD::mys ql::db, 21a0a00, HASH(0x226b190)) dbih_make_com(DBI::dr=HASH(0x227aa30), 253b418, DBD::mysql::db, 176, 226b250 ) thr#5a7f78 dbih_setup_attrib(DBI::db=HASH(0x226b100), Err, DBI::dr=HASH(0x227aa30)) SCA LAR(0x21a0d18) (already defined) dbih_setup_attrib(DBI::db=HASH(0x226b100), State, DBI::dr=HASH(0x227aa30)) S CALAR(0x21a0dd8) (already defined) dbih_setup_attrib(DBI::db=HASH(0x226b100), Errstr, DBI::dr=HASH(0x227aa30)) SCALAR(0x21a0d78) (already defined) dbih_setup_attrib(DBI::db=HASH(0x226b100), TraceLevel, DBI::dr=HASH(0x227aa3 0)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x226b100), FetchHashKeyName, DBI::dr=HASH(0x 227aa30)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x226b100), HandleSetErr, DBI::dr=HASH(0x227a a30)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x226b100), HandleError, DBI::dr=HASH(0x227aa 30)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x226b100), ReadOnly, DBI::dr=HASH(0x227aa30) ) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x226b100), Profile, DBI::dr=HASH(0x227aa30)) undef (not defined) imp_dbh->connect: dsn = bcpadb:instance28854.db.xeround.com:18847, uid = maxwell 175, pwd = qwertyuiop imp_dbh->my_login : dbname = bcpadb, uid = maxwell175, pwd = qwertyuiop,host = i nstance28854.db.xeround.com, port = 18847 imp_dbh->mysql_dr_connect: host = |instance28854.db.xeround.com|, port = 18847, uid = maxwell175, pwd = qwertyuiop imp_dbh->bind_type_guessing: 0 imp_dbh->use_server_side_prepare: 0 imp_dbh->mysql_dr_connect: client_flags = 2 imp_dbh->mysql_dr_connect: <- <- connect= ( DBI::db=HASH(0x226b2f8) ) [1 item s] at C:/strawberry/perl/vendor/lib/DBI.pm line 658 >> STORE DISPATCH (DBI::db=HASH(0x226b100) rc2/1 @3 g2 ima41c pid#8028 ) at C:/strawberry/perl/vendor/lib/DBI.pm line 710 -> STORE for DBD::mysql::db (DBI::db=HASH(0x226b100)~INNER 'RaiseError' 1) t hr#5a7f78 STORE DBI::db=HASH(0x226b100) 'RaiseError' => 1 <- STORE= ( 1 ) [1 items] at C:/strawberry/perl/vendor/lib/DBI.pm line 710 >> STORE DISPATCH (DBI::db=HASH(0x226b100) rc2/1 @3 g2 ima41c pid#8028 ) at C:/strawberry/perl/vendor/lib/DBI.pm line 710 -> STORE for DBD::mysql::db (DBI::db=HASH(0x226b100)~INNER 'PrintError' 1) t hr#5a7f78 STORE DBI::db=HASH(0x226b100) 'PrintError' => 1 <- STORE= ( 1 ) [1 items] at C:/strawberry/perl/vendor/lib/DBI.pm line 710 >> STORE DISPATCH (DBI::db=HASH(0x226b100) rc2/1 @3 g2 ima41c pid#8028 ) at C:/strawberry/perl/vendor/lib/DBI.pm line 710 -> STORE for DBD::mysql::db (DBI::db=HASH(0x226b100)~INNER 'AutoCommit' 1) t hr#5a7f78 <- STORE= ( 1 ) [1 items] at C:/strawberry/perl/vendor/lib/DBI.pm line 710 >> STORE DISPATCH (DBI::db=HASH(0x226b100) rc2/1 @3 g2 ima41c pid#8028 ) at C:/strawberry/perl/vendor/lib/DBI.pm line 713 via at C:\Users\Maxwell\Docu ments\pl.pl line 18 -> STORE for DBD::mysql::db (DBI::db=HASH(0x226b100)~INNER 'Username' 'maxwe ll175') thr#5a7f78 STORE DBI::db=HASH(0x226b100) 'Username' => 'maxwell175' <- STORE= ( 1 ) [1 items] at C:/strawberry/perl/vendor/lib/DBI.pm line 713 v ia at C:\Users\Maxwell\Documents\pl.pl line 18 >> connected DISPATCH (DBI::db=HASH(0x226b2f8) rc1/1 @5 g2 ima5 pid#8028) at C:/strawberry/perl/vendor/lib/DBI.pm line 720 -> connected in DBD::_::db for DBD::mysql::db (DBI::db=HASH(0x226b2f8)~0x226 b100 'DBI:mysql:bcpadb:instance28854.db.xeround.com:18847' 'maxwell175' **** HAS H(0x2284890)) thr#5a7f78 <- connected= ( undef ) [1 items] at C:/strawberry/perl/vendor/lib/DBI.pm li ne 720 <- connect= DBI::db=HASH(0x226b2f8) >> STORE DISPATCH (DBI::db=HASH(0x226b100) rc2/1 @3 g2 ima41c pid#8028 ) at C:/strawberry/perl/vendor/lib/DBI.pm line 729 via at C:\Users\Maxwell\Docu ments\pl.pl line 18 -> STORE for DBD::mysql::db (DBI::db=HASH(0x226b100)~INNER 'dbi_connect_clos ure' CODE(0x227a850)) thr#5a7f78 STORE DBI::db=HASH(0x226b100) 'dbi_connect_closure' => CODE(0x227a850) <- STORE= ( 1 ) [1 items] at C:/strawberry/perl/vendor/lib/DBI.pm line 729 v ia at C:\Users\Maxwell\Documents\pl.pl line 18 [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $LName in concatena tion (.) or string at C:\Users\Maxwell\Documents\pl.pl line 24. >> prepare DISPATCH (DBI::db=HASH(0x226b2f8) rc1/1 @2 g2 imaa201 pid#802 8) at C:\Users\Maxwell\Documents\pl.pl line 25 -> prepare for DBD::mysql::db (DBI::db=HASH(0x226b2f8)~0x226b100 'SELECT * F ROM people2 WHERE LName LIKE '' AND FName LIKE 'John'') thr#5a7f78 >> func DISPATCH (DBI::db=HASH(0x226b100) rc1/2 @2 g2 ima6 pid#8028) at C:/strawberry/perl/vendor/lib/DBD/mysql.pm line 227 via at C:\Users\Maxwell\ Documents\pl.pl line 25 1 -> _async_check for DBD::mysql::db (DBI::db=HASH(0x226b100)~INNER) thr#5a7f7 8 1 <- _async_check= ( 1 ) [1 items] at C:/strawberry/perl/vendor/lib/DBD/mysql. pm line 227 via at C:\Users\Maxwell\Documents\pl.pl line 25 New 'DBI::st' (for DBD::mysql::st, parent=DBI::db=HASH(0x226b100), id=undef) dbih_setup_handle(DBI::st=HASH(0x226b568)=>DBI::st=HASH(0x226b418), DBD::mys ql::st, 21a0e68, Null!) dbih_make_com(DBI::db=HASH(0x226b100), 25d26e8, DBD::mysql::st, 440, 0) thr# 5a7f78 dbih_setup_attrib(DBI::st=HASH(0x226b418), Err, DBI::db=HASH(0x226b100)) SCA LAR(0x21a0d18) (already defined) dbih_setup_attrib(DBI::st=HASH(0x226b418), State, DBI::db=HASH(0x226b100)) S CALAR(0x21a0dd8) (already defined) dbih_setup_attrib(DBI::st=HASH(0x226b418), Errstr, DBI::db=HASH(0x226b100)) SCALAR(0x21a0d78) (already defined) dbih_setup_attrib(DBI::st=HASH(0x226b418), TraceLevel, DBI::db=HASH(0x226b10 0)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x226b418), FetchHashKeyName, DBI::db=HASH(0x 226b100)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x226b418), HandleSetErr, DBI::db=HASH(0x226b 100)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x226b418), HandleError, DBI::db=HASH(0x226b1 00)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x226b418), ReadOnly, DBI::db=HASH(0x226b100) ) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x226b418), Profile, DBI::db=HASH(0x226b100)) undef (not defined) -> dbd_st_prepare MYSQL_VERSION_ID 50144, SQL statement: SELECT * FROM p eople2 WHERE LName LIKE '' AND FName LIKE 'John' >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets >count_params statement SELECT * FROM people2 WHERE LName LIKE '' AND FName LIKE 'John' <- dbd_st_prepare <- prepare= ( DBI::st=HASH(0x226b568) ) [1 items] at C:\Users\Maxwell\Docume nts\pl.pl line 25 >> execute DISPATCH (DBI::st=HASH(0x226b568) rc1/1 @1 g2 ima1041 pid#802 8) at C:\Users\Maxwell\Documents\pl.pl line 28 -> execute for DBD::mysql::st (DBI::st=HASH(0x226b568)~0x226b418) thr#5a7f78 -> dbd_st_execute for 021a0e98 >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets mysql_st_internal_execute MYSQL_VERSION_ID 50144 >parse_params statement SELECT * FROM people2 WHERE LName LIKE '' AND FName LIKE 'John' <- dbd_st_execute returning imp_sth->row_num 0 <- execute= ( '0E0' ) [1 items] at C:\Users\Maxwell\Documents\pl.pl line 28 >> fetchrow_hashref DISPATCH (DBI::st=HASH(0x226b568) rc1/1 @1 g2 ima0 pid#8 028) at C:\Users\Maxwell\Documents\pl.pl line 32 -> fetchrow_hashref for DBD::mysql::st (DBI::st=HASH(0x226b568)~0x226b418) t hr#5a7f78 >> mysql_async_ready DISPATCH (DBI::st=HASH(0x226b418) rc1/2 @1 g2 ima0 pid# 8028) at C:/strawberry/perl/vendor/lib/DBD/mysql.pm line 784 via at C:\Users\Ma xwell\Documents\pl.pl line 32 1 -> mysql_async_ready for DBD::mysql::st (DBI::st=HASH(0x226b418)~INNER) thr# 5a7f78 --> do_error Async support was not built into this version of DBD::mysql error 2000 recorded: Async support was not built into this version of DBD::mysql <-- do_error !! ERROR: 2000 'Async support was not built into this version of DBD::mysql' (err#0) 1 <- mysql_async_ready= ( undef ) [1 items] at C:/strawberry/perl/vendor/lib/D BD/mysql.pm line 784 via at C:\Users\Maxwell\Documents\pl.pl line 32 >> FETCH DISPATCH (DBI::st=HASH(0x226b418) rc2/2 @2 g2 ima404 pid#8028 ) at C:/strawberry/perl/vendor/lib/DBD/mysql.pm line 787 via at C:\Users\Maxwel l\Documents\pl.pl line 32 1 -> FETCH for DBD::mysql::st (DBI::st=HASH(0x226b418)~INNER 'NAME') thr#5a7f7 8 -> dbd_st_FETCH_attrib for 021a0e98, key NAME ERROR: 2000 'Async support was not built into this version of DBD::mysql' (err#0) 1 <- FETCH= ( [ 'FName' 'LName' 'AddrLine1' 'AddrLine2' 'City' 'Zip' 'WAddrLin e1' 'WAddrLine2' 'WCity' 'WZip' 'Company' 'Job_Title' 'HPhone' 'MPhone' 'WPhone' 'Email' ] ) [1 items] at C:/strawberry/perl/vendor/lib/DBD/mysql.pm line 787 vi a at C:\Users\Maxwell\Documents\pl.pl line 32 >> fetch DISPATCH (DBI::st=HASH(0x226b418) rc1/2 @1 g2 ima0 pid#8028) at C:/strawberry/perl/vendor/lib/DBD/mysql.pm line 787 via at C:\Users\Maxwell\ Documents\pl.pl line 32 !! ERROR: 2000 CLEARED by call to fetch method 1 -> fetch for DBD::mysql::st (DBI::st=HASH(0x226b418)~INNER) thr#5a7f78 -> dbd_st_fetch dbd_st_fetch for 022687c0, chopblanks 0 dbd_st_fetch result set details imp_sth->result=0051edc0 mysql_num_fields=16 mysql_num_rows=0 mysql_affected_rows=0 dbd_st_fetch for 022687c0, currow= 1 dbd_st_fetch, no more rows to fetch --> dbd_st_finish >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets <-- dbd_st_finish 1 <- fetch= ( undef ) [1 items] row-1 at C:/strawberry/perl/vendor/lib/DBD/mys ql.pm line 787 via at C:\Users\Maxwell\Documents\pl.pl line 32 <- fetchrow_hashref= ( undef ) [1 items] row-1 at C:\Users\Maxwell\Documents \pl.pl line 32 [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $LName in concatena tion (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $Email in concatena tion (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $AddrLine1 in conca tenation (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $AddrLine2 in conca tenation (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $City in concatenat ion (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $Zip in concatenati on (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $Company in concate nation (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $Job_Title in conca tenation (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $WAddrLine1 in conc atenation (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $WAddrLine2 in conc atenation (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $WCity in concatena tion (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $WZip in concatenat ion (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $HPhone in concaten ation (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $MPhone in concaten ation (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. [Thu Oct 25 13:55:21 2012] pl.pl: Use of uninitialized value $WPhone in concaten ation (.) or string at C:\Users\Maxwell\Documents\pl.pl line 53. BCPA page - MDTech
>> DESTROY DISPATCH (DBI::st=HASH(0x226b568) rc1/1 @1 g2 ima10004 pid#80 28) at C:\Users\Maxwell\Documents\pl.pl line 188 via at C:\Users\Maxwell\Docume nts\pl.pl line 188 <> DESTROY(DBI::st=HASH(0x226b568)) ignored for outer handle (inner DBI::st= HASH(0x226b418) has ref cnt 1) >> DESTROY DISPATCH (DBI::st=HASH(0x226b418) rc1/1 @1 g2 ima10004 pid#80 28) at C:\Users\Maxwell\Documents\pl.pl line 188 via at C:\Users\Maxwell\Docume nts\pl.pl line 188 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x226b418)~INNER) thr#5a7f78 <- DESTROY= ( undef ) [1 items] at C:\Users\Maxwell\Documents\pl.pl line 188 via at C:\Users\Maxwell\Documents\pl.pl line 188 DESTROY (dbih_clearcom) (sth 0x226b418, com 0x26071c8, imp DBD::mysql::st): FLAGS 0x180191: COMSET Warn RaiseError PrintError PrintWarn PARENT DBI::db=HASH(0x226b100) KIDS 0 (0 Active) NUM_OF_FIELDS 16 NUM_OF_PARAMS 0 dbih_clearcom 0x226b418 (com 0x26071c8, type 3) done. >> DESTROY DISPATCH (DBI::db=HASH(0x226b2f8) rc1/1 @1 g2 ima10004 pid#80 28) at C:\Users\Maxwell\Documents\pl.pl line 188 via at C:\Users\Maxwell\Docume nts\pl.pl line 188 <> DESTROY(DBI::db=HASH(0x226b2f8)) ignored for outer handle (inner DBI::db= HASH(0x226b100) has ref cnt 1) >> DESTROY DISPATCH (DBI::db=HASH(0x226b100) rc1/1 @1 g2 ima10004 pid#80 28) at C:\Users\Maxwell\Documents\pl.pl line 188 via at C:\Users\Maxwell\Docume nts\pl.pl line 188 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x226b100)~INNER) thr#5a7f78 imp_dbh->pmysql: 2604038 <- DESTROY= ( undef ) [1 items] at C:\Users\Maxwell\Documents\pl.pl line 188 via at C:\Users\Maxwell\Documents\pl.pl line 188 DESTROY (dbih_clearcom) (dbh 0x226b100, com 0x25d26e8, imp DBD::mysql::db): FLAGS 0x180391: COMSET Warn RaiseError PrintError PrintWarn AutoCommit PARENT DBI::dr=HASH(0x227aa30) KIDS 0 (0 Active) IMP_DATA HASH(0x226b190) dbih_clearcom 0x226b100 (com 0x25d26e8, type 2) done. -- DBI::END ($@: , $!: ) >> disconnect_all DISPATCH (DBI::dr=HASH(0x227acd0) rc1/3 @1 g2 ima801 pid#8 028) at C:/strawberry/perl/vendor/lib/DBI.pm line 737 via at C:\Users\Maxwell\D ocuments\pl.pl line 188 -> disconnect_all for DBD::mysql::dr (DBI::dr=HASH(0x227acd0)~0x227aa30) thr #5a7f78 <- disconnect_all= ( ) [0 items] (not implemented) at C:/strawberry/perl/ven dor/lib/DBI.pm line 737 via at C:\Users\Maxwell\Documents\pl.pl line 188 ! >> DESTROY DISPATCH (DBI::dr=HASH(0x227acd0) rc1/1 @1 g2 ima10004 pid#80 28) during global destruction ! <> DESTROY(DBI::dr=HASH(0x227acd0)) ignored for outer handle (inner DBI::dr= HASH(0x227aa30) has ref cnt 1) ! >> DESTROY DISPATCH (DBI::dr=HASH(0x227aa30) rc1/1 @1 g2 ima10004 pid#80 28) during global destruction ! -> DESTROY in DBD::_::common for DBD::mysql::dr (DBI::dr=HASH(0x227aa30)~INN ER) thr#5a7f78 ! <- DESTROY= ( undef ) [1 items] during global destruction DESTROY (dbih_clearcom) (drh 0x227aa30, com 0x253b418, imp global destructio n): FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit PARENT undef KIDS 0 (0 Active) dbih_clearcom 0x227aa30 (com 0x253b418, type 1) done. 'LName' is not recognized as an internal or external command, operable program or batch file.