[Sith_Apprentice]

well yeah for auto more and auto download, but the bare bones i would assume would be several times the 2kbs of the plain text version.

[Dookie]

Originally Posted by Sith_Apprentice

well yeah for auto more and auto download, but the bare bones i would assume would be several times the 2kbs of the plain text version.

Hm, this could be quite important as my users travels a LOT. I'm gonna install MiniMonitor to figure out how much HTML takes and then compare it to plain text.

[BBAdmin]

HTML is going to consume more 'ones and zeros' but that of course depends on how much HTML you got coming in.

[cschrage]

I have yet to get this feature enabled.

D:\>BBDBUpdate.exe -db BESMgmt -n SQL1 -input EnableRichContent.sql

Below is part of my log ouput.

[20000] (04/28 09:50:59.469):{0x1F64} Connect to database server: SQL1
[20000] (04/28 09:50:59.469):{0x1F64} Database name: BESMgmt
[40000] (04/28 09:50:59.469):{0x1F64} Authentication Type: Windows Authentication
[20000] (04/28 09:50:59.579):{0x1F64} Database connection opened!
[20000] (04/28 09:50:59.579):{0x1F64} Reading input file: EnableRichContent.sql
[40000] (04/28 09:50:59.579):{0x1F64} ----------------------------------------------------------------------------
[40000] (04/28 09:50:59.579):{0x1F64} -- EnableRichContent.sql
[40000] (04/28 09:50:59.579):{0x1F64} --
[40000] (04/28 09:50:59.579):{0x1F64} -- This will turn on the Rich Content options for all
[40000] (04/28 09:50:59.579):{0x1F64} -- BlackBerry Enterprise Servers managed in the target database.
[40000] (04/28 09:50:59.579):{0x1F64} --
[40000] (04/28 09:50:59.579):{0x1F64} -- (C) 2008 Research In Motion Limited.
[40000] (04/28 09:50:59.579):{0x1F64} ----------------------------------------------------------------------------
[40000] (04/28 09:50:59.579):{0x1F64} UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
[40000] (04/28 09:50:59.579):{0x1F64} UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
[40000] (04/28 09:50:59.579):{0x1F64} UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
[40000] (04/28 09:50:59.579):{0x1F64} UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
[40000] (04/28 09:50:59.579):{0x1F64} ExecuteStatement: Unable to run the statement:
----------------------------------------------------------------------------
-- EnableRichContent.sql
--
-- This will turn on the Rich Content options for all
-- BlackBerry Enterprise Servers managed in the target database.
--
-- (C) 2008 Research In Motion Limited.
----------------------------------------------------------------------------
UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
[40000] (04/28 09:50:59.579):{0x1F64} ExecuteStatement: Error: [ADOConnectionItem::ExecuteUpdateSQL(): Could not execute SQL Command "----------------------------------------------------------------------------
-- EnableRichContent.sql
--
-- This will turn on the Rich Content options for all
-- BlackBerry Enterprise Servers managed in the target database.
--
-- (C) 2008 Research In Motion Limited.
----------------------------------------------------------------------------
UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0".]
[10000] (04/28 09:50:59.579):{0x1F64} Problem occured while executing SQL commands.

[jibi]

@cschrage, is this database on SQL (2000 or 2005) or MSDE (2000 or 2005)?

[cschrage]

Sql 2005

[jibi]

- Open the Management Studio
- Navigate to your BESMgmt database and to the ServerConfig table
- Right-click on it and choose Open Table

See if you have the column names RichContentEnabled and RichContentInlineEnabled. Repeat for the UserConfig table.

[cschrage]

The columns are present in each table

[hdawg]

Originally Posted by cschrage

The columns are present in each table

Try this:

1) Open SQL Management Studio
2) Create a new query
3) Open the file EnableRichContent.sql in notepad
4) Copy / Paste the contents from notepad into the query window
5) Make sure you have your BESMgmt database selected
6) Execute the query

Provide a screenshot back or a screenshot of at least your ServerConfig table, obfuscating any private information

[cschrage]

I updated the tables manually....bingo...html works now.

Thanks for all the assistance

[jibi]

Hrm, I wonder if BBDBUpdate is not compatible with SQL 2005. I will test later today.

[BekNazar]

Thanks for the info! Works great.
I get the following when I try to download more on my BB.
Any idea why??

[KeNNethX]

Originally Posted by jibi

If you do not have OS 4.5 (currently in beta) on your devices, don't apply this patch.

This may be a no-brainer but you say "on your devices" Do you mean all of them or at least one device? I have a beta of 4.5.18 and I would like to test it...but none of my users have it. Will this have much impact if it's only me?

[jibi]

@KeNNethX, it won't have much of an impact. I would suggest updating the tables manually to account for your User ID only, though.

@BekNazar, it hasn't been updated for your user account. Re-run the SQL above. If that doesn't work, go into the UserConfig table and update manually for your User ID.

[KeNNethX]

Originally Posted by jibi

@KeNNethX, it won't have much of an impact. I would suggest updating the tables manually to account for your User ID only, though.

@BekNazar, it hasn't been updated for your user account. Re-run the SQL above. If that doesn't work, go into the UserConfig table and update manually for your User ID.

Any tip for how to manually to that? SQL 2000 sp4.

[BekNazar]

Jibi,

Funny thing is that I am receiving emails in html...
Just can't do "Get more"

Todd

[KeNNethX]

Never mind, I figured it out from the above...cool...I am the only one enabled and viola...I can read my emails from NewEgg...yay!

[dietcoke]

I just ran this on my brand new Unite installation and the command completed sucessfully. I am going to test it out and see if i get html email now.

Although the command worked, i don't see the email coming in with rich or html... I am thinking i need a reboot.


I didn't see it working... however I have manually opened up the tables and there is another field under user... it is called "RichContentTrainingField". I have hit 1 on that one...

Also here, I believe you can rename the service book from Unite to Whatever you want.

[BekNazar]

I had to reboot...
Then I saw that it wasn't running because I was using Domino 7.0 which doesn't support html emails. I upgraded to 7.0.2 and it worked like a charm.

Todd

[vhato]

Originally Posted by dietcoke

I just ran this on my brand new Unite installation and the command completed sucessfully. I am going to test it out and see if i get html email now.

Although the command worked, i don't see the email coming in with rich or html... I am thinking i need a reboot.


I didn't see it working... however I have manually opened up the tables and there is another field under user... it is called "RichContentTrainingField". I have hit 1 on that one...

Also here, I believe you can rename the service book from Unite to Whatever you want.

Is that out? Or just a beta?