> Well it looks like I fixed the problem by doing a repair on the table
> in question - however, I still get a whole heap of "Use of
> uninitialized value in pattern match (M//) at /usr/local/irstats/var/
> www/irstats/lib/IRStats/Update/Handler/MyHandler.pm line x, <STDIN>
> line xxx. Are these errors something to be concerned about? I think
> they probably aren't, but if anyone knows how to clear them up I'm all
> ears.
> Thanks,
> Guy
> On 4 Nov, 13:21, Guy <guy.knig...@gmail.com> wrote:
> > I'm experiencing errors when trying to import data from an eprints 2
> > log. I tried another logfile (same server, different year) and am
> > getting the same error. There error output is below:
> > Use of uninitialized value in pattern match (m//) at /usr/local/
> > irstats/var/www/irstats/lib/IRStats/Update/Handler/MyHandler.pm line
> > 48, <STDIN> line 9.
> > Use of uninitialized value in pattern match (m//) at /usr/local/
> > irstats/var/www/irstats/lib/IRStats/Update/Handler/MyHandler.pm line
> > 48, <STDIN> line 9.
> > Use of uninitialized value in pattern match (m//) at /usr/local/
> > irstats/var/www/irstats/lib/IRStats/Update/Handler/MyHandler.pm line
> > 48, <STDIN> line 9.
> > DBD::mysql::st execute failed: Table './quteprints/
> > irstats_column_requester_host' is marked as crashed and should be
> > repaired at /usr/local/irstats/var/www/irstats/lib/IRStats/
> > DatabaseInterface.pm line 625.
> > Use of uninitialized value in concatenation (.) or string at /usr/
> > local/irstats/var/www/irstats/lib/IRStats/DatabaseInterface.pm line
> > 625.
> > Execution of -- SELECT `id` FROM `irstats_column_requester_host` WHERE
> > `value` = ? LIMIT 1 ('159.226.47.109') -- failed:
> > at /usr/local/irstats/var/www/irstats/lib/IRStats/
> > DatabaseInterface.pm line 625
> > IRStats::DatabaseInterface::execute('IRStats::DatabaseInterface::mysql=HASH (0xa15189c)',
> > 'DBI::st=HASH(0xa642a98)', 159.226.47.109) called at /usr/local/
> > irstats/var/www/irstats/lib/IRStats/DatabaseInterface.pm line 581
> > IRStats::DatabaseInterface::do_sql('IRStats::DatabaseInterface::mysql=HASH( 0xa15189c)',
> > 'SELECT `id` FROM `irstats_column_requester_host` WHERE `value...',
> > 159.226.47.109) called at /usr/local/irstats/var/www/irstats/lib/
> > IRStats/DatabaseInterface.pm line 520
> > IRStats::DatabaseInterface::column_table_id('IRStats::DatabaseInterface::my sql=HASH(0xa15189c)',
> > 'irstats_column_requester_host', 159.226.47.109) called at /usr/local/
> > irstats/var/www/irstats/lib/IRStats/DatabaseInterface.pm line 479
> > IRStats::DatabaseInterface::insert_main_table_row('IRStats::DatabaseInterfa ce::mysql=HASH(0xa15189c)',
> > 'HASH(0xa64457c)') called at /usr/local/irstats/var/www/irstats/lib/
> > IRStats/Update/Handler/MyHandler.pm line 81
> > IRStats::Update::Handler::MyHandler::hit('IRStats::Update::Handler::MyHandl er=HASH(0xa4ad5c8)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> > local/irstats/var/www/irstats/lib/IRStats/Update/Handler/MyHandler.pm
> > line 38
> > IRStats::Update::Handler::MyHandler::fulltext('IRStats::Update::Handler::My Handler=HASH(0xa4ad5c8)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> > local/irstats/var/www/irstats/lib/IRStats/Update/Filter/
> > SearchParser.pm line 159
> > IRStats::Update::Filter::SearchParser::AUTOLOAD('IRStats::Update::Filter::S earchParser=HASH(0xa1f807c)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> > perl5/site_perl/5.8.8/Logfile/EPrints/Filter/Repeated.pm line 49
> > Logfile::EPrints::Filter::Repeated::fulltext('Logfile::EPrints::Filter::Rep eated=HASH(0xa3e7d90)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> > perl5/site_perl/5.8.8/Logfile/EPrints/Filter/Robots.pm line 45
> > Logfile::EPrints::Filter::Robots::AUTOLOAD('Logfile::EPrints::Filter::Robot s=HASH(0xa50d1a8)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> > perl5/site_perl/5.8.8/Logfile/EPrints/Filter/Session.pm line 183
> > Logfile::EPrints::Filter::MaxPerSession::AUTOLOAD('Logfile::EPrints::Filter ::MaxPerSession=HASH(0xa3cdf18)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> > local/irstats/var/www/irstats/lib/IRStats/Update/Filter/
> > SelfReferrerFilter.pm line 23
> > IRStats::Update::Filter::SelfReferrerFilter::fulltext('IRStats::Update::Fil ter::SelfReferrerFilter=HASH(0xa4b72b8)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> > local/irstats/var/www/irstats/lib/IRStats/Update/Filter/
> > NegateHandler.pm line 28
> > IRStats::Update::Filter::NegateHandler::AUTOLOAD('IRStats::Update::Filter:: NegateHandler=HASH(0xa51c9c0)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> > perl5/site_perl/5.8.8/Logfile/EPrints/Filter.pm line 35
> > Logfile::EPrints::Filter::AUTOLOAD('IRStats::Update::Filter::FulltextOnly=H ASH(0xa64281c)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> > local/irstats/var/www/irstats/lib/IRStats/Update/Filter/
> > FulltextOnly.pm line 11
> > IRStats::Update::Filter::FulltextOnly::fulltext('IRStats::Update::Filter::F ulltextOnly=HASH(0xa64281c)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> > perl5/site_perl/5.8.8/Logfile/EPrints/Filter/Session.pm line 39
> > Logfile::EPrints::Filter::Session::AUTOLOAD('Logfile::EPrints::Filter::Sess ion=HASH(0xa406940)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/
> > local/irstats/var/www/irstats/lib/IRStats/Update/Parser/
> > ApacheEPrints.pm line 47
> > IRStats::Update::Parser::ApacheEPrints::AUTOLOAD('IRStats::Update::Parser:: ApacheEPrints=HASH(0xa5fc3ac)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> > perl5/site_perl/5.8.8/Logfile/EPrints/Mapping/EPrints.pm line 21
> > Logfile::EPrints::Mapping::EPrints::hit('Logfile::EPrints::Mapping::EPrints =HASH(0xa4212c8)',
> > 'Logfile::EPrints::Hit::Combined=HASH(0xa6441a4)') called at /usr/lib/
> > perl5/site_perl/5.8.8/Logfile/EPrints/Parser.pm line 26
> > Logfile::EPrints::Parser::parse_fh('Logfile::EPrints::Parser=HASH(0xa3fe4f4 )',
> > 'GLOB(0x9dae348)') called at /usr/local/irstats/var/www/irstats/lib/
> > IRStats/Update/Parser/ApacheEPrints.pm line 33
> > IRStats::Update::Parser::ApacheEPrints::parse('IRStats::Update::Parser::Apa cheEPrints=HASH(0xa5fc3ac)')
> > called at /usr/local/irstats/var/www/irstats/lib/IRStats/CLI/
> > update_table.pm line 91
> > IRStats::CLI::update_table::execute('IRStats::CLI::update_table=HASH(0x9fd8 7e4)')
> > called at /usr/local/irstats/var/www/irstats/lib/IRStats/CLI.pm line
> > 58
> > IRStats::CLI::handler() called at /usr/local/irstats/var/www/
> > irstats/lib/IRStats.pm line 70
> > IRStats::handler() called at /usr/local/irstats/var/www/cgi-
> > bin/irstats.cgi line 30
> > Is anyone able to advise what might be causing this problem? Any help
> > would be greatly appreciated.
> > Thanks,
> > Guy
> > Guy Knights
> > Computer Systems Officer
> > Library Systems, QUT
> > Phone: (07) 3138 3910
> > Email: g.knig...@qut.edu.au