DBD::mysql mysql_server_prepare=1 caching of statement handles

Wouter de Geus <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]> 
Hej folks,

I've run into a weird problem with one of our websites. Long story short, our
database class somehow didn't return any results for (SELECT) queries that
have results if you run them on the commandline.

Since we wrote our own wrappers around DBI / DBD::mysql that was obviously the
first place we looked. Our library has mysql_server_prepare=1 and caches the
last bunch of statements. All selects are run through prepare.
So summarized, a query is run through our library like
  res = $db->select($query, $arg1, $arg);
And then our library does $sth = $dbh->prepare($query), $sth->execute(@args)
and returns $sth->fetchall_arrayref({}).
Meanwhile the last 5 $sth handled are cached and if the same query is run
again it will be reused if possible.

This caching of $sth seems to be the problem, if I disable it and simply prepare
the query again it works.
Also this has worked for us for years, (although we often use DBD::Pg) however,
it seems in this particular case the $sth simply returns no results. I've
set DBI->trace(2) and attached the output of that to this email.

Can anyone of you shine some light on what's going wrong? And why using a 'dead'
$sth doesn't throw any errors?
I would have expected DBI->err() to return something or some other indication of
failure, but I can't find any errors whatsoever.

If I set mysql_server_prepare=0 everything works as expected.
I've also tried using $sth->finish() on (all) the cached handles before reusing 
them, but that seems to have no effect.

Is the conclusion that I can not cache $sth like this?

Thanks for reading :-)

Regards,

Wouter.
dbtrace.log (text/plain, 24.2 KB) 
    DBI::db=HASH(0xa2eac78) trace level set to 0x0/2 (DBI @ 0x0/0) in DBI 1.631-ithread (pid 3082)
    -> prepare for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78 'SELECT *, DATE_FORMAT(datum, '%d %M %Y') AS besteldatum FROM VIE_bestelling WHERE bestelling_id = ? LIMIT 1') thr#9b38008
	-> dbd_st_prepare MYSQL_VERSION_ID 50527, SQL statement: SELECT *, DATE_FORMAT(datum, '%d %M %Y') AS besteldatum FROM VIE_bestelling WHERE bestelling_id = ? LIMIT 1
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
		use_server_side_prepare set, check LIMIT
		need to test for LIMIT
		use_server_side_prepare set
		mysql_stmt_prepare returned 0
		mysql_to_perl_type returned 3
	<- dbd_st_prepare
    <- prepare= ( DBI::st=HASH(0xa3e4048) ) [1 items] at DB.pm line 150
    -> execute for DBD::mysql::st (DBI::st=HASH(0xa3e4048)~0xa3d1238 '116') thr#9b38008
   Called: dbd_bind_ph
   SCALAR type STRING 0, buffertype=254
 SCALAR type 0 ->length 3<- IS A STRING or BLOB
   FORCE REBIND: buffer type changed from 3 to 254, sql-type=0
 -> dbd_st_execute for 0a3e3ca8
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
	-> mysql_st_internal_execute41
		mysql_st_internal_execute41 calling mysql_execute with 1 num_params
		mysql_stmt_execute returned 0
	<- mysql_internal_execute_41 returning 1 rows
 <- dbd_st_execute returning imp_sth->row_num 1
    <- execute= ( 1 ) [1 items] at DB.pm line 166
    -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78) thr#9b38008
    <- err= ( undef ) [1 items] at DB.pm line 168
    -> fetchall_arrayref for DBD::mysql::st (DBI::st=HASH(0xa3e4048)~0xa3d1238 HASH(0xa3e3ed8)) thr#9b38008
    -> dbd_st_FETCH_attrib for 09fbe280, key NAME
    -> dbd_st_FETCH_attrib for 09fb4ef0, key NUM_OF_FIELDS
	-> dbd_st_fetch
	--> dbd_describe
		dbd_describe() num_fields 10
		i 0 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 1 col_type 10 fbh->length 0
		fields[i].length 10 fields[i].max_length 10 fields[i].type 10 fields[i].charsetnr 63
		mysql_to_perl_type returned 10
		i 2 col_type 253 fbh->length 0
		fields[i].length 100 fields[i].max_length 9 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 3 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 4 col_type 246 fbh->length 0
		fields[i].length 29 fields[i].max_length 6 fields[i].type 246 fields[i].charsetnr 63
		mysql_to_perl_type returned 246
		i 5 col_type 246 fbh->length 0
		fields[i].length 29 fields[i].max_length 4 fields[i].type 246 fields[i].charsetnr 63
		mysql_to_perl_type returned 246
		i 6 col_type 246 fbh->length 0
		fields[i].length 29 fields[i].max_length 5 fields[i].type 246 fields[i].charsetnr 63
		mysql_to_perl_type returned 246
		i 7 col_type 246 fbh->length 0
		fields[i].length 29 fields[i].max_length 5 fields[i].type 246 fields[i].charsetnr 63
		mysql_to_perl_type returned 246
		i 8 col_type 246 fbh->length 0
		fields[i].length 29 fields[i].max_length 6 fields[i].type 246 fields[i].charsetnr 63
		mysql_to_perl_type returned 246
		i 9 col_type 253 fbh->length 0
		fields[i].length 72 fields[i].max_length 12 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
	<- dbd_describe
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch called mysql_fetch, rc 0 num_fields 10
		st_fetch int data 116, unsigned? 0
		ERROR IN st_fetch_string		ERROR IN st_fetch_string		st_fetch int data 3, unsigned? 0
		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string	<- dbd_st_fetch, 10 cols
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch no data

