The field lengths in ecommerce_pending table are smaller than the field length in their respective destination fields.
Example:
Addrphone: char(30) - ecomhphone: char(15)
Phnumber: char (70) – ecomhphone: char(15)
Phnumber: char(70) – ecomhphone: char(15)
Giftacctnm: char(80) – ecomacctnm: char(80?)
“SQLSTATE = 21000: subquery returned more than 1 value. This is not permitted when the subquery follows =,!=, <, <=, >, >= or when the subquery is used as an expression”
Missing database fields in export files negate ability to report on emails and phone numbers for guests entered on the guest card when using Event Reports.
A “Constituent has been deleted” error occurs sporadically when entering new constituents with unrecognized ZIP-codes and pressing enter in the State field.
The amount of time it takes to post a transaction is excessive and while the process is running all user activity is locked (i.e. no one can run a financial report).