Matthew Hawley
Well-known member
You need to select your xf database first
I did...
You need to select your xf database first
Now I get this when I try to run it.
#1091 - Can't DROP 'smilie_category_id'; check that column/key exists
ALTER TABLE xf_smilie
CHANGE smilie_category_id smilie_category_id_old INT UNSIGNED NOT NULL DEFAULT 0,
ADD smilie_category_id INT UNSIGNED NOT NULL DEFAULT 0,
ADD display_order INT UNSIGNED NOT NULL DEFAULT 1,
ADD display_in_editor TINYINT UNSIGNED NOT NULL DEFAULT 1,
ADD INDEX display_order (display_order)
So if I've uninstalled the add-on before upgrading to 1.3, I need to run:If you get this error
when upgrade to XF1.3 please run this query
and continue upgrade.
After upgrade has been successful, please upgrade new version in this post or uninstall my addon with the following instructions:
- Open library/Milano/SmileyManager/Install find
PHP:$data['xf_smilie'] = array( 'smilie_category_id' => 'INT(10) UNSIGNED DEFAULT 0', 'smilie_display_order' => 'INT(10) UNSIGNED DEFAULT 0' );
- Remove or comment this line
PHP:'smilie_category_id' => 'INT(10) UNSIGNED DEFAULT 0',
- Go to ACP and uninstall it
- If you don't follow these instructions and uninstall it immediately it will remove field smilie_category_id from xf_smile, so you have to add that field to xf_smilie again with this query
If you uninstalled the add-on before upgrading to 1.3, you don't have to run any querySo if I've uninstalled the add-on before upgrading to 1.3, I need to run:
ALTER TABLE xf_smilie
DROP smilie_category_id,
ADD smilie_category_id INT UNSIGNED NOT NULL DEFAULT 0,
ADD display_order INT UNSIGNED NOT NULL DEFAULT 1,
ADD display_in_editor TINYINT UNSIGNED NOT NULL DEFAULT 1,
ADD INDEX display_order (display_order)
AND
ALTER TABLE xf_smilie
ADD smilie_category_id INT UNSIGNED NOT NULL DEFAULT 0
?
Or I guess it should be reversed, run the second query first, the the first one (if needed).
Added support for XenForo 1.3.
So just to check: before updating my live boards to XenForo 1.3, I first update your addon with this version (to avoid the sql problems) ?Milano updated Smiley Manager with a new update entry:
New branch (2.x.x) for XF 1.3
Read the rest of this update entry...
So just to check: before updating my live boards to XenForo 1.3, I first update your addon with this version (to avoid the sql problems) ?
even turning it off? wont help?You should uninstall the old version before upgrading your board.
Turning it "off" won't help because there is a DB conflict between it and XenForo 1.3. That is the reason you have to uninstall it - to resolve the DB conflict that will break the upgrade. You may be able to export the specific tables for the categories and stuff before removing it and then install the new version and then import those tables.even turning it off? wont help?
i do like having all my settings and the way my smiles are categories does this mean i gota do them all over again?
Would it be possible for you to make a backup of the previous configuration: I had a lot of smilies on vB 3.x, that I have converted with an other smiley manager addon, then reconverted to your addon. So if I must do it again, that will be quite a painYou should uninstall the old version before upgrading your board.
Added support for importing from XF 1.2.x (require Smiley Manager 1.1.2b). It will automatic import smiley from a backup made by 1.1.2b during install/upgrade.
Smiley Manager 1.1.2b can be downloaded from this post.
No, 1.1.2b works only with xf 1.2.x, the whole point of 1.1.2b is create a smiley backup before your board moving to xf 1.3.x
Thank you a lot ! (May be you should add this entry to your addon's FAQ - how to update from XenForo 1.2 to 1.3).Smiley Manager 1.1.2b
This version will create a backup when uninstalling that later uses for import by version 2.0.1. Just upload and overwrite all files from the upload/library folder. No need to import the XML file.
Thank you a lot ! (May be you should add this entry to your addon's FAQ - how to update from XenForo 1.2 to 1.3).
How do I do this as I didnt uninstall the smiley manager before upgrading and am now getting the error others are reporting. Apologies guys I really am a beginner.
RUN QUERY
ALTER TABLE xf_smilie
DROP smilie_category_id,
ADD smilie_category_id INT UNSIGNED NOT NULL DEFAULT 0,
ADD display_order INT UNSIGNED NOT NULL DEFAULT 1,
ADD display_in_editor TINYINT UNSIGNED NOT NULL DEFAULT 1,
ADD INDEX display_order (display_order)
We use essential cookies to make this site work, and optional cookies to enhance your experience.