[ABD] Board Statistics

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.
Locked
User avatar
Walther
Registered User
Posts: 277
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [DEV] Board Statistics

Post by Walther »

Getting the next 3-parted error in the log files on a hourly bases:
Fout tijdens het aanmaken van een afbeelding
» Fout in [ROOT]/ext/forumhulp/statistics/cron/task/core/delete_statistics.php op regel 72: include(./ext/forumhulp/statistics/vendor/find_os.php) [function.include]: failed to open stream: No such file or directory
Fout tijdens het aanmaken van een afbeelding
» Fout in [ROOT]/ext/forumhulp/statistics/cron/task/core/delete_statistics.php op regel 72: include(./ext/forumhulp/statistics/vendor/find_os.php) [function.include]: failed to open stream: No such file or directory
Fout tijdens het aanmaken van een afbeelding
» Fout in [ROOT]/ext/forumhulp/statistics/cron/task/core/delete_statistics.php op regel 72: include() [function.include]: Failed opening './ext/forumhulp/statistics/vendor/find_os.php' for inclusion (include_path='.:/usr/local/lib/php')
For our English speaking community:
"Fout tijdens het aanmaken van een afbeelding" means "Error while creating image "

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

Re: [DEV] Board Statistics

Post by John P »

DrakusorU wrote:Would be nice an unique visitors counter per months, day, week something like that.. :D It will be nice if I can see how many unique visitors I have per each month without using some others websites for my website statistics..
Counting unique visitors means a record per day. Your db will grow then, do we want that?
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

DrakusorU
Registered User
Posts: 2
Joined: Thu Oct 30, 2014 10:55 pm

Re: [DEV] Board Statistics

Post by DrakusorU »

John P wrote:
DrakusorU wrote:Would be nice an unique visitors counter per months, day, week something like that.. :D It will be nice if I can see how many unique visitors I have per each month without using some others websites for my website statistics..
Counting unique visitors means a record per day. Your db will grow then, do we want that?
Hmm.. I dont know how much will grow because I dont know many things about SQL.. I have just this idea in my mind.. Saving unique IPs or something like that in a table and counting them, after a month save as a number how many unique IPs we had saved in another table and delete the IPs and start tracking again.. :-??

Also I saw that you already save the IPs, countries, providers.. isnt that having the same results ? :D

User avatar
Phillip
Registered User
Posts: 64
Joined: Tue Oct 29, 2013 4:41 am
Location: The index
Contact:

Re: [DEV] Board Statistics

Post by Phillip »

I like this extension. I use it on my own site. :) Very useful stuff with it.
“Be who you are and say what you feel, because those who mind don't matter, and those who matter don't mind.”
― Bernard M. Baruch​

User avatar
Walther
Registered User
Posts: 277
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [DEV] Board Statistics

Post by Walther »

Disabled this extension due to too much mySQL server lockups.
It was effecting other websites too

error's like:
Fatal error: Out of memory (allocated 4718592) (tried to allocate 77824 bytes) in /home/duh/domains/ohcrap.nl/public_html/forum/includes/mods/soft_delete.php on line 279

Fatal error: Out of memory (allocated 3932160) (tried to allocate 19456 bytes) in /home/duh/domains/ohcrap.nl/public_html/forum/includes/functions_user.php on line 1681

On first sight, there is no connection with these extension, only that they always happens when you pressed a statistic option with a huge mySQL load, which caused immediately a 'frozen' browser and users reporting errors .

--------

BTW: no answer yet on earlier reported error ?
viewtopic.php?p=13778216#p13778216
(first posting from this page in standard setup)
This problem still persist. :cry:

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

Re: [DEV] Board Statistics

Post by John P »

DrakusorU wrote:
John P wrote:
DrakusorU wrote:Would be nice an unique visitors counter per months, day, week something like that.. :D It will be nice if I can see how many unique visitors I have per each month without using some others websites for my website statistics..
Counting unique visitors means a record per day. Your db will grow then, do we want that?
Hmm.. I dont know how much will grow because I dont know many things about SQL.. I have just this idea in my mind.. Saving unique IPs or something like that in a table and counting them, after a month save as a number how many unique IPs we had saved in another table and delete the IPs and start tracking again.. :-??

Also I saw that you already save the IPs, countries, providers.. isnt that having the same results ? :D
If you want unique visitors in one month you have to save all the ip's for one month and count them up.
The counting of countries is something else because its only for one day and then totalized.
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

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

Re: [DEV] Board Statistics

Post by John P »

Walther wrote:Disabled this extension due to too much mySQL server lockups.
It was effecting other websites too

error's like:
Fatal error: Out of memory (allocated 4718592) (tried to allocate 77824 bytes) in /home/duh/domains/ohcrap.nl/public_html/forum/includes/mods/soft_delete.php on line 279

Fatal error: Out of memory (allocated 3932160) (tried to allocate 19456 bytes) in /home/duh/domains/ohcrap.nl/public_html/forum/includes/functions_user.php on line 1681

On first sight, there is no connection with these extension, only that they always happens when you pressed a statistic option with a huge mySQL load, which caused immediately a 'frozen' browser and users reporting errors .

--------

BTW: no answer yet on earlier reported error ?
viewtopic.php?p=13778216#p13778216
(first posting from this page in standard setup)
This problem still persist. :cry:

You have a mod soft_delete in your 3.1 board?

Sorry didn't see the first posting. Is the file in place in folder vendor?
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

User avatar
Walther
Registered User
Posts: 277
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [DEV] Board Statistics

Post by Walther »

...

Sorry didn't see the first posting. Is the file in place in folder vendor?
Yes, first thing I checked, it's 29.565 Bytes

