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.
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
