Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
IOS Hotels
and
IOS Rentals
online booking systems for Elxis CMS.
Home
Help
Login
Register
Elxis CMS Forum
»
Extensions
»
Modules
»
Mod_statistics sql error
« previous
next »
Print
Pages: [
1
]
Author
Topic: Mod_statistics sql error (Read 7283 times)
ks-net
Elxis Community
Hero Member
Posts: 2072
Kostas Stathopoulos
Mod_statistics sql error
«
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'
Logged
ks-net.gr
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Mod_statistics sql error
«
Reply #1 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'");
«
Last Edit: October 26, 2008, 20:37:21 by datahell
»
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
ks-net
Elxis Community
Hero Member
Posts: 2072
Kostas Stathopoulos
Re: Mod_statistics sql error
«
Reply #2 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
Logged
ks-net.gr
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Mod_statistics sql error
«
Reply #3 on:
October 26, 2008, 21:10:37 »
Update to Elxis 2008.1 rev2218
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
ks-net
Elxis Community
Hero Member
Posts: 2072
Kostas Stathopoulos
Re: Mod_statistics sql error
«
Reply #4 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?
Logged
ks-net.gr
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Mod_statistics sql error
«
Reply #5 on:
October 26, 2008, 21:22:47 »
We still haven released the updated hash files...
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Extensions
»
Modules
»
Mod_statistics sql error