[vhato]

FYI: Desktop Manager 4.2.2 changes the two tables in SQL relating to User HTML access to 0 when a user does a manual sync. Upgraded to 4.5, and HTML E-mail works fine.

[JSanders]

This thread Stickied now...

[SanaTizer]

Wirelessly posted

Originally Posted by Domel

Have you performed hard reset of your BB?

I deleted the device from the BES and wiped it. Readded to BES and activated, still no luck. Am I suppose to modify something elese? From what I saw in the SQL scripts the only thing they do is modify the zeros to ones.

[vhato]

There are two tables containing two fields to be changed to 1's. A total of four fields.

Are you editing both ServerConfig and UserConfig tables?

[SanaTizer]

Yes I have made the change to all 4 tables (2 in user and 2 in server config).

[SanaTizer]

The funny thing is the SQL script completes successfully on the disable but fails on the enable script.

I get this from the Management console:

Msg 512, Level 16, State 1, Procedure ServerConfigSaveCapTrigger, Line 29
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

The exact error steveb_uk got in post #55 in this thread. Manually editing didn't work.

[SanaTizer]

Whew... I found it... the script was failing because the SQL is management for multiple BES servers. It was trying to update the tables for all of the servers. The editing of the tables worked when you OPEN the table instead of modify the default values. Which is what I was trying to do manually. oh well... wiping and re-provisioning on the BES now.. we will see what happens this time.

[SanaTizer]

Whoo Hooo.. After fighting with this simple hack... Finally I've got the HTML on the BES!!

[skooter_15]

BES 4.1.6 which has just been released enables HTML support by default.

[SanaTizer]

Wouldn't you know it as soon as I get it to work... Oh well better to be "Official" anyway.

[skooter_15]

Originally Posted by SanaTizer

Wouldn't you know it as soon as I get it to work... Oh well better to be "Official" anyway.

Always the way

[BrooklynzFinest]

Should we disable html prior to upgrading to SP6?

[vhato]

Originally Posted by BrooklynzFinest

Should we disable html prior to upgrading to SP6?

I thought about that, but upgraded to SP6 anyway. So far no problems!!!

[Domel]

Originally Posted by vhato

I thought about that, but upgraded to SP6 anyway. So far no problems!!!

Same on my BES. No need to remove hack.

[Raiden]

Can we get a step by step for SQL2000 please??

[jibi]

Unsticking. Please upgrade to SP6 for this functionality.

[murpheous]

I have upgraded to sp6 on my domino bes, but html email still does not work. I enabled it on my device as well. Am I missing something?

[jediman]

Does this work on the current version of BES Express?

[Domel]

Originally Posted by jediman

Does this work on the current version of BES Express?

I don't know what is current version of BES Express but on my BES Express it works with all paches/service packs applied.

[Sam_Innes]

I have installed 4.1.6, however most of our devices are on older firmware and we are not in a position to upgrade everyone, I've recieved a few complaints from people that html e-mails are now unreadable because the BB cannot interpret them. I have disasbled Rich content in the poliy and in the SQL database to be sure, however I think the links are still ruining e-mails.

Could someone please tell me hopw HTML links should look on the BB when Rich-content is switched off? Is there an easy test e-mail I could send to check this. Sorry to be so ignorant, but I never really checked how they were formatted before we had the problem.