Using the example from the readme, I get the following error: DBD::CSV::st execute failed: Can't locate object method "command" via package "DBD::CSV::Statement" at /usr/lib/perl5/vendor_perl/5.8.8/DBD/CSV.pm line 156. [for Statement "SELECT * FROM a"] at b.pl line 16. DBD::CSV::st fetchrow_array failed: Attempt to fetch row from a Non-SELECT statement [for Statement "SELECT * FROM a"] at b.pl line 18. To reproduce, run this: use DBI; $dbh = DBI->connect("DBI:CSV:f_dir=$HOME/csvdb") or die "Cannot connect: " . $DBI::errstr; $sth = $dbh->prepare("CREATE TABLE a (id INTEGER, name CHAR(10))") or die "Cannot prepare: " . $dbh->errstr(); $sth->execute() or die "Cannot execute: " . $sth->errstr(); $sth->finish(); then this: use DBI; $dbh = DBI->connect(qq{DBI:CSV:csv_sep_char=\\;}); $sth = $dbh->prepare("SELECT * FROM a"); $sth->execute(); while (my @row = $sth->fetchrow_array) { print "@row\n"; }
I'm unable to reproduce this in FC-5 using a /tmp location. By the way what's the value of $HOME ? (shouldn't it be $ENV{$HOME}?) Could you also append the output of "rpm -q perl-DBI perl-DBD-CSV perl-SQL-Statement perl-Text-CSV_XS"?
perl-SQL-Statement isn't installed. Maybe the dependencies are wrong?
I was able to duplicate the problem when I uninstalled the SQL::Statement perl module. Adding perl(SQL::Statement) to the requirements list.
perl-DBD-CSV-0.22-5 has just been built for FC-4, FC-5, and devel. This release now explicitly requires perl(SQL::Statement). It will also take one or two days for it to appear in the mirrors (a push has just been missed). Pleases re-open this ticket if the problem persists. jpo
Will do - thanks!
FYI: The *unsigned* RPMS/SRPMS are available from this page http://buildsys.fedoraproject.org/build-status/success.psp (just follow the "JOB ID" links).