microsoftdotcom Posted December 30, 2015 Share Posted December 30, 2015 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. Link to comment Share on other sites More sharing options...
Adlago Posted December 30, 2015 Share Posted December 30, 2015 Link to comment Share on other sites More sharing options...
microsoftdotcom Posted December 30, 2015 Author Share Posted December 30, 2015 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. Link to comment Share on other sites More sharing options...
Adlago Posted December 30, 2015 Share Posted December 30, 2015 Check the database table 'core_emoticons'. Is there content? Link to comment Share on other sites More sharing options...
microsoftdotcom Posted December 30, 2015 Author Share Posted December 30, 2015 Any tips how the query should look like?. No idea how to check the content Link to comment Share on other sites More sharing options...
Adlago Posted December 30, 2015 Share Posted December 30, 2015 1 hour ago, microsoftdotcom said: Any tips how the query should look like?. No idea how to check the content SELECT * FROM core_emoticons Link to comment Share on other sites More sharing options...
microsoftdotcom Posted December 30, 2015 Author Share Posted December 30, 2015 No results were given back from that query. Whats the next step? Link to comment Share on other sites More sharing options...
MADMAN32395 Posted December 31, 2015 Share Posted December 31, 2015 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 Link to comment Share on other sites More sharing options...
microsoftdotcom Posted December 31, 2015 Author Share Posted December 31, 2015 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? 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 Link to comment Share on other sites More sharing options...
Adlago Posted December 31, 2015 Share Posted December 31, 2015 @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. Link to comment Share on other sites More sharing options...
microsoftdotcom Posted December 31, 2015 Author Share Posted December 31, 2015 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. 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. Link to comment Share on other sites More sharing options...
Adlago Posted December 31, 2015 Share Posted December 31, 2015 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 Link to comment Share on other sites More sharing options...
microsoftdotcom Posted December 31, 2015 Author Share Posted December 31, 2015 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 Link to comment Share on other sites More sharing options...
Adlago Posted December 31, 2015 Share Posted December 31, 2015 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" ); Link to comment Share on other sites More sharing options...
microsoftdotcom Posted December 31, 2015 Author Share Posted December 31, 2015 Unknown column 'width' in 'field list' Link to comment Share on other sites More sharing options...
Adlago Posted December 31, 2015 Share Posted December 31, 2015 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"); Link to comment Share on other sites More sharing options...
microsoftdotcom Posted December 31, 2015 Author Share Posted December 31, 2015 Best newyears gift ever problem solved...I can new groups, add emoticons...everything works again. You should be mentioned in the hall of fame my friend. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.