--> dbd_st_finish
	--> dbd_describe
		dbd_describe() num_fields 10
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets

<-- dbd_st_finish
    <- fetchall_arrayref= ( [ HASH(0xa3ef288) ] ) [1 items] row1 at DB.pm line 174
    -> do for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78 'UPDATE bestelling SET bestelling_status_id = ? WHERE bestelling_id = ?' HASH(0xa3ef088) '4' '116') thr#9b38008
mysql.xs do() use_server_side_prepare 1, async 0
	-> mysql_st_internal_execute41
		mysql_st_internal_execute41 calling mysql_execute with 2 num_params
		mysql_stmt_execute returned 0
	<- mysql_internal_execute_41 returning 1 rows
    <- do= ( 1 ) [1 items] at DB.pm line 181
    -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78) thr#9b38008
    <- err= ( undef ) [1 items] at DB.pm line 187
    -> prepare for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78 'SELECT DISTINCT gebruiker_id, bestelling_gebruiker_id FROM bestelling_gebruiker INNER JOIN bestelling_gebruiker_product USING(bestelling_gebruiker_id)
	                    WHERE backorder > 0 AND bestelling_id = ?') thr#9b38008
	-> dbd_st_prepare MYSQL_VERSION_ID 50527, SQL statement: SELECT DISTINCT gebruiker_id, bestelling_gebruiker_id FROM bestelling_gebruiker INNER JOIN bestelling_gebruiker_product USING(bestelling_gebruiker_id)
	                    WHERE backorder > 0 AND bestelling_id = ?
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
		use_server_side_prepare set, check LIMIT
		need to test for LIMIT
		use_server_side_prepare set
		mysql_stmt_prepare returned 0
		mysql_to_perl_type returned 3
	<- dbd_st_prepare
    <- prepare= ( DBI::st=HASH(0xa3ef088) ) [1 items] at DB.pm line 150
    -> execute for DBD::mysql::st (DBI::st=HASH(0xa3ef088)~0xa3e3f68 '116') thr#9b38008
   Called: dbd_bind_ph
   SCALAR type STRING 0, buffertype=254
 SCALAR type 0 ->length 3<- IS A STRING or BLOB
   FORCE REBIND: buffer type changed from 3 to 254, sql-type=0
 -> dbd_st_execute for 0aaaeef8
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
	-> mysql_st_internal_execute41
		mysql_st_internal_execute41 calling mysql_execute with 1 num_params
		mysql_stmt_execute returned 0
	<- mysql_internal_execute_41 returning 3 rows
 <- dbd_st_execute returning imp_sth->row_num 3
    <- execute= ( 3 ) [1 items] at DB.pm line 166
    -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78) thr#9b38008
    <- err= ( undef ) [1 items] at DB.pm line 168
    -> fetchall_arrayref for DBD::mysql::st (DBI::st=HASH(0xa3ef088)~0xa3e3f68 HASH(0xa3ef428)) thr#9b38008
    -> dbd_st_FETCH_attrib for 09fbe280, key NAME
    -> dbd_st_FETCH_attrib for 09fb4ef0, key NUM_OF_FIELDS
	-> dbd_st_fetch
	--> dbd_describe
		dbd_describe() num_fields 2
		i 0 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 0 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 1 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 0 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
	<- dbd_describe
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch called mysql_fetch, rc 0 num_fields 2
		st_fetch int data 1, unsigned? 0
		st_fetch int data 583, unsigned? 0
	<- dbd_st_fetch, 2 cols
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch called mysql_fetch, rc 0 num_fields 2
		st_fetch int data 4, unsigned? 0
		st_fetch int data 584, unsigned? 0
	<- dbd_st_fetch, 2 cols
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch called mysql_fetch, rc 0 num_fields 2
		st_fetch int data 2, unsigned? 0
		st_fetch int data 586, unsigned? 0
	<- dbd_st_fetch, 2 cols
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch no data

