Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
Download Elxis CMS:
Elxis 5.5 Hermes
.
Home
Help
Login
Register
Elxis CMS Forum
»
Support
»
General
(Moderators:
Ivan Trebješanin
,
Farhad Sakhaei
) »
error shown using statistics mod
« previous
next »
Print
Pages: [
1
]
Author
Topic: error shown using statistics mod (Read 4282 times)
xmanhattan
Hero Member
Posts: 1235
If I'm still breathing, I'm doing something!
error shown using statistics mod
«
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'
Logged
Bournias.net
datahell
Elxis Team
Hero Member
Posts: 10356
Re: error shown using statistics mod
«
Reply #1 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!
«
Last Edit: October 02, 2008, 13:23:50 by datahell
»
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Support
»
General
(Moderators:
Ivan Trebješanin
,
Farhad Sakhaei
) »
error shown using statistics mod