Go to Google Groups Home    IRStats Discuss
Problem importing eprints 2 apache log data

Guy <guy.knig...@gmail.com>

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