--> dbd_st_finish
	--> dbd_describe
		dbd_describe() num_fields 2
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets

<-- dbd_st_finish
    -> prepare for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78 'SELECT vbgp.*, gp.permission_id FROM VIE_bestelling_gebruiker_product AS vbgp
	                                      INNER JOIN bestelling_gebruiker AS bg USING ( bestelling_gebruiker_id )
	                                      INNER JOIN gebruiker USING ( gebruiker_id )
	                                      LEFT OUTER JOIN gebruiker_permission AS gp ON gp.gebruiker_id = bg.gebruiker_id AND permission_id = 2
						                  WHERE backorder > 0 AND bestelling_gebruiker_id = ? ORDER BY naam') thr#9b38008
	-> dbd_st_prepare MYSQL_VERSION_ID 50527, SQL statement: SELECT vbgp.*, gp.permission_id FROM VIE_bestelling_gebruiker_product AS vbgp
	                                      INNER JOIN bestelling_gebruiker AS bg USING ( bestelling_gebruiker_id )
	                                      INNER JOIN gebruiker USING ( gebruiker_id )
	                                      LEFT OUTER JOIN gebruiker_permission AS gp ON gp.gebruiker_id = bg.gebruiker_id AND permission_id = 2
						                  WHERE backorder > 0 AND bestelling_gebruiker_id = ? ORDER BY naam
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
		use_server_side_prepare set, check LIMIT
		need to test for LIMIT
		use_server_side_prepare set
		mysql_stmt_prepare returned 0
		mysql_to_perl_type returned 252
	<- dbd_st_prepare
    <- prepare= ( DBI::st=HASH(0xa3ef6d8) ) [1 items] at DB.pm line 150
    -> execute for DBD::mysql::st (DBI::st=HASH(0xa3ef6d8)~0xa3ef718 583) thr#9b38008
   Called: dbd_bind_ph
   SCALAR type STRING 0, buffertype=254
 SCALAR type 0 ->length 3<- IS A STRING or BLOB
   FORCE REBIND: buffer type changed from 252 to 254, sql-type=0
 -> dbd_st_execute for 0aaaecd8
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
	-> mysql_st_internal_execute41
		mysql_st_internal_execute41 calling mysql_execute with 1 num_params
		mysql_stmt_execute returned 0
	<- mysql_internal_execute_41 returning 1 rows
 <- dbd_st_execute returning imp_sth->row_num 1
    <- execute= ( 1 ) [1 items] at DB.pm line 166
    -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78) thr#9b38008
    <- err= ( undef ) [1 items] at DB.pm line 168
    -> fetchall_arrayref for DBD::mysql::st (DBI::st=HASH(0xa3ef6d8)~0xa3ef718 HASH(0xa3ef4f8)) thr#9b38008
    -> dbd_st_FETCH_attrib for 09fbe280, key NAME
    -> dbd_st_FETCH_attrib for 09fb4ef0, key NUM_OF_FIELDS
	-> dbd_st_fetch
	--> dbd_describe
		dbd_describe() num_fields 16
		i 0 col_type 252 fbh->length 0
		fields[i].length 65535 fields[i].max_length 23 fields[i].type 252 fields[i].charsetnr 8
		mysql_to_perl_type returned 252
		i 1 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 2 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 3 col_type 253 fbh->length 0
		fields[i].length 7 fields[i].max_length 6 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 4 col_type 246 fbh->length 0
		fields[i].length 7 fields[i].max_length 4 fields[i].type 246 fields[i].charsetnr 63
		mysql_to_perl_type returned 246
		i 5 col_type 254 fbh->length 0
		fields[i].length 1 fields[i].max_length 1 fields[i].type 254 fields[i].charsetnr 8
		mysql_to_perl_type returned 254
		i 6 col_type 254 fbh->length 0
		fields[i].length 4 fields[i].max_length 2 fields[i].type 254 fields[i].charsetnr 8
		mysql_to_perl_type returned 254
		i 7 col_type 246 fbh->length 0
		fields[i].length 8 fields[i].max_length 6 fields[i].type 246 fields[i].charsetnr 63
		mysql_to_perl_type returned 246
		i 8 col_type 253 fbh->length 0
		fields[i].length 200 fields[i].max_length 5 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 9 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 10 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 11 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 12 col_type 246 fbh->length 0
		fields[i].length 8 fields[i].max_length 5 fields[i].type 246 fields[i].charsetnr 63
		mysql_to_perl_type returned 246
		i 13 col_type 246 fbh->length 0
		fields[i].length 7 fields[i].max_length 4 fields[i].type 246 fields[i].charsetnr 63
		mysql_to_perl_type returned 246
		i 14 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 15 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
	<- dbd_describe
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch called mysql_fetch, rc 0 num_fields 16
		ERROR IN st_fetch_string		st_fetch int data 15, unsigned? 0
		st_fetch int data 1, unsigned? 0
		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		st_fetch int data 583, unsigned? 0
		st_fetch int data 1830, unsigned? 0
		st_fetch int data 1, unsigned? 0
		ERROR IN st_fetch_string		ERROR IN st_fetch_string		st_fetch int data 1, unsigned? 0
		st_fetch int data 2, unsigned? 0
	<- dbd_st_fetch, 16 cols
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch no data

