Page 1 of 1

mySQL error

Posted: 26. June 2010 14:34
by psychoduck
Your Portal Version: 1.0.5
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Basic Knowledge
Boardlink: http://www.pekinheaven.com/portal.php

What have you done before the problem was there?
It has always been there after I installed the portal

What have you already tryed to solve the problem?
Nothing

Description and Message
Each time someone clicks [more] to see more smilies this error comes up in the 'more smilies' box


Return to the index page
General Error
SQL ERROR [ mysqli ]

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 10

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()

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

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

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

Please notify the board administrator or webmaster: webmaster @ googlemail.com
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group


I'm thinking it may be I have made a mistake editing the required files when i installed the portal, but I have done them again and the error is still there. Unless I am not editing them properly.

Some advice would be very much appreciated, thank you.

Re: mySQL error

Posted: 26. June 2010 15:09
by Marc
Board3 Portal does not change those files so I doubt it has anything to do with the portal. You might want to ask on phpBB.com for that error.

Re: mySQL error

Posted: 26. June 2010 19:57
by psychoduck
Thank you