DBI::db=HASH(0x81f9b24) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81f9aa0)~0x81f9b24 'INSERT INTO advertisements VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9bf0) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x8160a04)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9b24)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 3. &imp_dbh->mysql: 81fb534 <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9bb4) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x815da24)~0x81f9bb4 'INSERT INTO affiliate VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9c44) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9b84)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9bb4)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 6. &imp_dbh->mysql: 81dd5b4 <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9c5c) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81f9a7c)~0x81f9c5c 'INSERT INTO affiliatedetail VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9cb0) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9b00)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9c5c)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 9. &imp_dbh->mysql: 81dd5b4 <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9c44) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81ef9c4)~0x81f9c44 'INSERT INTO affiliatepayment VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9b9c) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9b78)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9c44)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 12. &imp_dbh->mysql: 81dd5b4 <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9cb0) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81f9c80)~0x81f9cb0 'INSERT INTO affiliatereports VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9b24) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9af4)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9cb0)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 15. &imp_dbh->mysql: 81dd5b4 <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9b9c) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81f9ce0)~0x81f9b9c 'INSERT INTO affiliatestatus VALUES (?,?,?,?)') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9bb4) at hobby_update line 58 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9bb4)~0x81f9c44 1 '1' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9bb4)~0x81f9c44 2 'Affiliate has not been approved at this time.') <- bind_param= 1 at hobby_update line 74 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9bb4)~0x81f9c44 3 'Pending Approval') <- bind_param= 1 at hobby_update line 74 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9bb4)~0x81f9c44 4 '1' 4) <- bind_param= 1 at hobby_update line 71 -> execute for DBD::mysql::st (DBI::st=HASH(0x81f9bb4)~0x81f9c44 '1,Pending Approval,Affiliate has not been approved at this time.,1') !! ERROR: -1 'called with 1 bind variables when 4 are needed' <- execute= undef at hobby_update line 80 DBD::mysql::st execute failed: called with 1 bind variables when 4 are needed at hobby_update line 80, line 17. DBD::mysql::st execute failed: called with 1 bind variables when 4 are needed at hobby_update line 80, line 17. -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9c44)~INNER) <- DESTROY= undef -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9b9c)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect(), line 17. &imp_dbh->mysql: 81dd5b4 <- DESTROY= undef #### DBI::db=HASH(0x81f9b9c) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81f9b18)~0x81f9b9c 'INSERT INTO advertisements VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9c68) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x8160a04)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9b9c)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 3. &imp_dbh->mysql: 81fb434 <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9c2c) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x815da24)~0x81f9c2c 'INSERT INTO affiliate VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9cbc) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9bfc)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9c2c)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 6. &imp_dbh->mysql: 81efd6c <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9cd4) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81f9af4)~0x81f9cd4 'INSERT INTO affiliatedetail VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9d28) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9b78)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9cd4)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 9. &imp_dbh->mysql: 81efd6c <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9cbc) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81ef95c)~0x81f9cbc 'INSERT INTO affiliatepayment VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9c14) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9bf0)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9cbc)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 12. &imp_dbh->mysql: 81efd6c <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9d28) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81f9cf8)~0x81f9d28 'INSERT INTO affiliatereports VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9b9c) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9b6c)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9d28)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 15. &imp_dbh->mysql: 81efd6c <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9c14) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81f9d58)~0x81f9c14 'INSERT INTO affiliatestatus VALUES (?,?,?,?)') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9c2c) at hobby_update line 58 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9cbc 1 '1' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9cbc 2 'Affiliate has not been approved at this time.') <- bind_param= 1 at hobby_update line 74 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9cbc 3 'Pending Approval') <- bind_param= 1 at hobby_update line 74 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9cbc 4 '1' 4) <- bind_param= 1 at hobby_update line 71 -> execute for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9cbc '1' 'Pending Approval' 'Affiliate has not been approved at this time.' '1') -> dbd_st_execute for 081f9c80 Binding parameters: INSERT INTO affiliatestatus VALUES (1,'Pending Approval','Affiliate has not been approved at this time.',1) <- dbd_st_execute 1 rows <- execute= 1 at hobby_update line 79 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9cbc)~INNER) <- DESTROY= undef at hobby_update line 90 -> commit for DBD::mysql::db (DBI::db=HASH(0x81f9d58)~0x81f9c14) <- commit= 1 at hobby_update line 91 -> disconnect for DBD::mysql::db (DBI::db=HASH(0x81f9d58)~0x81f9c14) &imp_dbh->mysql: 81efd6c <- disconnect= 1 at hobby_update line 92 readline() on closed filehandle main::CSV2 at hobby_update line 47. -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9c14)~INNER) <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81f9b9c) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x81ef9c8)~0x81f9b9c 'INSERT INTO bannerlink VALUES ()') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81fc588) at hobby_update line 58 -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9cc8)~INNER) <- DESTROY= undef at hobby_update line 48 -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81f9b9c)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at hobby_update line 18, line 3. &imp_dbh->mysql: 81efd6c <- DESTROY= undef at hobby_update line 18 DBI::db=HASH(0x81fc54c) trace level set to 2 in DBI 1.21-nothread -> prepare for DBD::mysql::db (DBI::db=HASH(0x80fc834)~0x81fc54c 'INSERT INTO basket VALUES (?,?,?,?,?,?,?,?,?,?,?)') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x81f9c2c) at hobby_update line 58 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 1 'undef') <- bind_param= 1 at hobby_update line 74 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 2 '0' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 3 '1' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 4 '') <- bind_param= 1 at hobby_update line 74 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 5 '0' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 6 '2002-03-31 23:08:31-05' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 7 '0' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 8 '15' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 9 '10081' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 10 '1168280448' 4) <- bind_param= 1 at hobby_update line 71 -> bind_param for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 11 '160' 4) <- bind_param= 1 at hobby_update line 71 -> execute for DBD::mysql::st (DBI::st=HASH(0x81f9c2c)~0x81f9bf0 '160' '1168280448' '10081' '15' '0' '2002-03-31 23:08:31-05' '0' '' '1' '0' 'undef') -> dbd_st_execute for 081f9bfc Binding parameters: INSERT INTO basket VALUES ('160',1168280448,10081,'15',0,2002-03-31 23:08:31-05,0,,1,0,undef) You have an error in your SQL syntax near '23:08:31-05,0,,1,0,undef)' at line 1 error 1064 recorded: You have an error in your SQL syntax near '23:08:31-05,0,,1,0,undef)' at line 1 <- dbd_st_execute -2 rows !! ERROR: 1064 'You have an error in your SQL syntax near '23:08:31-05,0,,1,0,undef)' at line 1' <- execute= undef at hobby_update line 79 DBD::mysql::st execute failed: You have an error in your SQL syntax near '23:08:31-05,0,,1,0,undef)' at line 1 at hobby_update line 79, line 5. DBD::mysql::st execute failed: You have an error in your SQL syntax near '23:08:31-05,0,,1,0,undef)' at line 1 at hobby_update line 79, line 5. -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81f9bf0)~INNER) <- DESTROY= undef -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81fc54c)~INNER) Issuing rollback() for database handle being DESTROY'd without explicit disconnect(), line 5. &imp_dbh->mysql: 81fc324 <- DESTROY= undef