The results of your search are shown below. To refine your search, revise your keywords, and/or select the appropriate check boxes to the right.
DF-FR-19429-List of Registrants by Activity report returns “SQLSTATE = S0022, Invalid column name ‘activity_id’”
Symptom
Report returns error when including activity in the query.
Product Line
DF-M19590-Constituent First Name is truncated when adding a non-constituent guest to a registrant
Symptom
Constituent First Name is truncated when adding a non-constituent guest to a registrant
Product Line
DF-M23259-Sporadic error “Incorrect syntax near ‘-‘” adding non-constituent guest to an event registrant
Symptom
Users experience the error message below when clicking Insert to add a Guest row onto an event registrant record after clicking on Create a Non-Constituent Guest link.
![](/sites/kb/files/create_non_constituent.jpg)
*SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attlnkkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select guestkey from event_guest_full where guestlnkky = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Media'.--37000 Statement: DSN=Web SQL;UID=tvt;==select gitemitmky from guest_items_full where gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0 or gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0
![](/sites/kb/files/create_non_constituent.jpg)
*SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attlnkkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select guestkey from event_guest_full where guestlnkky = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Media'.--37000 Statement: DSN=Web SQL;UID=tvt;==select gitemitmky from guest_items_full where gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0 or gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0
Product Line
DF-FR-21332-Guest Card Prints Only Headers
Symptom
Print Preview of Guest tab only returns the header rows. The Guest Names and Guest of columns are blank. Printing to printer also returns only column headers
![](/sites/kb/files/print_preview.png)
Product Line
DF - Attempting to select the Non-Constituent designation causes corruption in Event setup
Fundraising 50 Known Issue (P7753)
Version: 7.0
Menu Item in Product: Event>Guests>Non-Const designation
Brief<
Product Line
Table and Section numbers are not sorted in numerical order
Symptom
Table/Seat and Section/Row/Seat numbers appear in the incorrect order on the Attend card in Events and on event reports.
Product Line
All guests are assigned to table and seating when you highlight some guests and click “Add all”
Symptom
Event guest seating assignment permits you to highlight guests and click “Add all” to an existing table. This gives the impression that just the highlighted guests would be assigned to the table, but all guests without a table and seat assignment are placed at the table.
![](/sites/kb/files/seats.jpg)
Product Line
Event guests randomly seated in seats where previously seated guests have been removed from
Symptom
In event seating, if you edit a table, and remove a seated guest from a seat, when you look at the event seating, randomly you see another guest sitting in that same seat.
Product Line
New Event card can be created with blank fields
Symptom
The system allows the saving of blank Events cards
Product Line
DF-M17165-Guests are assigned to seats or tables, but randomly you cannot see the seating assignment or table assignment
Symptom
You can assign guests to seats, but randomly when you Edit Table you do not see anyone assigned to the seat. As well you can assign a guest to a table, but sometimes the table is not found so you can Edit Table, even if you scroll to the right and left to find the table.
Product Line
DF-M17011-Blank Event Guest display after updating Guest record
Symptom
After updating guest record, the event guest blanks out.
Product Line