Hi all,
I have a series of performances that were built in the wrong title (and by extension, the wrong production and production season). Is it possible to correct that, or do I need to rebuild the events in the correct place?
Thanks,
Lesley Chaney
You can correct it via SQL by updating the prod_season_no in t_perf for the perfs in question to the correct prod_season_no. You didn't say if the wrongness of the prod_season in turn put the perfs in the wrong season, but if so you'll need to update that as well. I've done this before without incident.
Thanks for the info! Is there any repercussion to doing this after there are sales in the event, or does it not matter?
Season overview will still show the perfs in the wrong prod_season until the next full refresh, I think. Local tkt and sub hist, depending on what your local version does may also be mismatchey if you reference the prod_season there, until you next refresh that data. Any report snapshots from before the change, I am pretty sure will not be affected, ie they'll still reflect the previous wrongness. I think.
Other than that I don't believe it should matter.