Mango Blog Forums : Mango Forums : General : Content Field Too Long?

Forums home | Profile | Search | Login | RSS

Thread: Content Field Too Long?

Created on: 03/22/10 12:13 PM

New topic Reply

Page: 1

Replies: 8

apocalipsis1982

Joined: 02/15/10
Posts: 11
03/22/10 12:13 PM

Hi Community!

I am getting the following message:

"Error Executing Database Query.: Data truncation: Data too long for column 'content' at row 1"

When doing a blog post. I checked the "content" field and it's a long text. So it should not happen. The text that I tried to insert was around a page long.

Has anyone else experienced this?

any thoughts?

Thanks!

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1523
04/11/10 1:31 AM

I believe that has to do with the database driver. You need to enable the CLOB setting in the datasource page (Advanced settings) in the ColdFusion administrator.

Link | Top | Bottom

apocalipsis1982

Joined: 02/15/10
Posts: 11
06/30/10 1:35 PM

Thanks Laura. For some reason we are still having this issue. I wonder if some fellow bloggers have come up with the same problem. At times when I cut off some paragraphs from the text it goes through. Sometimes it does not. The weird thing is that the database field can hold millions of characters. I even cleaned the file from whatever HTML may be in it but still the problem persists. Any comments or thoughts would be greatly appreciated.

Link | Top | Bottom

apocalipsis1982

Joined: 02/15/10
Posts: 11
06/30/10 1:45 PM

I should add that the field content is LONGTEXT I believe...

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1523
07/01/10 9:33 AM

Did you make the change in the CF admin? It doesn't matter that the db field is long enough if the driver truncates it before sending it.

Link | Top | Bottom

apocalipsis1982

Joined: 02/15/10
Posts: 11
07/01/10 10:24 AM

I did. I made the change. I enabled CLOB setting in the data source page.

Link | Top | Bottom

apocalipsis1982

Joined: 02/15/10
Posts: 11
07/12/10 7:19 AM

And I keep getting the same outcome...

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1523
07/12/10 4:51 PM

I don't know what to tell you. I don't think it is anything that I can fix on Mango. I strongly believe it is a driver problem. What DB are you using?

Link | Top | Bottom

apocalipsis1982

Joined: 02/15/10
Posts: 11
07/21/10 8:18 AM

Laura,

I just fixed the issue by updating mySQL Server and reinstalling Mango.

Thank you for taking the time to look into this. I will see you at CFUnited!

Link | Top | Bottom

New Post

Please login to post a response.

Replies: 8
apocalipsis1982 Joined: 02/15/10 Posts: 11	03/22/10 12:13 PM Hi Community! I am getting the following message: "Error Executing Database Query.: Data truncation: Data too long for column 'content' at row 1" When doing a blog post. I checked the "content" field and it's a long text. So it should not happen. The text that I tried to insert was around a page long. Has anyone else experienced this? any thoughts? Thanks!
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1523	04/11/10 1:31 AM I believe that has to do with the database driver. You need to enable the CLOB setting in the datasource page (Advanced settings) in the ColdFusion administrator.
	Link \| Top \| Bottom
apocalipsis1982 Joined: 02/15/10 Posts: 11	06/30/10 1:35 PM Thanks Laura. For some reason we are still having this issue. I wonder if some fellow bloggers have come up with the same problem. At times when I cut off some paragraphs from the text it goes through. Sometimes it does not. The weird thing is that the database field can hold millions of characters. I even cleaned the file from whatever HTML may be in it but still the problem persists. Any comments or thoughts would be greatly appreciated.
	Link \| Top \| Bottom
apocalipsis1982 Joined: 02/15/10 Posts: 11	06/30/10 1:45 PM I should add that the field content is LONGTEXT I believe...
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1523	07/01/10 9:33 AM Did you make the change in the CF admin? It doesn't matter that the db field is long enough if the driver truncates it before sending it.
	Link \| Top \| Bottom
apocalipsis1982 Joined: 02/15/10 Posts: 11	07/01/10 10:24 AM I did. I made the change. I enabled CLOB setting in the data source page.
	Link \| Top \| Bottom
apocalipsis1982 Joined: 02/15/10 Posts: 11	07/12/10 7:19 AM And I keep getting the same outcome...
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1523	07/12/10 4:51 PM I don't know what to tell you. I don't think it is anything that I can fix on Mango. I strongly believe it is a driver problem. What DB are you using?
	Link \| Top \| Bottom
apocalipsis1982 Joined: 02/15/10 Posts: 11	07/21/10 8:18 AM Laura, I just fixed the issue by updating mySQL Server and reinstalling Mango. Thank you for taking the time to look into this. I will see you at CFUnited!
	Link \| Top \| Bottom