Quantcast
New Topic Reply Subscription Options   Previous Page  Page: 1   Previous Page

Help!!

Site & Forum Suggestions:
Created on: 10/20/09 01:25 AM Views: 784 Replies: 2
Help!!
Posted Tuesday, October 20, 2009 at 1:25 AM

I have been trying for months to update my profile information and every single time I do it an error comes up:

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

Resources:

* Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option.
* Check the ColdFusion documentation to verify that you are using the correct syntax.
* Search the Knowledge Base to find a solution to your problem.

Browser    Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.14) Gecko/2009082707 Firefox/3.0.14 (.NET CLR 3.5.30729)
Remote Address    24.236.209.12
Referrer    http://www.shewired.com/ProfileMod.cfm
Date/Time    19-Oct-09 10:22 PM

Doe anyone know what this is all about and what I can do to fix it so I can actually have stuff about me on my profile??


Thanks Very Happy

www
RE: Help!!
Posted Tuesday, October 20, 2009 at 10:13 PM

It occurs when you try to insert or update a string or binary column with a value that is too large. Can be solved by changing varchar(50) to varchar(100) for example in the table declarations. The Webby would have to redefine the variable.

Outside of that, -because waiting is a pain-
This is the best way to get the update until the Webby extends those character limits.

You, yourself could try to shorten character counts that you are entering into the fields. Since it's hard even as a programmer to tell which fields throw this error, it might be a good idea to reduce all the text per field that will go inserted.

TIP: Put the original text in a word document and copy paste, because you might need to make adjustments several times before you find the actual character count that goes accepted. (This will help avoid re-writing a profile over and over again.)

So, if error occurs after the second draft, again shorten the original text more for a third draft and try again. Continue until it goes through and before you close the word document check to see the character limits. Remember them for the next update you want to do.


It would help if there was a character count on fields like that always, right? Laughing

*From what I understand the site was hacked and the programmer is still trying to correct the problems running rampage. When I log out I still have my hot topic's links thrown across the page when I visit the home page. When I log in the links are on the target field correctly. Anyway, I'm sure she/he/they whatever will get around to fixing it all eventually, but for now we have to eat bugs.*
-Meg

Glowworm wrote:

I have been trying for months to update my profile information and every single time I do it an error comes up.Doe anyone know what this is all about and what I can do to fix it so I can actually have stuff about me on my profile??

Edited 11/02/09 8:28 PM
RE: Help!!
Posted Monday, November 2, 2009 at 10:00 AM

This site is full of technical glitches...basically, it is very difficult and frustrating. I think it is the "red-headed stepchild" of the Here! network. It is poorly designed and the video section is pathetic. If shewired plans on competing with other lesbian-content oriented sites like afterellen.com and advocate. com (which caters more to gay men than lesbians), they are going to have to step up their game.

New Topic Reply Subscription Options   Previous Page  Page: 1   Previous Page
Subscription Options
Subscription options are available after you log in.