I know this has been asked and answered many times so forgive me doing it again. We are trying to remove seats from a seating map as the venue has changed. We believe we have done everything correctly and run the various scripts required. However, even though the seats appear as a white "square" with a box symbol in them, you are still able to select and sell the seat - all the way through to selling and printing it. As the scripts have been run, the seats do not appear in the seat map in Season Manager so we cannot apply a hold code to them. Fortunately, this is only in our TEST environment and not LIVE.
Does anyone have a checklist if the steps required to remove these seats properly that they'd be willing to share? Or even point out o step that we've forgotten to do?
Thanks, Martin
Hi Martin,
Good day.
have you checked the tx_perf_seat table?
SELECT pkg_no, perf_no, seat_no, status_code, sli_no, customer_no, pseat_dt, seat_num, seat_row, Hstatus, logical_seat_row, logical_seat_num, available_ind, rank, zone_no, zmap_no, bit_col, locked_by, fill_sequence_num, seat_status, ac_no, min_cust_rank, mos_list, user_grp_list, prior_seat_status, order_noFROM TX_PERF_SEATWHERE (perf_no = @YourPerformance)
you can set seat_status = 6 'BLK blacked out ' or just remove the records.
have fun.
Ben
Thanks for the reply Ben. what we'd missed is that we SHOULD have set the seats to a blacked out hold code BEFORE removing them.
Easy when you know how!
Martin