--> dbd_st_finish
	--> dbd_describe
		dbd_describe() num_fields 16
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets

<-- dbd_st_finish
    <- fetchall_arrayref= ( [ HASH(0xa3efde8) ] ) [1 items] row1 at DB.pm line 174
    -> prepare for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78 'SELECT * FROM gebruiker WHERE gebruiker_id = ? LIMIT 1') thr#9b38008
	-> dbd_st_prepare MYSQL_VERSION_ID 50527, SQL statement: SELECT * FROM gebruiker WHERE gebruiker_id = ? LIMIT 1
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
		use_server_side_prepare set, check LIMIT
		need to test for LIMIT
		use_server_side_prepare set
		mysql_stmt_prepare returned 0
		mysql_to_perl_type returned 3
	<- dbd_st_prepare
    <- prepare= ( DBI::st=HASH(0xa3eff48) ) [1 items] at DB.pm line 150
    -> execute for DBD::mysql::st (DBI::st=HASH(0xa3eff48)~0xaab8420 1) thr#9b38008
   Called: dbd_bind_ph
   SCALAR type STRING 0, buffertype=254
 SCALAR type 0 ->length 1<- IS A STRING or BLOB
   FORCE REBIND: buffer type changed from 3 to 254, sql-type=0
 -> dbd_st_execute for 0a3efa58
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
	-> mysql_st_internal_execute41
		mysql_st_internal_execute41 calling mysql_execute with 1 num_params
		mysql_stmt_execute returned 0
	<- mysql_internal_execute_41 returning 1 rows
 <- dbd_st_execute returning imp_sth->row_num 1
    <- execute= ( 1 ) [1 items] at DB.pm line 166
    -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78) thr#9b38008
    <- err= ( undef ) [1 items] at DB.pm line 168
    -> fetchall_arrayref for DBD::mysql::st (DBI::st=HASH(0xa3eff48)~0xaab8420 HASH(0xaaaebe8)) thr#9b38008
    -> dbd_st_FETCH_attrib for 09fbe280, key NAME
    -> dbd_st_FETCH_attrib for 09fb4ef0, key NUM_OF_FIELDS
	-> dbd_st_fetch
	--> dbd_describe
		dbd_describe() num_fields 13
		i 0 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 1 col_type 253 fbh->length 0
		fields[i].length 100 fields[i].max_length 17 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 2 col_type 253 fbh->length 0
		fields[i].length 100 fields[i].max_length 10 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 3 col_type 253 fbh->length 0
		fields[i].length 100 fields[i].max_length 4 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 4 col_type 253 fbh->length 0
		fields[i].length 50 fields[i].max_length 32 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 5 col_type 7 fbh->length 0
		fields[i].length 19 fields[i].max_length 30 fields[i].type 7 fields[i].charsetnr 63
		mysql_to_perl_type returned 7
		i 6 col_type 253 fbh->length 0
		fields[i].length 100 fields[i].max_length 8 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 7 col_type 253 fbh->length 0
		fields[i].length 10 fields[i].max_length 2 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 8 col_type 253 fbh->length 0
		fields[i].length 7 fields[i].max_length 7 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 9 col_type 253 fbh->length 0
		fields[i].length 100 fields[i].max_length 5 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
		i 10 col_type 3 fbh->length 0
		fields[i].length 11 fields[i].max_length 11 fields[i].type 3 fields[i].charsetnr 63
		mysql_to_perl_type returned 3
		i 11 col_type 1 fbh->length 0
		fields[i].length 1 fields[i].max_length 4 fields[i].type 1 fields[i].charsetnr 63
		mysql_to_perl_type returned 1
		i 12 col_type 253 fbh->length 0
		fields[i].length 20 fields[i].max_length 0 fields[i].type 253 fields[i].charsetnr 8
		mysql_to_perl_type returned 253
	<- dbd_describe
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch called mysql_fetch, rc 0 num_fields 13
		st_fetch int data 1, unsigned? 0
		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		ERROR IN st_fetch_string		st_fetch int data 53200, unsigned? 0
		st_fetch int data 0, unsigned? 0
		ERROR IN st_fetch_string	<- dbd_st_fetch, 13 cols
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch no data

