Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
EDC:
Download extensions for Elxis CMS
.
Home
Help
Login
Register
Elxis CMS Forum
»
Extensions
»
Components
»
Bubbles: GROUP BY error
« previous
next »
Print
Pages: [
1
]
Author
Topic: Bubbles: GROUP BY error (Read 3440 times)
forgetms
Newbie
Posts: 42
Bubbles: GROUP BY error
«
on:
March 10, 2010, 03:20:12 »
ERROR: column "u.email" must appear in the GROUP BY clause or be used in an aggregate function at character 8
STATEMENT: SELECT u.email FROM users u
LEFT JOIN bubbles b ON b.uid=u.id
WHERE u.block='0' AND u.id <> '0'
AND ((b.parent='52') OR (b.id = '52'))
AND b.uid <> '0'
GROUP BY u.id
Does replacing "GROUP BY" with "ORDER BY" at line 414 for bubbles.php fix the problem?
Regards,
CN
Logged
datahell
Elxis Team
Hero Member
Posts: 10353
Re: Bubbles: GROUP BY error
«
Reply #1 on:
March 10, 2010, 09:43:28 »
Add u.email In the group by clause:
GROUP BY u.id, u.email
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Extensions
»
Components
»
Bubbles: GROUP BY error