Daily Statistics 1.3.5

[Stuart Wright]

Good job, Matt, thanks.

 

[Allan]

Thank you for this add-on MattW

French language attached !

 

[Allan Hsu]

I get these error logs after installation
------------------------------------------------------

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'osaka_forum.xf_nflj_showcase_item' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 6 minutes ago
Stack Trace
#0 /home/osaka/public_html/forum/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('? ...')
#1 /home/osaka/public_html/forum/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '? ...')
#2 /home/osaka/public_html/forum/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('? ...')
#3 /home/osaka/public_html/forum/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('? ...', Array)
#4 /home/osaka/public_html/forum/library/DailyStats/Model/DailyStats.php(138): Zend_Db_Adapter_Abstract->fetchOne('? ...')
#5 /home/osaka/public_html/forum/library/DailyStats/CronEntry/DailyStats.php(29): DailyStats_Model_DailyStats->getTotalShowcase()
#6 [internal function]: DailyStats_CronEntry_DailyStats::getDailyStatsTotal(Array)
#7 /home/osaka/public_html/forum/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#8 /home/osaka/public_html/forum/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#9 /home/osaka/public_html/forum/library/XenForo/Model/Deferred.php(243): XenForo_Deferred_Cron->execute(Array, Array, 9.99999904633, '')
#10 /home/osaka/public_html/forum/library/XenForo/Model/Deferred.php(369): XenForo_Model_Deferred->runDeferred(Array, 9.99999904633, '', false)
#11 /home/osaka/public_html/forum/library/XenForo/Model/Deferred.php(322): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#12 /home/osaka/public_html/forum/deferred.php(18): XenForo_Model_Deferred->run(false)
#13 {main}
Request State
array(3) {
["url"] => string(38) "http://jp.osaka.com/forum/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(16) "/forum/index.php"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}

 

[MattW]

I get these error logs after installation
------------------------------------------------------

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'osaka_forum.xf_nflj_showcase_item' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 6 minutes ago
Stack Trace
#0 /home/osaka/public_html/forum/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('? ...')
#1 /home/osaka/public_html/forum/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '? ...')
#2 /home/osaka/public_html/forum/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('? ...')
#3 /home/osaka/public_html/forum/library/Zend/Db/Adapter/Abstract.php(825): Zend_Db_Adapter_Abstract->query('? ...', Array)
#4 /home/osaka/public_html/forum/library/DailyStats/Model/DailyStats.php(138): Zend_Db_Adapter_Abstract->fetchOne('? ...')
#5 /home/osaka/public_html/forum/library/DailyStats/CronEntry/DailyStats.php(29): DailyStats_Model_DailyStats->getTotalShowcase()
#6 [internal function]: DailyStats_CronEntry_DailyStats::getDailyStatsTotal(Array)
#7 /home/osaka/public_html/forum/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#8 /home/osaka/public_html/forum/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#9 /home/osaka/public_html/forum/library/XenForo/Model/Deferred.php(243): XenForo_Deferred_Cron->execute(Array, Array, 9.99999904633, '')
#10 /home/osaka/public_html/forum/library/XenForo/Model/Deferred.php(369): XenForo_Model_Deferred->runDeferred(Array, 9.99999904633, '', false)
#11 /home/osaka/public_html/forum/library/XenForo/Model/Deferred.php(322): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#12 /home/osaka/public_html/forum/deferred.php(18): XenForo_Model_Deferred->run(false)
#13 {main}
Request State
array(3) {
["url"] => string(38) "http://jp.osaka.com/forum/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(16) "/forum/index.php"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}

That is because you will had enabled Showcase support when it's not actually installed. Just disable that option again

 

[Blatchy]

Any reason why the stats are updating on the forum_list and NOT the forum_view?

 

[MattW]

Any reason why the stats are updating on the forum_list and NOT the forum_view?

The data isn't available on forum_view, only forum_list. I take it that is using widget framework?

 

[Blatchy]

yes..

okay I guess I will have to disable this for now.

 

[Echelon]

anyone knows how i can manage [or some add on] to only show the new registered members on my forum? no stats, just new registered members?

 

[MattW]

anyone knows how i can manage [or some add on] to only show the new registered members on my forum? no stats, just new registered members?

This add-on could be edited to do what you are asking.

 

[Echelon]

This add-on could be edited to do what you are asking.

like it...thanks alot!

 

[Brent W]

How can I make this stop resetting at like 8PM Central Time?

 

[MattW]

How can I make this stop resetting at like 8PM Central Time?

What is the time zone on the server you are running?

The queries use the current date, so if it's resetting at 8pm central time, then that is when the server time goes over to the next day:

UNIX_TIMESTAMP(CURDATE( ))

 

[Brent W]

What is the time zone on the server you are running?

The queries use the current date, so if it's resetting at 8pm central time, then that is when the server time goes over to the next day:

UNIX_TIMESTAMP(CURDATE( ))

Time is correct for my timezone on my server:

[root@cloud2 ~]# date
Fri Feb  7 01:13:01 CST 2014

 

[MattW]

and what time zone is set in your PHP.ini file?

date.timezone = Europe/London

Can you try running this in MySQL?

MariaDB [(none)]> SELECT CURDATE();
+------------+
| CURDATE()  |
+------------+
| 2014-02-07 |
+------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SELECT CURTIME();                    
+-----------+
| CURTIME() |
+-----------+
| 07:17:21  |
+-----------+
1 row in set (0.00 sec)

 

[Brent W]

I had UTC in php.ini. Changed it and will see if that fixes it. Thanks

 

[Brent W]

Still running at the wrong date. I have the following in php.ini:

https://www.dropbox.com/s/m46p4pty74qlnh2/Screenshot 2014-02-07 19.42.55.png

Yet it is still showing the default timezone as UTC

 

[Brent W]

Had to edit my.cnf with

default-time-zone = '-06:00'

 

[Mouth]

Had to edit my.cnf with

default-time-zone = '-06:00'

MySQL defaults to the system/server timezone when it starts-up. If you had to override at the SQL level, then it suggests your system timezone is not correct.
But great that it resolved for you

 

[Brent W]

MySQL defaults to the system/server timezone when it starts-up. If you had to override at the SQL level, then it suggests your system timezone is not correct.
But great that it resolved for you

[root@cloud2 ~]# date

Sat Feb 8 04:17:43 CST 2014

Well it wasn't working in this case because date has always returned correct and MySQL did not until that edit.

 

[tommydamic68]

@MattW - is there a way to remove "new members today" on the side block in the forum homepage?