Holger
Registered User
Posts: 1776
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] Board Statistics

Post by Holger »


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

Re: [DEV] Board Statistics

Post by John P »

Thanks Holger
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

discovery
Registered User
Posts: 13
Joined: Fri Nov 07, 2014 6:54 pm

Re: [DEV] Board Statistics

Post by discovery »

Hello,

Great extension ;)

however I have this error in the error log:
» Erreur dans [ROOT]/ext/forumhulp/statistics/cron/task/core/delete_statistics.php à la ligne 72 : include(./ext/forumhulp/statistics/vendor/find_os.php): failed to open stream: No such file or directory
» Erreur dans [ROOT]/ext/forumhulp/statistics/cron/task/core/delete_statistics.php à la ligne 72 : include(): Failed opening './ext/forumhulp/statistics/vendor/find_os.php' for inclusion (include_path='.:/usr/local/php5.4/lib/php')

Holger
Registered User
Posts: 1776
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] Board Statistics

Post by Holger »

I have the same error!

User avatar
Stoker 4.0
Registered User
Posts: 1487
Joined: Sun Feb 13, 2011 1:33 pm
Location: Funen, Denmark
Name: Ulrik Christensen
Contact:

Re: [DEV] Board Statistics

Post by Stoker 4.0 »

When viewing the stats page

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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 '"Yahoo!)' at line 1 [1064]

SQL

SELECT COUNT(id) AS total_entries FROM phpbb_statistics_online WHERE uname NOT IN ("AdsBot [Google]","Alexa [Bot]","Alta Vista [Bot]","Ask Jeeves [Bot]","Baidu [Spider]","Exabot [Bot]","FAST Enterprise [Crawler]","FAST WebCrawler [Crawler]","Francis [Bot]","Gigabot [Bot]","Google Adsense [Bot]","Google Desktop","Google Feedfetcher","Google [Bot]","Heise IT-Markt [Crawler]","Heritrix [Crawler]","IBM Research [Bot]","ICCrawler - ICjobs","goo ichiro [Crawler]","Majestic-12 [Bot]","Metager [Bot]","MSN NewsBlogs","MSN [Bot]","MSNbot Media","Nutch [Bot]","Online link [Validator]","psbot [Picsearch]","Sensis [Crawler]","SEO Crawler","Seoma [Crawler]","SEOSearch [Crawler]","Snappy [Bot]","Steeler [Crawler]","Telekom [Bot]","TurnitinBot [Bot]","Voyager [Bot]","W3 [Sitesearch]","W3C [Linkcheck]","W3C [Validator]","YaCy [Bot]","Yahoo MMCrawler [Bot]","Yahoo Slurp [Bot]","Yahoo [Bot]","YahooSeeker [Bot]","Java [Bad bot]","Thumbshots [Capture]","Susie [Sync]","Google Ads","Google Python URL fetcher","Google Search Appliance","Yahoo! SpiderMan","Yahoo! Mindset","Yahoo! Blogs","Yahoo! Feed Seeker","Yahoo!)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 852
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/ext/forumhulp/statistics/vendor/stat_functions.php
LINE: 125
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/forumhulp/statistics/acp/statistics_module.php
LINE: 167
CALL: stat_functions::online()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\statistics\acp\statistics_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

JörgCH
Registered User
Posts: 66
Joined: Tue Nov 25, 2014 10:07 pm

Re: [DEV] Board Statistics

Post by JörgCH »

I also ....

Code: Select all

SQL ERROR [ mysqli ]

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 '"Yahoo! Mul)' at line 1 [1064]

SQL

SELECT COUNT(id) AS total_entries FROM phpbb_statistics_online WHERE uname NOT IN ("AdsBot [Google]","Alexa [Bot]","Alta Vista [Bot]","Ask Jeeves [Bot]","Baidu [Spider]","Exabot [Bot]","FAST Enterprise [Crawler]","FAST WebCrawler [Crawler]","Francis [Bot]","Gigabot [Bot]","Google Adsense [Bot]","Google Desktop","Google Feedfetcher","Google [Bot]","Heise IT-Markt [Crawler]","Heritrix [Crawler]","IBM Research [Bot]","ICCrawler - ICjobs","ichiro [Crawler]","Majestic-12 [Bot]","Metager [Bot]","MSN NewsBlogs","MSN [Bot]","MSNbot Media","Nutch [Bot]","Online link [Validator]","psbot [Picsearch]","Sensis [Crawler]","SEO Crawler","Seoma [Crawler]","SEOSearch [Crawler]","Snappy [Bot]","Steeler [Crawler]","Telekom [Bot]","TurnitinBot [Bot]","Voyager [Bot]","W3 [Sitesearch]","W3C [Linkcheck]","W3C [Validator]","YaCy [Bot]","Yahoo MMCrawler [Bot]","Yahoo Slurp [Bot]","Yahoo [Bot]","YahooSeeker [Bot]","Java [Bad bot]","Thumbshots [Capture]","Susie [Sync]","Google Ads","Google Python URL fetcher","Google Search Appliance","Yahoo! SpiderMan","Yahoo! Mindset","Yahoo! Blogs","Yahoo! Feed Seeker","Yahoo! Mul)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 852
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/statistics/vendor/stat_functions.php
LINE: 125
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/forumhulp/statistics/acp/statistics_module.php
LINE: 167
CALL: stat_functions::online()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\statistics\acp\statistics_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
Contact:

Re: [DEV] Board Statistics

Post by John P »

It looks there is a single or double quote in the botsname.

As the botlist is working with the standard botlist from phpbb I would like to know your botlist.
Can you export the list here or send by pm?
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

Locked

Return to “Abandoned Extensions”