[solved] Problem with submitted page being truncated

[cnymike]

I have a long page containing 406 lines. Each line is in the form of...

Code: Select all

<div class="plantsOrder"><span class="strongtext">Acer davidii </span> 1.5 pt  - 9.99 <a href="http://xxx.xxxxxx.com/cf/add.cfm?userid=xxxxxxx& product=Acer-davidii- 1.5 pt &price=9.99"><span class="cart">Add To Cart</span></a></div>

I paste the 406 lines into a new page in CMSMS and Submit it. When I subsuquently open the page in the Edit Content window, the page is only 242 lines. Somehow 164 lines are getting truncated. I've tried this three times, each time with the identical result.

What is causing the page to lose nearly 1/3 of the lines? Could this be a timeout problem of some sort? This is a serious problem because I do not want to have to break the page up into 2 or more pages. This is essentially a "Quick Order" page where the client wants all 406 items to be available for sale on a single page.

Any suggestions?

Michael

[cubix]

check this out..

http://forum.cmsmadesimple.org/index.ph ... 662.0.html

id guess is your problem. depending on the total size of the amount of data your pasting.

[cnymike]

I don't know how I missed that thread. That does sound like  the likely answser. Later today when I get the chance, I'll see if I can fiddle with phpMyAdmin and try that potential solution. Thanks for the heads-up to that thread.

Michael

[cnymike]

Yes, that was the problem. Changing the field type of the table "content_props" from TEXT to LONGTEXT solved it.

Here is the technique assuming you have phpMyAdmin...

1. Launch phpMyAdmin and locate your database.
2. On the left side of the window are listed all the tables that comprise the database.
3. Locate the table named "content_props". Your table may instead have a prefix such as "cms_content_props"
4. Click on this table to open the editing window
5. Locate the field named "content"
6. Under the Action column, for the field "content" click on the pencil icon. This enables you to change the value for the field.
7. Under the "Type" dropdown menu, the value "text" will be selected, You will want to change this to "longtext" by clicking the dropdown menu and scrolling down until you see the value "longtext".
8 Select the value "longtext", click the "Save" button and you're done.

This should now enable you to have very long text entries on pages that previously were being truncated or cut short.

Michael