Hi Emil,


Which database are you using?

I was getting a similar error using MySQL and to fix it I had to prefix the value being compared with the collation like this:

INSERT INTO mp_ModuleDefinitionSettings
( ModuleDefID, SettingName, SettingValue, ControlType)

SELECT
ModuleDefID,
'BlogShowStatisticsSetting',
'true',
'CheckBox'
FROM mp_ModuleDefinitions
WHERE ControlSrc = _latin1 'Modules/BlogModule.ascx';

Notice the _latin1 just before the quoted value. You will see this in the MySQL upgrade script.

If you are using MySQL maybe remove the _latin1 or try putting the name of the collation you are using.

Hope it helps,

Joe

Hi Emil,

I guess there is some problem caused by different collations.

I would suggest, just remove the section of the upgrade script that does the inserts into mp_ModuleDefinitionSettings and just use the part that adds the new tables.

You can then add the new module settings for the blog manually under Admin > Feature Modules, edit the Blog module and add these 3 new settings.

BlogShowStatisticsSetting
true
CheckBox

BlogShowFeedLinksSetting
true
CheckBox

BlogShowAddFeedLinksSetting
true
CheckBox

Hope it helps,

Joe