Jump to:

3462 Posts in 1065 Topics by 740 members

Data Model Questions

SilverStripe Forums » Data Model Questions » Live table is empty

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 631 Views
  • landyman
    Avatar
    Community Member
    11 Posts

    Live table is empty Link to this post

    Hello -
    After running a dev/build, there was an error when trying to repair a _Live table. Now, that _Live table is empty, and is pretty much hosed as far as I know since running a CHECK TABLE command comes up with a bunch of errors, and running REPAIR TABLE doesn't fix it.

    Because all of the data is in the normal (not _Live) table, is there a way to just remove the _Live table and rebuild it? SS may do that on it's own, but I didn't want to try it first without asking.

    Thanks.

  • martimiz
    Avatar
    Forum Moderator
    1091 Posts

    Re: Live table is empty Link to this post

    I was curious and thought I'd try it out by renaming SiteTree_Live. And no, SilverStripe doesn't rebuild it... But you could easily do that yourself in PHPMyAdmin or some such, if you copy the statement from an earlier dump or a test-install... And renaming the table at least you still have it...

    After that I could just batch republish my pages... So it's worth a try (a backup is very very advisable!!!) Better yet if you switch to a second database, if you have it, even better, best if you can set up a test site to do this...

    Good luck!

  • landyman
    Avatar
    Community Member
    11 Posts

    Re: Live table is empty Link to this post

    Hi martimiz -
    Yeah, that's what I ended up doing -- I setup a different database and removed all of the data from the _Live table (keeping the structure intact). Then, I went into the admin and batch republished -- worked like a charm.

    So, I went to the live DB and did it -- also worked.

    Thanks for the reply!

    631 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.