Page 2 of 3
Re: [DEV] PostsStatistics
Posted: Fri Oct 31, 2014 12:26 pm
by draky
Another SQL error :
Code: Select all
General Error
SQL ERROR [ mysqli ]
Unknown column 'U.user_id' in 'on clause' [1054]
SQL
SELECT u.group_id, g.group_name, COUNT(p.post_id) AS total FROM phpbb_posts p LEFT JOIN phpbb_users u ON U.user_id = p.poster_id LEFT JOIN phpbb_groups g ON g.group_id = u.group_id WHERE YEAR(FROM_UNIXTIME(p.post_time)) = 2014 AND MONTH(FROM_UNIXTIME(p.post_time)) = 10 GROUP BY g.group_id ORDER BY total DESC LIMIT 20
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 194
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/vendor/stat_functions.php
LINE: 374
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 123
CALL: stat_functions::gp()
FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Re: [DEV] PostsStatistics
Posted: Mon Nov 03, 2014 9:03 am
by Holger
I get the following error when
- clicking on Post overview
and then
- backwards in months
General Error
SQL ERROR [ mysqli ]
Unknown column 'NaN' in 'where clause' [1054]
SQL
SELECT COUNT(post_id) as total, MONTH(FROM_UNIXTIME(post_time)) as posts_per FROM phpbb31_posts WHERE YEAR(FROM_UNIXTIME(post_time)) = NaN GROUP BY posts_per ORDER BY MONTH(FROM_UNIXTIME(post_time))
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 194
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/vendor/stat_functions.php
LINE: 63
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 95
CALL: stat_functions::posts()
FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Re: [DEV] PostsStatistics
Posted: Mon Nov 03, 2014 11:29 am
by John P
Looks if there is no year selected
Re: [DEV] PostsStatistics
Posted: Mon Nov 03, 2014 12:11 pm
by Holger
Ok, what can I do about that?
Re: [DEV] PostsStatistics
Posted: Tue Nov 04, 2014 1:29 pm
by Holger
Re: [DEV] PostsStatistics
Posted: Tue Nov 04, 2014 8:24 pm
by John P
Thanks Holger, can I look at your board?
Re: [DEV] PostsStatistics
Posted: Sat Nov 08, 2014 11:15 pm
by Cable Player
Hi there,
I've installed the latest version from the "master" branch at github and it says it's v 3.1.0-RC3 in my ACP and that it's out of date and the latest version is 3.1.0-RC4. I clicked the download link and it took me back to the github page to download the same file. Am I missing something?
This also happens with Search Results 3.1.0-RC4 showing as it needs to update to 3.1.0-RC5 but takes me to the same fileset as the download.
Thanks
Re: [DEV] PostsStatistics
Posted: Mon Nov 10, 2014 11:55 am
by John P
Hi Cable_player, I will update tonight.
Re: [DEV] PostsStatistics
Posted: Mon Nov 10, 2014 2:32 pm
by Holger
In the Error log I have:
Error while creating image
» Error in [ROOT]/ext/forumhulp/statistics/cron/task/core/delete_statistics.php on line 72: include(./ext/forumhulp/statistics/vendor/find_os.php): failed to open stream: No such file or directory
and:
Error while creating image
» Error in [ROOT]/ext/forumhulp/statistics/cron/task/core/delete_statistics.php on line 72: include(): Failed opening './ext/forumhulp/statistics/vendor/find_os.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php')
What can I do about that?
Re: [DEV] PostsStatistics
Posted: Mon Nov 10, 2014 3:07 pm
by Cable Player
John P wrote:Hi Cable_player, I will update tonight.
Thanks for the info

Re: [DEV] PostsStatistics
Posted: Mon Nov 10, 2014 3:11 pm
by Holger
Holger wrote:In the Error log I have:
Error while creating image
» Error in [ROOT]/ext/forumhulp/statistics/cron/task/core/delete_statistics.php on line 72: include(./ext/forumhulp/statistics/vendor/find_os.php): failed to open stream: No such file or directory
and:
Error while creating image
» Error in [ROOT]/ext/forumhulp/statistics/cron/task/core/delete_statistics.php on line 72: include(): Failed opening './ext/forumhulp/statistics/vendor/find_os.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php')
What can I do about that?
Seems this is related to Board Statisics mod:
viewtopic.php?p=13800186#p13800186
Sorry!
Re: [DEV] PostsStatistics
Posted: Tue Dec 02, 2014 8:42 am
by draky
Still have MySQL errors.
"Post per topics" :
Code: Select all
SQL ERROR [ mysqli ]
Unknown column 'p.topic_replies' in 'field list' [1054]
SQL
SELECT p.topic_id, p.topic_title, p.topic_replies AS total FROM phpbb_topics p WHERE YEAR(FROM_UNIXTIME(p.topic_time)) = 2014 AND MONTH(FROM_UNIXTIME(p.topic_time)) = 12 ORDER BY total DESC LIMIT 20
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 194
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/vendor/stat_functions.php
LINE: 157
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 103
CALL: stat_functions::ppt()
FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
"Topics per forum" :
Code: Select all
SQL ERROR [ mysqli ]
Unknown column 'forum_topics_real' in 'field list' [1054]
SQL
SELECT forum_id, forum_name, forum_topics_real AS total FROM phpbb_forums WHERE YEAR(FROM_UNIXTIME(forum_last_post_time)) = 2014 AND MONTH(FROM_UNIXTIME(forum_last_post_time)) = 12 ORDER BY total DESC LIMIT 20
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 194
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/vendor/stat_functions.php
LINE: 291
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 115
CALL: stat_functions::tpf()
FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Any idea ?
Re: [DEV] PostsStatistics
Posted: Tue Dec 02, 2014 11:45 am
by John P
Seems those fields are deleted in db.
New version available
@Holger, I really don't know why you have this message. I looked at your website but can not find a forum. Tell me more about your forum.
Re: [DEV] PostsStatistics
Posted: Sun Dec 07, 2014 6:44 am
by wintstar
What is this File => ZeroRequestParameterException.class ?
root/ext/postsstats/adm/style/js/Highcharts-4.0.4/exporting-server/java/highcharts-export/highcharts-export-web/target/highcharts-export-web/WEB-INF/classes/com/highcharts/export/controller/ZeroRequestParameterException.class
https://github.com/ForumHulp/postsstats ... controller
Why is the in as many subfolders?
Re: [DEV] PostsStatistics
Posted: Sun Dec 07, 2014 8:14 am
by John P
It's in the Highchart package