Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
Hi there, have you run into this before? What would cause the following issue? And what is the best fix for it?
Performance is showing 6 tickets as unpaid in Orchestra Premium. These are two web orders and show as paid in t_order. Tickets will not print if showing as unpaid.
The seat_status in table tx_perf_seat =7, looks like if I update it and set seat_status=8 would probably fix the issue. Is this the best approach? Are there any other tables that need to be updated?
Hi Diana
Have you run the utility proc TP_Check_seat_status on the season (with @fix_problems =’Y’)
That will resolve minor differences of opinion between Order tables and tx_perf_seat.
Should really run it every night, to get rid of issues like this proactively.
If that doesn’t fix it, I’d raise a service call before I started playing with the data in tx_perf_seat directly.
Ken McSwain Business solutions Manager
kmcswain@sydneyoperahouse.com
T+61 2 9250 7876 F+61 2 9251 7821 M 0418 659 360
SYDNEY OPERA HOUSE BENNELONG POINT
GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA
SYDNEYOPERAHOUSE.COM
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Diana Du Sent: Wednesday, 16 December 2009 09:37 To: Ken McSwain Subject: [Tessitura Ticketing Forum] tx_perf_seat
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Please consider the environment before printing this email. =====This message is intended for the addressee(s) named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Hi Ken, greetings from San Francisco Ballet. Thank you very much for your very helpful response.