/ Register

  1. REGISTRATION REQUIREMENTS:

    Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Accidentally deleted settled events

Discussion in 'Sportsbook Support' started by topcat, Apr 2, 2014.

  1. Apr 2, 2014 #1
    topcat

    topcat Member Pickem Sportsbook Survivor

    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
     
  2. Apr 2, 2014 #2
    Bob

    Bob Developer Staff Member

    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
     
  3. Apr 2, 2014 #3
    topcat

    topcat Member Pickem Sportsbook Survivor

    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
     
  4. Apr 2, 2014 #4
    Bob

    Bob Developer Staff Member

    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.
     
  5. Apr 2, 2014 #5
    topcat

    topcat Member Pickem Sportsbook Survivor

    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 :)
     
  6. Apr 2, 2014 #6
    Bob

    Bob Developer Staff Member

    you'll need to do more than just the events table. the outcomes and wagers tables are tightly integrated with the events table.
     
  7. Apr 2, 2014 #7
    topcat

    topcat Member Pickem Sportsbook Survivor

    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
     
  8. Apr 2, 2014 #8
    Bob

    Bob Developer Staff Member

    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.
     
  9. Apr 2, 2014 #9
    topcat

    topcat Member Pickem Sportsbook Survivor

    done,

    so how do i delete individual events ??
     
  10. Apr 2, 2014 #10
    Bob

    Bob Developer Staff Member

    Upgrade to 1.3.0. Starting with 1.3.0, you can delete events on the frontend.
     
  11. Apr 2, 2014 #11
    topcat

    topcat Member Pickem Sportsbook Survivor

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

    sorted now
     
    Bob likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...