Stuart Wright
Well-known member
Good job, Matt, thanks.
That is because you will had enabled Showcase support when it's not actually installed. Just disable that option againI 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"
}
}
The data isn't available on forum_view, only forum_list. I take it that is using widget framework?Any reason why the stats are updating on the forum_list and NOT the forum_view?
This add-on could be edited to do what you are asking.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.
What is the time zone on the server you are running?How can I make this stop resetting at like 8PM Central Time?
UNIX_TIMESTAMP(CURDATE( ))
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:
Code:UNIX_TIMESTAMP(CURDATE( ))
[root@cloud2 ~]# date
Fri Feb 7 01:13:01 CST 2014
date.timezone = Europe/London
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)
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.Had to edit my.cnf with
Code: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
We use essential cookies to make this site work, and optional cookies to enhance your experience.