--> dbd_st_finish
	--> dbd_describe
		dbd_describe() num_fields 13
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets

<-- dbd_st_finish
    <- fetchall_arrayref= ( [ HASH(0xaab83a0) ] ) [1 items] row1 at DB.pm line 174
    -> execute for DBD::mysql::st (DBI::st=HASH(0xa3ef6d8)~0xa3ef718 584) thr#9b38008
   Called: dbd_bind_ph
   SCALAR type STRING 0, buffertype=254
 SCALAR type 0 ->length 3<- IS A STRING or BLOB
 -> dbd_st_execute for 0aaaecd8
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
	-> mysql_st_internal_execute41
		mysql_st_internal_execute41 calling mysql_execute with 1 num_params
		mysql_stmt_execute returned 0
	<- mysql_internal_execute_41 returning 2 rows
 <- dbd_st_execute returning imp_sth->row_num 2
    <- execute= ( 2 ) [1 items] at DB.pm line 166
    -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78) thr#9b38008
    <- err= ( undef ) [1 items] at DB.pm line 168
    -> fetchall_arrayref for DBD::mysql::st (DBI::st=HASH(0xa3ef6d8)~0xa3ef718 HASH(0xa3eff08)) thr#9b38008
    -> dbd_st_FETCH_attrib for 09fbe280, key NAME
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch data truncated

--> dbd_st_finish
	--> dbd_describe
		dbd_describe() num_fields 16
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets

<-- dbd_st_finish
    <- fetchall_arrayref= ( [ ] ) [1 items] at DB.pm line 174
    -> execute for DBD::mysql::st (DBI::st=HASH(0xa3eff48)~0xaab8420 4) thr#9b38008
   Called: dbd_bind_ph
   SCALAR type STRING 0, buffertype=254
 SCALAR type 0 ->length 1<- IS A STRING or BLOB
 -> dbd_st_execute for 0a3efa58
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
	-> mysql_st_internal_execute41
		mysql_st_internal_execute41 calling mysql_execute with 1 num_params
		mysql_stmt_execute returned 0
	<- mysql_internal_execute_41 returning 1 rows
 <- dbd_st_execute returning imp_sth->row_num 1
    <- execute= ( 1 ) [1 items] at DB.pm line 166
    -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78) thr#9b38008
    <- err= ( undef ) [1 items] at DB.pm line 168
    -> fetchall_arrayref for DBD::mysql::st (DBI::st=HASH(0xa3eff48)~0xaab8420 HASH(0xaaaebf8)) thr#9b38008
    -> dbd_st_FETCH_attrib for 09fbe280, key NAME
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch data truncated

--> dbd_st_finish
	--> dbd_describe
		dbd_describe() num_fields 13
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets

