mySQL error

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
psychoduck
Active Member
Posts: 7
Joined: 24. June 2010 23:14

mySQL error

Post 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.
User avatar

Marc
Dev
Posts: 2504
Joined: 17. July 2008 21:08
phpBB.de User: marc1706
phpBB.com User: Marc
Location: Clausthal-Zellerfeld / München
Contact:

Re: mySQL error

Post 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.

Topic author
psychoduck
Active Member
Posts: 7
Joined: 24. June 2010 23:14

Re: mySQL error

Post by psychoduck »

Thank you
Locked

Return to “board3 Portal 1.0.x - English Support”