[ABD] PostsStatistics

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
User avatar
draky
Registered User
Posts: 250
Joined: Tue Dec 10, 2002 2:04 pm
Location: France
Name: Gilles W.

Re: [DEV] PostsStatistics

Post 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()
Holger
Registered User
Posts: 1892
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] PostsStatistics

Post 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()
User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post by John P »

Looks if there is no year selected
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
Holger
Registered User
Posts: 1892
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] PostsStatistics

Post by Holger »

Ok, what can I do about that?
Holger
Registered User
Posts: 1892
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] PostsStatistics

Post by Holger »

User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post by John P »

Thanks Holger, can I look at your board?
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
Cable Player
Registered User
Posts: 516
Joined: Thu Feb 03, 2011 4:45 pm
Location: Hampshire, England

Re: [DEV] PostsStatistics

Post 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
User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post by John P »

Hi Cable_player, I will update tonight.
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
Holger
Registered User
Posts: 1892
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] PostsStatistics

Post 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?
Cable Player
Registered User
Posts: 516
Joined: Thu Feb 03, 2011 4:45 pm
Location: Hampshire, England

Re: [DEV] PostsStatistics

Post by Cable Player »

John P wrote:Hi Cable_player, I will update tonight.

Thanks for the info :)
Holger
Registered User
Posts: 1892
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] PostsStatistics

Post 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!
User avatar
draky
Registered User
Posts: 250
Joined: Tue Dec 10, 2002 2:04 pm
Location: France
Name: Gilles W.

Re: [DEV] PostsStatistics

Post 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 ?
User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post 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.
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
User avatar
wintstar
Registered User
Posts: 345
Joined: Sat Mar 07, 2009 12:39 pm
Location: Central Hessen, close to the "heart of nature", Germany

Re: [DEV] PostsStatistics

Post 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?
User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post by John P »

It's in the Highchart package
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

Return to “Abandoned Extensions”