MyBB Community Forums

Well...I added a ton of smilies and now my posting box (the one you type in when you're making a new topic.) is very messed up due to the amount of smilies....so....I went into my database and deleted the smilies table

Now, when I go to the smilies thing under configuration in my ACP, I get this error: MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'lemurisl_mybb1.smilies' doesn't exist
Query:
SELECT * FROM smilies ORDER BY disporder LIMIT 0, 20

How could I fix this?


Forum URL: http://teamminecraft.com/forums/
Test Account (go make a new topic to see my smilies problem):
Username: user
Password: user123

Thanks.

Why on earth would you delete the smilies table because you added too many...??

Run this in phpMyAdmin:

CREATE TABLE IF NOT EXISTS `smilies` (
  `sid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) NOT NULL DEFAULT '',
  `find` varchar(120) NOT NULL DEFAULT '',
  `image` varchar(220) NOT NULL DEFAULT '',
  `disporder` smallint(5) unsigned NOT NULL DEFAULT '0',
  `showclickable` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

INSERT INTO `smilies` (`sid`, `name`, `find`, `image`, `disporder`, `showclickable`) VALUES
(1, 'Smile', ':)', 'images/smilies/smile.gif', 1, 1),
(2, 'Wink', ';)', 'images/smilies/wink.gif', 2, 1),
(3, 'Cool', ':cool:', 'images/smilies/cool.gif', 3, 1),
(4, 'Big Grin', ':D', 'images/smilies/biggrin.gif', 4, 1),
(5, 'Tongue', ':P', 'images/smilies/tongue.gif', 5, 1),
(6, 'Rolleyes', ':rolleyes:', 'images/smilies/rolleyes.gif', 6, 1),
(7, 'Shy', ':shy:', 'images/smilies/shy.gif', 7, 1),
(8, 'Sad', ':(', 'images/smilies/sad.gif', 8, 1),
(9, 'At', ':at:', 'images/smilies/at.gif', 9, 0),
(10, 'Angel', ':angel:', 'images/smilies/angel.gif', 0, 1),
(11, 'Angry', ':@', 'images/smilies/angry.gif', 0, 1),
(12, 'Blush', ':blush:', 'images/smilies/blush.gif', 0, 1),
(13, 'Confused', ':s', 'images/smilies/confused.gif', 0, 1),
(14, 'Dodgy', ':dodgy:', 'images/smilies/dodgy.gif', 0, 1),
(15, 'Exclamation', ':exclamation:', 'images/smilies/exclamation.gif', 0, 1),
(16, 'Heart', ':heart:', 'images/smilies/heart.gif', 0, 1),
(17, 'Huh', ':huh:', 'images/smilies/huh.gif', 0, 1),
(18, 'Idea', ':idea:', 'images/smilies/lightbulb.gif', 0, 1),
(19, 'Sleepy', ':sleepy:', 'images/smilies/sleepy.gif', 0, 1),
(20, 'Undecided', ':-/', 'images/smilies/undecided.gif', 0, 1);

There were too many to manually delete

Now, it's still not fixed

My old ones still show, just no image in the smiley thing beside the typing box when making a new topic....see the screenshot.

Also, the typing box thing is still messed up
http://gyazo.com/057cc1517165f1d84003fbbee04e2b3b.png

---

Also, I still get this in the ACP:
http://gyazo.com/a506d04763d4fb2b1dbca2ef2196c317.png

I've tweaked the queries above a bit, run them again, didn't realise that you have no table prefix.

Thanks Works fine now, other than in the topic view...the typing box is messed up and the smilies haven't changed
http://gyazo.com/4898c8409d0048bd29ddfcb330112e72.png

Go to ACP > Tools & Maintenance > Cache Manager > smilies > Rebuild Cache, see if that works.

Yay! That worked...but the typing box is still messed up
http://gyazo.com/06702d144998335a04dc6757ebeba687.png

That's an error in the css.
Best bet is to reinstall the theme.

I'm not sure about reinstalling - and I think there is a way to fix it, just can't remember what I was told...

:s If you have any ideas, post them here please I really need to fix it