Page 1 of 1

"View more smilies"

PostPosted: Fri Aug 06, 2010 4:58 pm
by snail
Ever since the site upgrade the other day, this link doesn't work for me. When I click it I get this message:

General Error
SQL ERROR [ mysql4 ]

Invalid use of group function [1111]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


Is anyone else experiencing this?

Re: "View more smilies"

PostPosted: Fri Aug 06, 2010 8:50 pm
by Jo
Yes, noticed that a couple of days ago. Hoping to investigate this weekend.

Re: "View more smilies"

PostPosted: Sat Aug 07, 2010 12:16 am
by peecee
Sanil, did you get War & Peace too? :-s Like this;

General Error
SQL ERROR [ mysql4 ]

Invalid use of group function [1111]

SQL

SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height FROM phpbb_smilies GROUP BY smiley_url, smiley_width, smiley_height ORDER BY MIN(smiley_order) LIMIT 50

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/functions_posting.php
LINE: 92
CALL: dbal->sql_query_limit()

FILE: posting.php
LINE: 126
CALL: generate_smilies()

Re: "View more smilies"

PostPosted: Sat Aug 07, 2010 12:22 am
by snail
No, Pee - it seems that superior version was reserved just for you! :-s

Re: "View more smilies"

PostPosted: Sat Aug 07, 2010 1:04 am
by peecee
I'm going to take it to Boots and have it made up... :lol:

Re: "View more smilies"

PostPosted: Wed Aug 11, 2010 8:43 pm
by Jo
This is a known bug but have applied the fix - should be OK for now \:D/
:rainbow: :bounce:

Re: "View more smilies"

PostPosted: Wed Aug 11, 2010 9:32 pm
by snail
Thanks, Jo. :biggrin: