Please note that you may have been redirected (you might like to make a note of the URL in the address bar of your browser and update accordingly) This is a permanent archvie but is no longer actively maintained. Please visit http://joshuaink.com for the latest updates.

Textpattern database repairs

Thursday June 9, 2005

This is definitely a Textpattern plug-in worth drawing much attention to. Though I am probably the last to find out about it, as ever.

I have just been sat with a client showing off his shiny new Textpattern site and getting him to play with the comments system. Not working, no not working, no still not working.. doh!

Anyway, after a bit of panicking and some frantic searching I found Johan Nilsson's glx_admin_db_tables. It adds a new tab to the TXP admin called Extensions and from here for you can check and repair your database tables.

One click and the comments were working again, sweeet!

  1. Matthew Pennell

    1275 days ago

    Cool.

    How did you manage to break the tables in the first place, out of interest?
  2. Ray

    1275 days ago

    I’d like to know the same thing Matthew asked. How in the world did you break the tables? What’s the chance of something going screwy if you never mess with the code directly by making some hack? (Oops. Guilty of that…)
  3. AkaXakA

    1275 days ago

    A side question: How do you let your clients interact with Textpattern? Do you get them to use Textile or…? Do you make a seperate limited account to stop them from messing up templates?
  4. Abel Rios

    1275 days ago

    I’ve seen this with MySQL. Sometimes it happens. I’ve actually had this happen to me twice in the past year, where a table just broke. I ended up repairing the table both times, and it worked fine. One thing that didn’t help was the massive traffic the client was getting.
  5. Matthew

    1274 days ago

    Good one, John. I hadn’t seen this one yet either, but it looks like a very good tool to keep in the toolbox. Johan makes some wonderful plugins. I’m a big fan of his work.

    Another one that’s fairly new, but fucking spectacular (and not one of Johan’s) is Mary’s upm_image_popper, easily the most wonderful image selector to come down the pipes. I know you’re not heavy on the images, John, but if ever you have a client who needs to get images into his articles, I reckon this would be the way to go. If you haven’t checked it out yet, you’d be well advised to do so.
  6. Martin W

    1274 days ago

    ‘no hacking at all’ says Mr O – and then wandering across the BBC website I find this….

    http://news.bbc.co.uk/1/hi/uk/4072938.stm

    hmmmm spooky similarity here and a bit too much of a coincidence Mr Oxton…or should I say MR BEVAN!!
  7. Martin W

    1274 days ago

    Actually he looks like one of the Three Musketeers!
  8. Martin W

    1274 days ago

    I can’t even get into the sodding thing! They’re taking ages to reset the thing “how do we know you want it resetting” – er cos I asked you – “how do we know you’re you!” – because you take money off me every month!
  9. Martin W

    1274 days ago

    Yeah but for all I know this customer service guy could be on a completely different continent (he’s clearly on a different planet) and no way reflects on the good people at said establishment.

    Note: if by any chance you are reading this blog in preparation for working with Professor O, I think you do a wonderful job and could you unlock my frozen passwords please.

    Well its worth a try!
  10. Kalle

    1274 days ago

    Hehe, Johan Nilsson is a Swede =)
    I hope that I never break a table, that would be hell.
  11. Thom

    1274 days ago

    I don’t know what the fook you guys are on about but i would like to say that there is obviously a lot of ‘love in da room’ and male bonding experiences to be shared over texty table things!!!! lol
  12. Jolo

    1274 days ago

    Tool of the trade… well this comes handy for table errors. Thanks for the link. Found it very useful.