Mod_statistics sql error

[ks-net]

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'

 

[datahell]

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'");

[ks-net]

is a clean install of 2008.1

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

[datahell]

Update to Elxis 2008.1 rev2218

[ks-net]

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?

[datahell]

We still haven released the updated hash files...