Plugin Not Working As Expected

[gedalia]

I'm trying to use the 'statistics' plugin on the site I manage (sc-shiki.com) but it doesn't display the usage for the day or the usage for the month even though both are enabled in the control panel. I have the distinct feeling this is a n3wb13 problem; if someone could slap some sense into me that would be much appreciated.

[garvinhicking]

Hi!

Which s9y version are you using? Which PHP and MySQL versions are you using?

This sounds to me as if the statistics plugin cannot write to its database table(s).

Regards,
Garvin

[gedalia]

Thanks for the reply!

The versions are:
s9y: 1.2.1
MySQL: 5
PHP: 5

I had thought some compatibility problem or setup issue had occurred and wasn't clear where to begin; my cursory investigation didn't reveal much.

All help is greatly appreciated!

[garvinhicking]

Hi!

Can you check (using phpmyadmin or sorts) if a serendipity_statistics database table exist?

and which options did you configure for the statistics event plugin?

Regards,
Garvin

[gedalia]

Sorry for the slow reply,

The table serendipity_statistics does not exist; if you could provide the SQL command that creates it I could generate it however I'm guessing the reason it wasn't generated would likely inhibit it's use properly. When you ask about the configuration I'm guessing your referring to the settings available through the login screen; they are as follows:


Title: Statistics
Show date of last entry: Yes
Formatting text: Last entry: %s
Show number of entries :Yes
Formatting text: %s entries written
Show number of comments: No
Formatting text: %s comments have been made
Show visitors this month: Yes
Formatting text:%s visitor(s) this month
Show number of current visitors (aggregate past 15 minutes): No
Formatting text:%s visitor(s) online
Cache timeout: 60

They where all set to Yes when I first tried it; the above settings are after playing around with a couple of settings; nothing worked.

Thanks again for all your help.

David

[garvinhicking]

Hi!

Is the corresponding event plugin "Statistics" also installed? This one is required and is responsible for creating the appropriate SQL tables!

Regards,
Garvin

[gedalia]

I installed the plugin 'Statistics' from the GUI and it threw no errors as I would expect if a module was missing; hence my ability to show you the settings and thus the reason it partially works (as can be seen; sc-shiki.com). However, when looking under the 'plugins' folder on the install I only see a 'serendipity_event_statistics' folder; I do not see a 'serendiptity_plugin_statistics' folder. Should there be one? If so, how do I get it.

[garvinhicking]

Hi!

So that means when you go to the s9y plugin manager, you can see a statistics plugin being listed for both the Sidebar section AND for the event section?

The serendipity_event_statistics directory holds both event and sidebar plugin; usually if you install one, the other plugin will be installed, too. But inyour case it makes me believe that the event plugin might not be installed?

Because the config settings you relate to are from the sidebar plugin, not the event plugin.

Regards,
Garvin

[gedalia]

You are right; the event plugin was not listed so I just installed it. Nothing has happened though. Does this take awhile to go into effect or is it immediate?

Thanks,

David

[garvinhicking]

Hi!

After installing the event plugin, you should now see a new admin backend menu option "Statistics", do you have that?

Also can you check if your serendipity_statistics* DB tables are now created?

Regards,
Garvin

[gedalia]

It's now working.

I waited a while after adding the plugin in addition to the event and checking the settings and nothing happened; I followed up today by changing some settings to see if that might prompt it to start and sure enough it's now showing data.

I don't know if it's worth noting but the change I made was to enable 'show users online currently' in addition to the 'show users this month' which was already set.

Thank you for your help.

David