Anyone have DBI or DBD::mysql change on 'em? All of a sudden (and it may have something to do w/ upgrading mysql, etc), my fetchall_arrayref doesn't work... instead of this:
$sth = $dbh->prepare( 'SELECT id,name FROM countries' );
$sth->execute();
# useful for: $template->param( 'countries' => $sth->fetchall_arrayref( {} ) );
$arrayref = $sth->fetchall_arrayref( {} );
Outputting this:
$VAR1 = {
'name' => 'US',
'id' => '1'
};
$VAR2 = {
'name' => 'CANADA',
'id' => '2'
};
It outputs this:
$VAR1 = {
'' => 'US',
'#B' => '1'
};
$VAR2 = {
'' => 'CANADA',
'#B' => '2'
};
ARG!!!!
Peace,
Jason
Update: Nevermind -- I hard-restarted the mysqld and apache and that seemed to fix the problem. Odd...