[Eric]

Originally Posted by Megatr0n

Great upgrade but why do the user's personal smilies now appear under the custom row of smilies?

Any way of avoiding this?

Screenshot?

As the changelog states, when parsing/pulling smilies, it no longer checks by userid. So it now parses smilies that have been quoted/etc. One downside to this (if you see it that way), is that if another user knows the smiley code, they can use the smiley (which IMHO, should be the way this mod works - why not let a user add a smilie that they can use, but others can as well if they like it? )

Originally Posted by choccyclaire

I receive this db error when trying to upgrade. (I have uploaded and overwritten all other files)

Database error in vBulletin 3.8.4:

Invalid SQL:
ALTER TABLE mysmiliesvb ADD KEY userid (userid);

MySQL Error   : Duplicate key name 'userid'
Error Number  : 1061
Request Date  : Friday, January 15th 2010 @ 07:26:08 PM
Error Date    : Friday, January 15th 2010 @ 07:26:08 PM
Script        : http://www.xxx/admincp/plugin.php?do=productimport
Referrer      : http://www.xxx/admincp/plugin.php?do=productadd
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.87-community-log

What version of the mod were you using before the upgrade? The only reason that code should run during install is if you're using a version prior to 3.8.001, in which case, there should not be a KEY on userid for the mysmiliesvb table.