First off, I strongly recommend that you upgrade as soon as possible. 2.2.7.3 was released over two years ago, and some serious security flaws have been identified and fixed since then.

In viewing the source, I noticed that there are font size and face declarations on each td element, which is increasing the size of the HTML tremendously. My guess is that this table was originally copied and pasted out of Word or Excel, and Microsoft's markup is notoriously messy. I'd start with editing out all of those extraneous font declarations, to see if that helps.

You might also consider breaking the table up into a few logical chunks, and put each into its own separate feature.

Jamie

Hi,

I agree with Jamie that it would be good to upgrade, it is a very old version, but that is not what I would do to solve this problem and doing that might actually complicate it depending on what the real problem is.

First thing to do is Basic Troubleshooting, clear the mojoportal log, try to save the large table, then see if any error is logged.

Were you able to edit this large content previously and the problem just started?

Also I'm not even clear on what problem you are having, please clarify what you mean by:

I am able to manually drop it in to the database and it displays fine.

You are editing mojoPortal tables directly in SQL Server and it works?

I would check that the database and/or the site is not running out of disk space or any other errors that the database might be logging in addition to any clues the mojoPortal log.

Maybe if there are clues in the log we can suggest further steps.

Hope it helps,

Joe

Before you consider upgrading find out what version of MS SQL you have, if it is SQL 2005/2008 you can upgrade to the latest version but if SQL 2000 you cannot upgrade all the way to the latest version without migrating to a supported version of SQL Server.

Hi,

Is the content in the editor before you save it or is it getting lost when you paste it into the editor?

Can you try using a different editor and see if it produces the same result. ie if using CKeditor try TinyMCE or vice versa. You can set the editor from Administration > Site Settings.

Best,

Joe

The only thing I can think of that might be happening is if the data type is not declared correctly either in code or in the stored procedures mp_HtmlContent_Insert and mp_HtmlContent_Update then it could be truncating the data if the param is declared too small. I don't recall there ever being a bug like that but it was along time ago. You might check those procedures and see what data types are used for the content, it should be ntext which should be large enough.

If the params are of the correct data type in the stored procedures then it could be they are declared incorrectly from code and the only solution is to upgrade assuming that is really what is happening (I'm only guessing at what could be happening), I don't have a version of the code that old lying around except maybe somewhere on a dvd backup.

However, upgrading from a version that old has several implications, I've updated the document here:

http://www.mojoportal.com/upgrading.aspx

with some info about upgrading from very old versions. You need to be aware of changes like your current version runs under .NET 2.0 but to upgrade to the latest you need .NET 3.5 SP1 or .NET 4.0. Also if you are using MS SQL 2000, we stopped supporting that after version 2.3.4.5 so to upgrade to the latest you need at least SQL 2005 with all service paks applied or SQL 2008.

In the long run if it is possible for you to upgrade to the latest version that would be the best way to go. If there is a bug in an older version it can only be fixed in a newer version.

Hope it helps,

Joe