What version of phpBB are you using? phpBB 3.0.7-PL1
What is your board's URL? http://www.ron2k.za.net/forum/
Who do you host your board with? No answer given
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Update from a previous version of phpBB3
Do you have any MODs installed? No
Is registration required to reproduce this issue? Yes
What version of phpBB3 did you update from? phpBB 3.0.6
What styles do you currently have installed? starcraft
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 4
What is your level of experience? Comfortable with PHP and phpBB
What username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
When did your problem begin? Noticed it this morning, but in all likelihood, it's been around for a while.
Please describe your problem.
Noticed that when anyone clicks on "View more smilies" on the posting page, the board breaks with the following error:
Code: Select all
General Error SQL ERROR [ mysql4 ] Invalid use of group function  SQL SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height FROM phpbb3_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()
Currently no MODs installed - I used to have a quick reply MOD and RSS MOD installed (can't remember which one now), which I removed in favour of the built-in features when 3.0.6 was released.
Database schema of phpbb3_smilies looks like this:
Code: Select all
# # phpBB Backup Script # Dump of tables for phpbb3_ # DATE : 16-11-2010 07:33:43 GMT # # Table: phpbb3_smilies DROP TABLE IF EXISTS phpbb3_smilies; CREATE TABLE `phpbb3_smilies` ( `smiley_id` mediumint(8) unsigned NOT NULL auto_increment, `code` varchar(50) collate utf8_bin NOT NULL default '', `emotion` varchar(50) collate utf8_bin NOT NULL default '', `smiley_url` varchar(50) collate utf8_bin NOT NULL default '', `smiley_width` smallint(4) unsigned NOT NULL default '0', `smiley_height` smallint(4) unsigned NOT NULL default '0', `smiley_order` mediumint(8) unsigned NOT NULL default '0', `display_on_posting` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`smiley_id`), KEY `display_on_post` (`display_on_posting`) ) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Generated by SRT Generator ($Rev: 4502 $)