Daily Statistics

Daily Statistics 1.3.5

No permission to download
Overview FAQ Updates (24) Reviews (27) History Discussion
@MattW I installed and when went to my forum I get the below displayed (on all 3 forums)
Code: 
Mysqli prepare error: Table 'apple4me.xf_resource' doesn't exist

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
Zend_Db_Adapter_Abstract->fetchOne() in DailyStats/Model/DailyStats.php at line 38
DailyStats_Model_DailyStats->getTotalResource() in DailyStats/ControllerPublic/DailyStats.php at line 16
DailyStats_ControllerPublic_DailyStats->actionIndex() in XenGallery/ControllerPublic/Index.php at line 7
XenGallery_ControllerPublic_Index->actionIndex() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/apple4me/index.php at line 13

Looks like if you don't have RM installed it errors out since that table does not exist.
Comment out the RM code in the related php files and it works - but still displays the RM on the forum home when enabled.
 
Last edited:
Tracy Perry said:
@MattW I installed and when went to my forum I get the below displayed (on all 3 forums)
Code: 
Mysqli prepare error: Table 'apple4me.xf_resource' doesn't exist

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
Zend_Db_Adapter_Abstract->fetchOne() in DailyStats/Model/DailyStats.php at line 38
DailyStats_Model_DailyStats->getTotalResource() in DailyStats/ControllerPublic/DailyStats.php at line 16
DailyStats_ControllerPublic_DailyStats->actionIndex() in XenGallery/ControllerPublic/Index.php at line 7
XenGallery_ControllerPublic_Index->actionIndex() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /var/www/apple4me/index.php at line 13

Looks like if you don't have RM installed it errors out since that table does not exist.
Comment out the RM code in the related php files and it works - but still displays the RM on the forum home when enabled.
Click to expand...
I'll put a check in to look for that table and remove the code if it's not present.
 
MattW said:
I'll put a check in to look for that table and remove the code if it's not present.
Click to expand...
Also, may want to make it so that the forum sidebar list doesn't display the resource info if RM is not installed. I edited the .XML file to
Code: 
<xen:if is="{$xenOptions.dailystats_forum_home} == '1'">
                    <dl><dt>{xen:phrase totalUsers}:</dt>
                        <dd>{xen:number $totalUsers}</dd></dl>
                    <dl><dt>{xen:phrase totalThreads}:</dt>
                        <dd>{xen:number $totalThreads}</dd></dl>
                    <dl><dt>{xen:phrase totalPosts}:</dt>
                        <dd>{xen:number $totalPosts}</dd></dl>
</xen:if>]]></replace>
    </modification>
    <modification template="wf_widget_stats" modification_key="DailyStats002" description="Adds daily stats to forum home with widget framework" execution_order="100" enabled="1" action="str_replace">
      <find><![CDATA[<!-- slot: forum_stats_extra -->]]></find>
      <replace><![CDATA[<!-- slot: forum_stats_extra -->   
<xen:if is="{$xenOptions.dailystats_forum_home} == '1'">
                    <dl><dt>{xen:phrase totalUsers}:</dt>
                        <dd>{xen:number $totalUsers}</dd></dl>
                    <dl><dt>{xen:phrase totalThreads}:</dt>
                        <dd>{xen:number $totalThreads}</dd></dl>
                    <dl><dt>{xen:phrase totalPosts}:</dt>
                        <dd>{xen:number $totalPosts}</dd></dl>
to remove it, but that will probably have to be done upon each upgrade.
 
Tracy Perry said:
Also, may want to make it so that the forum sidebar list doesn't display the resource info if RM is not installed. I edited the .XML file to
Code: 
<xen:if is="{$xenOptions.dailystats_forum_home} == '1'">
                    <dl><dt>{xen:phrase totalUsers}:</dt>
                        <dd>{xen:number $totalUsers}</dd></dl>
                    <dl><dt>{xen:phrase totalThreads}:</dt>
                        <dd>{xen:number $totalThreads}</dd></dl>
                    <dl><dt>{xen:phrase totalPosts}:</dt>
                        <dd>{xen:number $totalPosts}</dd></dl>
</xen:if>]]></replace>
    </modification>
    <modification template="wf_widget_stats" modification_key="DailyStats002" description="Adds daily stats to forum home with widget framework" execution_order="100" enabled="1" action="str_replace">
      <find><![CDATA[<!-- slot: forum_stats_extra -->]]></find>
      <replace><![CDATA[<!-- slot: forum_stats_extra -->  
<xen:if is="{$xenOptions.dailystats_forum_home} == '1'">
                    <dl><dt>{xen:phrase totalUsers}:</dt>
                        <dd>{xen:number $totalUsers}</dd></dl>
                    <dl><dt>{xen:phrase totalThreads}:</dt>
                        <dd>{xen:number $totalThreads}</dd></dl>
                    <dl><dt>{xen:phrase totalPosts}:</dt>
                        <dd>{xen:number $totalPosts}</dd></dl>
to remove it, but that will probably have to be done upon each upgrade.
Click to expand...
That is coming out as well based on an option to enable the RM stats, which is disabled by default (given it's an add-on and not core stats like the rest)
 
My install hand has worn out. It's ballooned out like those novelty gigantic hands you see at those sporting events. :LOL:

Seriously though, full respect to you @MattW in striving on improving this essential add-on. Exceptional work. :) :thumbsup:

*waves giant hand in the air*
 
Shelley said:
My install hand has worn out. It's ballooned out like those novelty gigantic hands you see at those sporting events. :LOL:
Click to expand...
Try doing it for 3 forums. :ROFLMAO:
Seriously though, full respect to you @MattW in striving on improving this essential add-on. Exceptional work. :) (y)

*waves giant hand in the air*
Click to expand...
Agreed... and I'm waving both hands (and all the fingers ARE pointing outward from my palm :p)
 
I know this is probably asking alot and probably not something you may want to add @MattW but i thought I'd suggest it on the offchance. Since Showcase is one of the most popular add-ons, and because it's integral to part of tour sites An option one to be shown in the forumhome sideblock for New Showcase Items today: ? :) No worries if you don't since I know this is a 3rd party add-on and not exactly inline with xenforo core statistics.
 
You must log in or register to reply here.

Similar threads

Ozzy47
[OzzModz] Category Statistics
Replies
0
Views
120
Ozzy47
Ozzy47
S
  • Question Question
XF 2.2 AdminCP Statistics 0 for some days
Replies
0
Views
237
sHORTYWZ
S
Ozzy47
[OzzModz] Widget: DBTech Credits Statistics
Replies
0
Views
417
Ozzy47
Ozzy47
Osman
[XTR] Forum statistics
Replies
8
Views
1K
XOman
X
Jake B.
Fixed Unable to rebuild daily stats from CLI
Replies
1
Views
945
XF Bug Bot
XF Bug Bot
Top Bottom