Message from discussion
Problem importing eprints 2 apache log data
MIME-Version: 1.0
Received: by 10.100.142.15 with SMTP id p15mr65036and.8.1225768864897; Mon, 03
Nov 2008 19:21:04 -0800 (PST)
Date: Mon, 3 Nov 2008 19:21:04 -0800 (PST)
X-IP: 131.181.155.53
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.3)
Gecko/2008092417 Firefox/3.0.3,gzip(gfe),gzip(gfe)
Message-ID: <64aefd6a-2300-4202-8ae9-1e44cd2108fe@q30g2000prq.googlegroups.com>
Subject: Problem importing eprints 2 apache log data
From: Guy <guy.knig...@gmail.com>
To: IRStats Discuss <irstats-discuss@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
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::mysql=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::DatabaseInterface::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::MyHandler=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::MyHandler=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::SearchParser=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::Repeated=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::Robots=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::Filter::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=HASH(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::FulltextOnly=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::Session=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::ApacheEPrints=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(0x9fd87e4)')
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