Hello Daniel, That did the trick. I just did as you said by dropping the 6 tables and re-creating them with longer character restrictions.
Not sure but I think it may have related to the dc.rights field, which seems to be collected by the stats package to show items accessed by 'access type', but in our case we use the dc.rights field to record copyright information, so naturally it wasn't what the system was expecting. I'm not too concerned that this stat doesn't work, the system simply doesn't display it. You've saved me countless hours, thanks again. Joseph (Anyone interested can view UCD's statistics at http://irserver.ucd.ie/dspace/stats -- I'm working on opening up a few more to the public this afternoon. Brilliant work from University of Minho team!) -----Original Message----- From: Daniel Ishimitsu [mailto:[email protected]] Sent: 28 August 2009 00:46 To: [email protected] Cc: [email protected]; [email protected] Subject: Re: [Dspace-tech] U. Minho Stats package error Hi Joseph, Minho stats copies some values of metadata into its own tables for indexing. In DSpace the length is unlimited, but minho has a cap of 200 chars, so it gives an error when copying if your DSpace metadata is bigger than 200 chars. Expanding the "field_value" column in the following tables should fix the error when aggregating (we set ours to 2000 chars but that's probably overkill): stats.view_metadata_month stats.view_metadata_coll_month stats.view_metadata_comm_month stats.download_metadata_month stats.download_metadata_coll_month stats.download_metadata_comm_month If you use non-standard metadata fields you may also want to check that it's indexing the correct fields. I think by default it does date.issued, title, and contributor.author. But if you've moved/edited fields it may be looking in the wrong place. You can see the list of fields it's indexing via running this db query. select * from metadatafieldregistry where metadata_field_id in (select metadata_field_id from stats.metadata_aggreg); Hope that helps, Daniel Ishimitsu University of Hawaii Hamilton Library, DNS > Date: Wed, 26 Aug 2009 16:47:30 +0100 > From: joseph greene <[email protected]> > Subject: [Dspace-tech] U. Minho Stats package error > To: [email protected] > Cc: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > Has anyone encountered the following error when trying to run the stats.aggregate(); script of the U. Minho Stats package? I'm on DSpace 1.4.2, stats-addon-2.0, though I think it may be the same code as 2.1. I would really appreciate the help-- I've gotten it to work this far, would love for the whole thing to be working. I'm up to my ears in the code trying to trace it back, but this pgsql procedural language is new to me. > > Here's the error: > > select stats.aggregate(); > ERROR:? value too long for type character varying(200) > CONTEXT:? SQL statement "INSERT INTO stats.view_metadata_month (field_id, field_value, yearmo > nth,year,value) values ( $1 ,? $2 , stats.getyearmonth( $3 ::date), date_part('year', $4 )::i > nteger,? $5 )" > ??????? PL/pgSQL function "aggregate_view" line 211 at SQL statement > ??????? PL/pgSQL function "aggregate" line 11 at assignment > STATEMENT:? select stats.aggregate(); > ERROR:? value too long for type character varying(200) > CONTEXT:? SQL statement "INSERT INTO stats.view_metadata_month (field_id, field_value, yearmonth,year,value) values ( $1 ,? $2 , stats.getyearmonth( $3 ::date), date_part('year', $4 )::integer,? $5 )" > PL/pgSQL function "aggregate_view" line 211 at SQL statement > PL/pgSQL function "aggregate" line 11 at assignment > > Many thanks, > > Joseph Greene > Institutional Repository Project Manager > 325 James Joyce Library > University College Dublin > Belfield, Dublin 4 > > 353 (0)1 716 7398 > [email protected] > http://irserver.ucd.ie/dspace/ > > > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
