SQL cannot truncate values when storing them into records in the SQL database. If a user tries to enter a value that is longer than the field length, e.g. enter a city longer than 20 characters, when they submit they will get the above error.
To avoid the error, fields on all templates that submit data to the SQL tables must have a maxlength set to the maximum length of the field.
This applies to the following templates: Attachments.awp, Attendtrack.awp, ChangePwd.htm, CourseProposal.awp, Credentials.awp, CustomRegister.htm, Gradebook.awp, Person.awp, Proxyreg.awp, Register.htm, Xperson.awp. This also applies to any custom express registration and data capture templates you are using.
You can get updated templates from the aceware.com\aw\templates folder that have maxlength values set on the fields. Just note, you will need to re-apply any customization to the new template.
Also remember, if you are adding fields to any ACEweb templates, you will need to ensure they have the correct maxlength value set.
Related Topics