"View more smilies" on posting page - throws SQL error

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Ron2K
Registered User
Posts: 247
Joined: Sun May 25, 2003 6:10 pm
Location: Cape Town, South Africa
Name: Kieron Thwaites
Contact:

"View more smilies" on posting page - throws SQL error

Post by Ron2K » Tue Nov 16, 2010 7:36 am

Support Request Template
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 [1111]

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()
All files are vanilla 3.0.7-PL1. I did attempt clearing the cache and retrying prior to reporting this.

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;
Not quite sure what I've managed to break - would welcome any assistance in fixing it. ;)

Generated by SRT Generator ($Rev: 4502 $)

User avatar
AmigoJack
Registered User
Posts: 5332
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: "View more smilies" on posting page - throws SQL error

Post by AmigoJack » Tue Nov 16, 2010 7:47 am

The worst thing about censorship is ███████████

Ron2K
Registered User
Posts: 247
Joined: Sun May 25, 2003 6:10 pm
Location: Cape Town, South Africa
Name: Kieron Thwaites
Contact:

Re: "View more smilies" on posting page - throws SQL error

Post by Ron2K » Tue Nov 16, 2010 7:58 am

Cool, thanks for the help - that fix in the thread you linked to sorted me out. :D

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: "View more smilies" on posting page - throws SQL error

Post by karlsemple » Tue Nov 16, 2010 8:02 am

Yes this was a bug introduced by a fix for another bug - bug ticket - http://www.phpbb.com/bugs/phpbb3/ticket ... t_id=54945 and another topic here on phpBB discussing it http://www.phpbb.com/community/viewtopi ... &t=2006765 :)
Image

Locked

Return to “[3.0.x] Support Forum”

Who is online

Users browsing this forum: No registered users and 73 guests