Global Statistics Plugin

Plugin works fine on 2.3-DR1, however 2.2.1a fails with the following:

Caused by: java.lang.NoSuchMethodError: com.atlassian.confluence.spaces.SpaceManager.getAllSpaces()Ljava/util/List;
	at com.atlassian.confluence.extra.globalstats.ViewStatisticsAction.doDefault(ViewStatisticsAction.java:40)

Above I said the plugin works fine - however thats not strictly true. It also functions on 2.2.5 however both 2.3-DR1 and 2.2.5 produce these errors when using a MySQL DB:

2006-08-29 12:40:41,974 ERROR [confluence.extra.globalstats.GlobalStatisticsManager] \
doSqlCountQuery Unable to perform query [select count(c.*) from CONTENT as c \
where c.SPACEID = 19 and c.PREVVER is null and c.CONTENTTYPE = 'BLOGPOST']: \
java.sql.SQLException: You have an error in your SQL syntax; \
check the manual that corresponds to your MySQL server version for the right syntax to use near \
'*) from CONTENT as c where c.SPACEID = 19 and c.PREVVER is null and c.CONTENTTYP' at line 1
java.sql.SQLException: You have an error in your SQL syntax; \
check the manual that corresponds to your MySQL server version for the right syntax to use near \
'*) from CONTENT as c where c.SPACEID = 19 and c.PREVVER is null and c.CONTENTTYP' at line 1

There are a fair few of them, around 8 - 10. For reference here is my MySQL version information:

mysql  Ver 14.7 Distrib 4.1.13, for suse-linux (i686) using readline 5.0

I installed the globalstats-plugin-2.0-1.0.jar into my 2.0.3 Build:#323 Confluence implementation successfully (or at least it appeared to install ok). When I hit the generate stats button I get the following error in my log file:

2006-09-12 16:34:18,754 ERROR [confluence.extra.globalstats.GlobalStatisticsManager] Unable to perform query \
[select count(c.*) from CONTENT as c where c.SPACEID = 37 and c.PREVVER is null and c.CONTENTTYPE = 'BLOGPOST']: \
java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification

Any ideas other than to upgrade? (upgrading would be very difficult at the moment and this info would be invaluable).

I uninstalled the old version, cleared out my tomcat /work directory, restarted my confluence server, and then uploaded/installed the new 2.2.1.1 version (and verified it was in the ./plugins directory).  I still get the same error reported above with MySQL 5.0.22.

Hi,

I just installed this plugin (using Repository Client) and getting errors.

We are using Confluence 2.2.4 / Oracle 9i database

I guess, sqls are in Oracle pl/sql style. Here is one exception

2006-09-19 13:20:21,928 ERROR [confluence.extra.globalstats.GlobalStatisticsManager] doSqlCountQuery Unable to perform query \
[select count(c.*) from CONTENT as c where c.PREVVER is null and c.CONTENTTYPE = 'MAIL']: java.sql.SQLException: \
ORA-01747: invalid user.table.column, table.column, or column specification

But if I do change the query little bit and run; it executes with results. The correc sql query is:

select count(*) from CONTENT c where c.PREVVER is null and c.CONTENTTYPE = 'MAIL';

Has anyone able to run this plugin successfully (with Oracle as backend) ?

thanks,
Rajendra

Ivan,

From your comments it looks like you have made changes for MySQL Database.
What about Oracle database ? Will those queries execute?

thanks,
Rajendra

Confluence Repository Client gives this error:

Plugin [confluence.extra.globalstats] File Not Found: http://confluence.atlassian.com/download/attachments/186998/globalstats-plugin-2.2-1.0.jar

I get the same error. Try copying the plugin's URL, and then uploading manually...

Where do I request an extra feature? I want to be able to generate charts such as this one from wikipedia Could not generate thumbnail: Image file format not supported

I just want to be able to demonstrate growth in pages, edits and users over time.

This plugin is really useful.

Is there anyway that I can find out how many pages there are in total in a Confluence wiki. I want to start keeping track of the growth in the number of pages.

Hi, please fix url in Confluence Repository Client. My client download file globalstats-plugin-2.2-1.0.jar (can be globalstats-plugin-2.2-1.1.jar).

Thanks.

Cheers,
Libor

I can't download the jar !

I'm with Christophe C above.  I'm unable to download the jar.   When I click the link that goes here, I get a Page Not Found error.  I looked under the attachments tab where it should be and it is not there.  Perhaps there is some weird administrative only tag on it?  I was also unable to download it from within the plugin repository in our wiki.  Got basically the same error - that it didn't exist.

I downloaded the older version, but it doesn't seem to be working right on 2.5. 

Hi Mark,

Apologies for the inconvenience caused.
The latest JAR file is now uploaded to this page and it's available in the "Download JAR" session. If you want us to send you the JAR file, please kindly create a Support Issue and tell us which file you would like to have.

Cheers,
Tony

Any chance you could add a size metric to these reports.  They are VERY useful right now but being able to see how much space all of the pages/attachments are taking up would also be wonderful!!!

Cool plugin! Thanks for making it!

Hi,  I am not a developer but am managing a confliuence system..So every month I have been copying the results from the Glbal Stats page into an excel pivottable datasource... adding the date down the left column and using this as a way of tracking changes over time.. nbut..

Is there an existing XSLT that I can use to transform the report to atlassian xml into something i can import into Excel or a database.   Or even better how about adding a button on the page next to "send to Atlassian" . "export to xml spreadsheet"

Are there macros that I can use to display these types of stats directly in a space page?

Thanks,

David

I'm looking to get statistics of the top 50 pages for each space.  I know Confluence shows the Top 10 already, but I need a longer list. 

Can I use the SQL plug in and then write an SQL statement to pull this directly from the database?  If so, where can I find docs of the database model (or if anyone knows the tables offhand to save me trolling through the entire data model, that would be helpful

Minor bug I found, in 2.7.0, generating global statistics results in a no Dashboard link, top left....

Hello

Can it gather statistic about downloads and visitors?

I mean when we have any files in attach, can it gather statistics about downloads.

Hi ,
Is this plugin working over clusters ?
Thanks

Any answer on does this work with clusters ?

Are there known performance issues with using the Global Statistics plugin in large instances of Confluence?

which version of the jar is compatible with Confluence 2.2.1 ?

I tried using globalstats-plugin-2.0-1.1.jar which installed  but gave an error when trying to view the stas from the Site Stats link !!