HOWTO: Enable/Disable HTML Email Processing in BES 4.1 SP5 - Page 3 - BlackBerryForums.com : Your Number One BlackBerry Community

vhato · 07-17-2008, 10:53 AM

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 · 07-17-2008, 10:59 AM

This thread Stickied now...

SanaTizer · **OS:** 4.6.0.216

Wirelessly posted

Quote:

Originally Posted by Domel

Quote:

Originally Posted by SanaTizer

I'm stuck here trying to get this to work. I've got a BES box with 4.1.5.24 with exchange 03 environment and a SQL 05 DB box. Blackberry deivce is 8310 running 4.5.0.52(75)

The BBupdate through me errors so I opened the DB and modified the dbo.ServerConfig and dbo.UserConfig - RichContent tables and the BESOnlyMessages to ((1)) from ((0)). Restarted the SQL server and the BES server, re-pushed the service books from the BES and I still do not see the enable html or the BESOnly icon.

Any ideas on what's wrong with my setup?

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 · 07-17-2008, 03:03 PM

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 · **OS:** 4.6.0.216

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

SanaTizer · **OS:** 4.6.0.216

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 · **OS:** 4.6.0.216

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 · **OS:** 4.6.0.216

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

skooter_15 · 07-17-2008, 09:44 PM

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

SanaTizer · **OS:** 4.6.0.216

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

skooter_15 · 07-18-2008, 01:08 AM

Quote:

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 · 07-18-2008, 08:34 AM

Should we disable html prior to upgrading to SP6?

vhato · 07-18-2008, 11:30 AM

Quote:

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 · **OS:** 4.6.0.219

Quote:

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 · 07-20-2008, 09:22 AM

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

jibi · **OS:** 4.6.1.174

Unsticking. Please upgrade to SP6 for this functionality.

murpheous · **OS:** 4.5.0.55

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 · 08-12-2008, 02:02 PM

Does this work on the current version of BES Express?

Domel · **OS:** 4.6.0.219

Quote:

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 · 08-26-2008, 07:12 AM

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.

CCK01 · 09-16-2008, 10:05 PM

So, do it work with Novell Groupwise BES?

TruBlu01 · 10-13-2008, 04:56 PM

I have a BB Curve with 4.3 on it. When I upgrade the BES to 4.1.6 will the Curve accept HTML email?

abrownusa · 12-09-2008, 04:00 PM

Quote:

Originally Posted by Domel

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

Can you explain how you got this to work via express? Ive added the columns etc nchar etc. Enabled everything with 1 etc, and still i get nothing. Yes i am running 4.5

knottyrope · 12-09-2008, 04:15 PM

Quote:

Originally Posted by TruBlu01

I have a BB Curve with 4.3 on it. When I upgrade the BES to 4.1.6 will the Curve accept HTML email?

No it will need OS 4.5

jibi · **OS:** 4.6.1.174

Quote:

Originally Posted by abrownusa

Can you explain how you got this to work via express? Ive added the columns etc nchar etc. Enabled everything with 1 etc, and still i get nothing. Yes i am running 4.5

This thread is out of date. To get it working with BES Express (not BPS), upgrade to SP6. You don't need to make any changes to the database, as these options are exposed in the GUI.

jibi · **OS:** 4.6.1.174

Can someone please close this thread? It is no longer needed. Thanks.