SQL error on adding smilies

[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()

[Brf]

It says your smiley's name is too long.

[mezerik]

Ahh, thanks for that, i'll have to rename them.

[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()

[Brf]

The URL is '475_narius_categorized_smilies_for_phpbb3_1.0.1/smilies/angry/banghead.gif' which is too long.

[rstynls9]

Ahhh, ok. Thanks!