mySQL error
Posted: 26. June 2010 14:34
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
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.
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.