|
Jonathan Brooks
|
January 9, 2013 at 11:58 am
Hello,
I added an attendee manually who purchased 191 tickets. After he was successfully added to the database, I noticed the 191 changed to 127. Thought maybe it was an error on my part, but I was able to replicate it by adding another test attendee with 191 tickets…it too changed to 127. It’s not an attendee cap issue (I raised it and tested it just in case). Any suggestions?
Also, I noticed I am not able to change ticket count per attendee after purchase. Under the “primary attendee record” there is a drop down box to select a different ticket quantity. No matter what I change this to, it defaults back to what was originally purchased after saving.
Thanks for your help.
Jonathan
|
|
Chris Reynolds
|
January 9, 2013 at 1:50 pm
Jonathan —
This is because in the database, the ticket quantity is a tinyint, which ranges from 0-127. Changing this to a larger number (e.g. smallint) would require a change in the source code, the database, and may result in slower db performance and a larger overall database size, particularly when you’re adding attendees of that quantity on a regular basis (2 storage bytes adds up when multiplied times 190 for more than one event…).
http://dev.mysql.com/doc/refman/5.0/en//numeric-types.html#integer-types
My suggestion would be to set the maximum number of attendees to 127 and do this particular attendee as 2 separate registrations.
|
