Accidentally deleted settled events

[topcat]

I accidentally deleted settled events losing months of stats/data etc

I do have a recent back up of my database. What tables should I restore if possible

 

[Bob]

all of the sportsbook tables (to be safe). The biggies tho would be event, outcome and wager.

xf_nflj_sportsbook_category
xf_nflj_sportsbook_category_prefix
xf_nflj_sportsbook_category_watch
xf_nflj_sportsbook_comment
xf_nflj_sportsbook_event
xf_nflj_sportsbook_event_prefix
xf_nflj_sportsbook_event_prefix_group
xf_nflj_sportsbook_event_read
xf_nflj_sportsbook_event_view
xf_nflj_sportsbook_event_watch
xf_nflj_sportsbook_outcome
xf_nflj_sportsbook_wager

 

[topcat]

do i need to drop the current ones or can i import the tables over into the current ones, theres currently a few open events added

 

[Bob]

If you know what you are doing yes, if not, its probably best to have your host do it for you as they should know how.

 

[topcat]

cheers, I uploaded my db to another installation, exported the events table then imported into my current DB table. Probably not standard way of doing it, but seemed to have worked

 

[Bob]

you'll need to do more than just the events table. the outcomes and wagers tables are tightly integrated with the events table.

 

[topcat]

the wagers table seems intact still with over 500 pages in the database.

I did some test events and and wanted to delete them, but couldn't find how, I deleted settled events in the admincp

I have been comparing my current db against the backup and all the event looked different

 

[Bob]

Deleting settled events removes rows from the events table, outcome table and wagers table.

if you restored the Event table, you HAVE TO (NO EXCEPTIONS) restore the Outcome and Wager tables as well. If you do not, then there will be orphaned and missing data.

 

[topcat]

done,

so how do i delete individual events ??

 

[Bob]

Upgrade to 1.3.0. Starting with 1.3.0, you can delete events on the frontend.

 

[topcat]

Forget that, didn't have permission to delete events in admin cp

sorted now