Error during Registration (new customer)

[Abdullah Shaikh <ab...@viithiisys.com>]

During new customer registration, there is no validation check for "Allow
Address Solicitation", the default value of which is "--", this leads to the
below error getting displayed on the page.

The Following Errors Occurred:

Error: ERROR: Could not complete the Create a PartyContactMech
file:/home/abdullah/projects/ofbiz_ws/ofbiz/applications/party/script/org/ofbiz/party/contact/PartyContactMechServices.xml#createPartyContactMech<file:///home/abdullah/projects/ofbiz-sagepay_ws/ofbiz/applications/party/script/org/ofbiz/party/contact/PartyContactMechServices.xml#createPartyContactMech>process
[problem creating the newValue value: Error while inserting:
[GenericEntity:PartyContactMech][allowSolicitation,--(java.lang.String)]
[contactMechId,10020(java.lang.String)][createdStamp,2009-10-23
14:56:41.067(java.sql.Timestamp)][createdTxStamp,2009-10-23
14:56:40.277(java.sql.Timestamp)][fromDate,2009-10-23
14:56:41.067(java.sql.Timestamp)][lastUpdatedStamp,2009-10-23
14:56:41.067(java.sql.Timestamp)][lastUpdatedTxStamp,2009-10-23
14:56:40.277(java.sql.Timestamp)][partyId,10010(java.lang.String)]
[roleTypeId,CUSTOMER(java.lang.String)] (SQL Exception while executing the
following:INSERT INTO public.PARTY_CONTACT_MECH (PARTY_ID, CONTACT_MECH_ID,
FROM_DATE, THRU_DATE, ROLE_TYPE_ID, ALLOW_SOLICITATION, EXTENSION, VERIFIED,
COMMENTS, YEARS_WITH_CONTACT_MECH, MONTHS_WITH_CONTACT_MECH,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long
for type character(1)))] calling service createPartyPostalAddress in
createCustomer