LG TinyMCE Bug with MSM
Development and Programming
Hello all,
I am using EE 1.6.4 to manage 16 separate sites for a client and I just updated to LG TinyMCE 1.3.2. I get this error message immediately when I enable the extension.
Notice: Undefined index: 17 in /home/.synergy/blahblah/system/extensions/ext.lg_tinymce.php on line 1106
I figured out that the reason for this is that by default the config for tinymce in the extension is blank.
Soooo I went through 12 or 13 of the sites individually setting up the config options, but on about the 13th or 14th site when I hit submit it appears not to save the config options and erases all the config options for all the other sites! It has done this now twice as I thought the first time I might have done something wrong.
Is this a bug in the extension? Does anyone have this extension up and running with more than 15 sites on a MSM setup?
Thanks in advance
Michael
Hmmmm 15 sites… that’s quite a lot. My first guess is that the data in the DB is being truncated to fit the size of the column. I just woke up and have to go out all day (saturday) so I’ll have to take a look later.
If you don’t mind getting your hands dirty try changing the DB column type and increasing its length.
Thanks swany10012 - I was getting the same error message, but you’ve fixed it for me! Sorry I can’t help with your problem though. I’m only running 3 sites using MSM… not 16!
So did increasing the db column length/type fix the issue?
not yet. The system is live and I don’t want to potentially break the whole works. I will try to do this either late this evening or in the morning (sunday) hopefully limiting the amount of people affected if it breaks something. I’ll let you know. Thanks Leevi.
Hey Leevi,
I just changed the type of the “settings” column in the extensions table to a blob and then tried to update the sites. I got to 15 and then it glitched and erased all the settings for the extension on all 16 sites. Any thoughts?
Thanks
Michael
I downgraded to version 1.2.1 of the extension and it is working like a champ. I really would like to be able to use the functionality of customizing tinymce for each site. Please let me know when you figure out the glitch. If I can help let me know!
Thanks for all your hard work Leevi!
Michael
Hey Michael,
I currently have the settings column set to type text as blob is meant to be used for binary data. However they store both the same length so you might need to try mediumtext or even longtext col types. I’m not sure what if any affect this would have on optimisation.
Cheers Leevi
Changing settings to LONGTEXT in table exp_extensions worked for us (4 sites) version 1.3.3
I ran into the same problem. I can confirm that following settings work if MSM > 2 Sites.
Change Settings Field Type to Longtext in the Table exp_extensions
ALTER TABLE 'exp_extensions' CHANGE 'settings' 'settings' LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULLThen disable and re-enable the extension.
Path for main site: /scripts/tinymce/jscripts/tiny_mce/tiny_mce.js
Path for Site 2, Site 3, Site 4… http://www.mainsite.com/scripts/tinymce/jscripts/tiny_mce/tiny_mce.js