SQL error on adding smilies

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
mezerik
Registered User
Posts: 21
Joined: Wed Feb 06, 2008 4:21 pm

SQL error on adding smilies

Post by mezerik »

When I manually add smilies using the admin control panel i get this error. Any ideas what's wrong?

Code: Select all

SQL ERROR [ mysql4 ]

Data too long for column 'smiley_url' at row 1 [1406]

SQL

INSERT INTO phpbb_smilies (smiley_url, smiley_width, smiley_height, display_on_posting, emotion, code, smiley_order) VALUES ('round the house smilies/INCleanLaundrymaschine3HL1.gif', 98, 85, 0, ':washer:', ':washer:', 31)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/acp/acp_icons.php
LINE: 414
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_icons->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52228
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: SQL error on adding smilies

Post by Brf »

It says your smiley's name is too long.
mezerik
Registered User
Posts: 21
Joined: Wed Feb 06, 2008 4:21 pm

Re: SQL error on adding smilies

Post by mezerik »

Ahh, thanks for that, i'll have to rename them.
User avatar
rstynls9
Registered User
Posts: 21
Joined: Thu Sep 25, 2008 3:51 pm

Re: SQL error on adding smilies

Post by rstynls9 »

I get the same error, but I'm only trying to add one smiley and the code for it is only 3 characters. I also tried submitting multiple smilies, but same error. Any ideas?

Code: Select all

SQL ERROR [ mysql4 ]

Data too long for column 'smiley_url' at row 1 [1406]

SQL

INSERT INTO phpbb_smilies (smiley_url, smiley_width, smiley_height, display_on_posting, emotion, code, smiley_order) VALUES ('475_narius_categorized_smilies_for_phpbb3_1.0.1/smilies/angry/banghead.gif', 25, 20, 1, 'BangHead', ':b:', 1)

BACKTRACE

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_icons.php
LINE: 479
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_icons->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52228
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: SQL error on adding smilies

Post by Brf »

The URL is '475_narius_categorized_smilies_for_phpbb3_1.0.1/smilies/angry/banghead.gif' which is too long.
User avatar
rstynls9
Registered User
Posts: 21
Joined: Thu Sep 25, 2008 3:51 pm

Re: SQL error on adding smilies

Post by rstynls9 »

Ahhh, ok. Thanks!
Locked

Return to “[3.0.x] Support Forum”