"View more smilies"

Are you a registered user having trouble using the forums? Come here to ask for support, especially if something doesn't work as expected.
Forum rules
NEW USERS HAVE TO WAIT FOR THEIR FIRST POSTS TO BE APPROVED BY AN ADMINISTRATOR. Rules | Essential Information | FAQ | Support | Twitter

"View more smilies"

Postby snail » Fri Aug 06, 2010 4:58 pm

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?
These mountains that you are carrying, you were only supposed to climb.

Najwa Zebian
User avatar
snail
Site Admin
Site Admin
 
Posts: 4343
Joined: Sun Sep 02, 2007 8:59 pm
Location: Your guess is as good as mine.
Gender: Female

Re: "View more smilies"

Postby Jo » Fri Aug 06, 2010 8:50 pm

Yes, noticed that a couple of days ago. Hoping to investigate this weekend.
User avatar
Jo
Site Owner
Site Owner
 
Posts: 1994
Joined: Tue Oct 16, 2001 1:00 am
Location: East Lancashire, UK
Gender: Female

Re: "View more smilies"

Postby peecee » Sat Aug 07, 2010 12:16 am

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()
Shine your light and let the whole world see.
User avatar
peecee
Site Admin
Site Admin
 
Posts: 5649
Joined: Fri Dec 17, 2004 1:24 am
Location: hard to say
Gender: Female

Re: "View more smilies"

Postby snail » Sat Aug 07, 2010 12:22 am

No, Pee - it seems that superior version was reserved just for you! :-s
These mountains that you are carrying, you were only supposed to climb.

Najwa Zebian
User avatar
snail
Site Admin
Site Admin
 
Posts: 4343
Joined: Sun Sep 02, 2007 8:59 pm
Location: Your guess is as good as mine.
Gender: Female

Re: "View more smilies"

Postby peecee » Sat Aug 07, 2010 1:04 am

I'm going to take it to Boots and have it made up... :lol:
Shine your light and let the whole world see.
User avatar
peecee
Site Admin
Site Admin
 
Posts: 5649
Joined: Fri Dec 17, 2004 1:24 am
Location: hard to say
Gender: Female

Re: "View more smilies"

Postby Jo » Wed Aug 11, 2010 8:43 pm

This is a known bug but have applied the fix - should be OK for now \:D/
:rainbow: :bounce:
User avatar
Jo
Site Owner
Site Owner
 
Posts: 1994
Joined: Tue Oct 16, 2001 1:00 am
Location: East Lancashire, UK
Gender: Female

Re: "View more smilies"

Postby snail » Wed Aug 11, 2010 9:32 pm

Thanks, Jo. :biggrin:
These mountains that you are carrying, you were only supposed to climb.

Najwa Zebian
User avatar
snail
Site Admin
Site Admin
 
Posts: 4343
Joined: Sun Sep 02, 2007 8:59 pm
Location: Your guess is as good as mine.
Gender: Female


Return to Forum Support

Who is online

Users browsing this forum: No registered users and 0 guests

cron