[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: 269
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [DEV] Board Statistics

Post by Walther » Fri Oct 31, 2014 10:50 am

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 » Fri Oct 31, 2014 11:40 am

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 » Fri Oct 31, 2014 4:05 pm

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: 61
Joined: Tue Oct 29, 2013 4:41 am
Location: The index
Contact:

Re: [DEV] Board Statistics

Post by Phillip » Fri Oct 31, 2014 4:15 pm

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: 269
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [DEV] Board Statistics

Post by Walther » Mon Nov 03, 2014 12:06 pm

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 » Mon Nov 03, 2014 2:17 pm

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 » Mon Nov 03, 2014 2:19 pm

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: 269
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [DEV] Board Statistics

Post by Walther » Mon Nov 03, 2014 4:20 pm

...

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: 1756
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] Board Statistics

Post by Holger » Tue Nov 04, 2014 1:05 pm


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 » Tue Nov 04, 2014 8:31 pm

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 » Mon Nov 10, 2014 3:07 pm

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: 1756
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] Board Statistics

Post by Holger » Mon Nov 10, 2014 3:11 pm

I have the same error!

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

Re: [DEV] Board Statistics

Post by Stoker 4.0 » Mon Nov 17, 2014 4:19 am

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 » Thu Nov 27, 2014 7:35 pm

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 » Fri Nov 28, 2014 7:41 am

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”