Jump to content

help! Deleted the default emoticon group

Featured Replies

Posted

I deleted the default emoticon group in adminCP, because I wanted to replace some emoticons. 

After deleting it, I cant create new groups. 

This is what I do: click on 'Add emoticons' > select emoticon > give grp a name (e.g. Other) > press save

Nothing happens after pressing save.

Can someone pls help me to restore the default group? I think deleting the default group caused some internal error somewhere.

inst2.thumb.png.f5f4006eefc2465fc716c27b

  • Author

your post doesnt really answer my question @Adlago

1. The group 'default' was deleted in adminCP.

2. I can only choose 'Create new group'

3. Adding new emoticons is not possible, cause the save button doesnt do anything anymore. (both save buttons dont work. The one on your screenshot and the other one when uploading the emoticons.)

Basically I cant make groups, so whatever I add in manually in the emoticon map wont work, cause IPB needs a group to relate to I think.

What im hoping to achieve is to add the 'default' group back in the database and hopefully solve the issue that way...or find some other solution.

Im not really in the mood to reinstall ipb or upgrading it, with the chance that all my custom changes will be lost. Im currently on ipb ver. 4.0.13.

Check the database table 'core_emoticons'. Is there content?

  • Author

Any tips how the query should look like?. No idea how to check the content

1 hour ago, microsoftdotcom said:

Any tips how the query should look like?. No idea how to check the content

sql.thumb.png.fdc82e0817be1953bcafd1a0a7

core.thumb.png.742be57bb768fc65503c7841d

 

SELECT * FROM core_emoticons

 

  • Author

No results were given back from that query. Whats the next step?

4 hours ago, microsoftdotcom said:

No results were given back from that query. Whats the next step?

do you use a prefix on your tables? <SOMETHING>_core_emoticons 

  • Author

I've added two screenshots of what I see in adminCP.

What i meant with no results given back was that core_emoticons was empty.

 If the emoticon groups (e.g. Default) are stored in that table, can't we just write a query that adds them back and do some testing from there?

Screen Shot 2015-12-31 at 10.24.22.png

Screen Shot 2015-12-31 at 10.25.22.png

Btw...this is what I see when I open the emoticon menu.

You can delete groups by pressing a small button on the right side of the group...cant show it anymore since I deleted mine :(

Screen Shot 2015-12-31 at 10.32.10.png

@microsoftdotcom

I have an idea. I will try to create sql command to restore the first emoticon.

For this idea you need login FTP uploads - furst your monthly folder.Find full name dry.png. 

Will resemble -> 'dry.png.391a7d050bfd50006f757ad4a43f9611.png '.

Copy and paste here the name. I'll need a folder name, for example 'monthly_2015_01'
Later I will put here sql command.

  • Author

There was no dry.png in my monthly folders. I checked all of them but the file was not found. So I searched for the icon on google, found it and added it manually with FTP.

I added dry.png (that is the exact name) manually to the folder monthly_2015_12

I also found out that when I press the save button the emoticon (see screenshot) gets added to the folder /public_html/uploads/emoticons (see screenshot).

please note that the save button doesnt work when I try to add an emoticon. It shows a loading window and returns to the same save window, not creating the group.

1.png

This is how /public_html/uploads/emoticons looks like. I'm not sure if the emoticon should be in a subfolder/group (e.g. 'myEmoticons' like in the screenshot above.) It's not from what I see in the main emoticons folder.

2.png

Change the name of your image in the folder monthly_2015_12 as I pointed out.

Then run the command in SQL Toolbox. /attachment file/

emo.zip

  • Author

Attachment file must be new option for updated versions of IPB..I dont see it in my SQL toolbox. I tried adding the query manually (SQL toolbox > entered query in textarea)

INSERT INTO core_emoticons (id,typed,image,clickable,emo_set,emo_position,emo_set_position,image_2x,width,height)
VALUES ("1",":dry:","monthly_2015_12/dry.png.391a7d050bfd50006f757ad4a43f9611.png","1","9c7d1c2870df43d3b559b7f60cb3fddf","1","1","","0","0" );

But it returns an error (retina emoticons where added in ver.4.1. Im running ver.4.0.13, so I assume this column doesnt not exist in my version  ): 

Unknown column 'image_2x' in 'field list'

deleting image_2x from the query returns a different error:

Column count doesn't match value count at row 1

 

Try this

Quote

INSERT INTO core_emoticons (id,typed,image,clickable,emo_set,emo_position,emo_set_position,width,height)
VALUES ("1",":dry:","monthly_2015_12/dry.png.391a7d050bfd50006f757ad4a43f9611.png","1","9c7d1c2870df43d3b559b7f60cb3fddf","1","1","0","0" );

 

  • Author

Unknown column 'width' in 'field list'

:(

1 minute ago, microsoftdotcom said:

Unknown column 'width' in 'field list'

:(

 

Try this

Quote

INSERT INTO core_emoticons (id,typed,image,clickable,emo_set,emo_position,emo_set_position)
VALUES ("1",":dry:","monthly_2015_12/dry.png.391a7d050bfd50006f757ad4a43f9611.png","1","9c7d1c2870df43d3b559b7f60cb3fddf","1","1");

 

  • Author

Best newyears gift ever :thumbsup:

problem solved...I can new groups, add emoticons...everything works again. You should be mentioned in the hall of fame my friend.

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.