Elxis CMS Forum

Support => General => Topic started by: xmanhattan on October 02, 2008, 11:07:43

Title: error shown using statistics mod
Post by: xmanhattan on October 02, 2008, 11:07:43

Hello all,

While testing I just activated the statistics mod and noticed this error:

mysql Error [1054] : EXECUTE
URI: index.php?option=com_frontpage&Itemid=10
Message: Unknown column 'published' in 'where clause'
SELECT COUNT(id) FROM elx_content WHERE published='1'

Title: Re: error shown using statistics mod
Post by: datahell on October 02, 2008, 13:19:31

Oooops! "published" should be replaced by "state".

File modules/mod_stats.php
line: 48
Replace this:
$database->setQuery("SELECT COUNT(id) FROM #__content WHERE published='1'");

with this:
$database->setQuery("SELECT COUNT(id) FROM #__content WHERE state='1'");

The above error only happens if you enable "siteinfo" in modules parameters.
Thanks for the bug report!