<-- dbd_st_finish
    <- fetchall_arrayref= ( [ ] ) [1 items] at DB.pm line 174
    -> execute for DBD::mysql::st (DBI::st=HASH(0xa3ef6d8)~0xa3ef718 586) thr#9b38008
   Called: dbd_bind_ph
   SCALAR type STRING 0, buffertype=254
 SCALAR type 0 ->length 3<- IS A STRING or BLOB
 -> dbd_st_execute for 0aaaecd8
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
	-> mysql_st_internal_execute41
		mysql_st_internal_execute41 calling mysql_execute with 1 num_params
		mysql_stmt_execute returned 0
	<- mysql_internal_execute_41 returning 1 rows
 <- dbd_st_execute returning imp_sth->row_num 1
    <- execute= ( 1 ) [1 items] at DB.pm line 166
    -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78) thr#9b38008
    <- err= ( undef ) [1 items] at DB.pm line 168
    -> fetchall_arrayref for DBD::mysql::st (DBI::st=HASH(0xa3ef6d8)~0xa3ef718 HASH(0xaab81d0)) thr#9b38008
    -> dbd_st_FETCH_attrib for 09fbe280, key NAME
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch data truncated

--> dbd_st_finish
	--> dbd_describe
		dbd_describe() num_fields 16
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets

<-- dbd_st_finish
    <- fetchall_arrayref= ( [ ] ) [1 items] at DB.pm line 174
    -> execute for DBD::mysql::st (DBI::st=HASH(0xa3eff48)~0xaab8420 2) thr#9b38008
   Called: dbd_bind_ph
   SCALAR type STRING 0, buffertype=254
 SCALAR type 0 ->length 1<- IS A STRING or BLOB
 -> dbd_st_execute for 0a3efa58
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets
	-> mysql_st_internal_execute41
		mysql_st_internal_execute41 calling mysql_execute with 1 num_params
		mysql_stmt_execute returned 0
	<- mysql_internal_execute_41 returning 1 rows
 <- dbd_st_execute returning imp_sth->row_num 1
    <- execute= ( 1 ) [1 items] at DB.pm line 166
    -> err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0xa2eab58)~0xa2eac78) thr#9b38008
    <- err= ( undef ) [1 items] at DB.pm line 168
    -> fetchall_arrayref for DBD::mysql::st (DBI::st=HASH(0xa3eff48)~0xaab8420 HASH(0xac52fd0)) thr#9b38008
    -> dbd_st_FETCH_attrib for 09fbe280, key NAME
	-> dbd_st_fetch
		dbd_st_fetch for 09fbe280, chopblanks 0
		dbd_st_fetch calling mysql_fetch
		dbd_st_fetch data truncated

--> dbd_st_finish
	--> dbd_describe
		dbd_describe() num_fields 13
	>- dbd_st_free_result_sets
	<- dbd_st_free_result_sets RC -1
	<- dbd_st_free_result_sets

<-- dbd_st_finish
    <- fetchall_arrayref= ( [ ] ) [1 items] at DB.pm line 174
!   -> DESTROY for DBD::mysql::st (DBI::st=HASH(0xa3ef718)~INNER) thr#9b38008
	Freeing 1 parameters, bind a405ff8 fbind a3ed058
!   <- DESTROY= ( undef ) [1 items] during global destruction
!   -> DESTROY for DBD::mysql::st (DBI::st=HASH(0xaab8420)~INNER) thr#9b38008
	Freeing 1 parameters, bind aabd9a0 fbind a345c80
!   <- DESTROY= ( undef ) [1 items] during global destruction
!   -> DESTROY for DBD::mysql::st (DBI::st=HASH(0xa3e3f68)~INNER) thr#9b38008
	Freeing 1 parameters, bind a346610 fbind a3e6b88
!   <- DESTROY= ( undef ) [1 items] during global destruction
!   -> DESTROY for DBD::mysql::st (DBI::st=HASH(0xa3d1238)~INNER) thr#9b38008
	Freeing 1 parameters, bind a3ea550 fbind a345940
!   <- DESTROY= ( undef ) [1 items] during global destruction
!   -> DESTROY for DBD::mysql::db (DBI::db=HASH(0xa2eac78)~INNER) thr#9b38008
imp_dbh->pmysql: a3122f8
!   <- DESTROY= ( undef ) [1 items] during global destruction
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.