Elxis CMS Forum

Extensions => Modules => Topic started by: ks-net on October 26, 2008, 19:03:35

Title: Mod_statistics sql error
Post by: ks-net on October 26, 2008, 19:03:35

in module statistics >>>

URI: index.php?option=com_content&task=view&id=49&Itemid=71
Message: Unknown column 'published' in 'where clause'
SELECT COUNT(id) FROM elx_content WHERE published='1'

 ???

Title: Re: Mod_statistics sql error
Post by: datahell on October 26, 2008, 20:35:42

This error existed in Elxis 2008.0, please update to 2008.1.

To fix this error in Elxis 2008.0, open modules/mod_stats.php
Go to line 48.
Change this:
   $database->setQuery("SELECT COUNT(id) FROM #__content WHERE published='1'");
to this:
   $database->setQuery("SELECT COUNT(id) FROM #__content WHERE state='1'");

Title: Re: Mod_statistics sql error
Post by: ks-net on October 26, 2008, 20:48:52

is a clean install of 2008.1

Elxis 2008.1 Stable rev2204 [ Nemesis ] 29-September-2008 21:16 GMT+2

Title: Re: Mod_statistics sql error
Post by: datahell on October 26, 2008, 21:10:37

Update to Elxis 2008.1 rev2218

Title: Re: Mod_statistics sql error
Post by: ks-net on October 26, 2008, 21:14:53

ok.. just waiting for your answer...
i had allready downloaded the patch.

one more .. in updiag  this patch from 2204 to 2008.1 rev2218 didn't appear.. is this because of minor updates in this patch?

Title: Re: Mod_statistics sql error
Post by: datahell on October 26, 2008, 21:22:47

We still haven released the updated hash files...