OJS Plugin: Statistic Charts (2.4.3 to 2.4.8-1)

Software Support
62

thank you so much, now its work…

63

Works on ojs 2 or 3?

64

Hi andrewdion04

I want to know if the change works in ojs 3 thanks

65

its work on my OJS 2.4.8.1

66

Iam sorry, Iam using OJS 2.4.8.1

67

Thank you @franms for the plugin!
But, I have some problems with your plugin. In section Article (Download & Abstract) and Issues do not show any data. Can you help me to solve this problems? Thank you

68

Hola, necesito que este plugin sea compatible con OJS versión 3.0.2, cómo lo adapto a esta versión. Me hace falta su ayuda. Estaré pendiente de su respuesta. Saludos

69

@franms, I was with the same problem that @blu3r4w had. The sections Article (Download) and Article(Abstract) didn’t show any data.

I noted that I was getting an error when I tried to access these links. The message was:

DB Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘dbd_ojs.aset.setting_value’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Stack Trace:

File: /opt/lampp/htdocs/ojs/plugins/generic/statistics/StatisticsChartsDAO.inc.php line 81
Function: DAO->retrieve(“SELECT aset.setting_value, SUM(m.metric) FROM metrics as m INNER…”, Array(4))

File: /opt/lampp/htdocs/ojs/plugins/generic/statistics/StatisticsHandler.inc.php line 198
Function: StatisticsChartsDAO->getMetricsMostPopularByType(“2”, “257”, “2018”, “pt_BR”)

Then, I just added the field “aset.setting_value” to the beginning group by clause, and it is working now. I’m not very used to the group by clause, but I think it is right, isn’t it? If it is, may I send you a pull request? (I’ve never sent one yet :slight_smile: )

70

Hi All, I know it’s been a while since this post. But could you please help me with the process of populating the geolocalization fields country_id, region and city in metrics table. I following this steps:

  1. Confirm that usageStatsPlugin is enabled and metrics has some information
  2. Copy GeoLiteCity.dat to plugins\generic\usageStats\
  3. Move log files from archive to stage
  4. Reprocess log files: php tools/runScheduledTasks.php plugins/generic/usageStats/scheduledTasks.xml
    But I still get NULLS in country_id, region and city
71

Hola @kawahyu , yo uso 2.4.8.3 y me da el mismo problema. ¿Lo pudiste solucionar?
Saludos cordiales

72

Did you solve this problem? To me the same thing happens to me

73

162/5000

Good afternoon,

I installed the plugin
Download from github: GitHub - franmanez/statistics: Plugin statistics charts for OJS (2.4.3 to 2.4.8-1)
However, the names were not correct.

image

Can you help me.

1 Like
74

Esto es un error de traducción…