Home » Blogs » garym's blog

communiqué reloaded

Posted by garym on Sun, 10/10/2004 - 02:18

Yeah, I know, you're tired of that metaphor, but in this particular case it's not lame poetics, I really did wipe the thing clean and reloaded the whole system from scratch en route of the long road to updating the teledyn.com web projects into the new Drupal 4.5.

and it's been a long hard road.

But I figured hey, I never promised you a rose garden and I'm hoping you'll all bear with me on this great adventure to salvage as much of the legacy content as possible while still bringing us up to date with all the new and wonderful things we can get out of Drupal 4.5 -- trust me, it's going to be worth it.

For you McLuhanites out there, you'll be happy to know that one of the retrievals in this updated site will be the return of the links database, a long lost component of the communiqué pages that somewhat fell to fallow in the back pages but soon to re-emerge as a hierarchical database of website reviews.

And there's more, much more, but for now there's this mountain of forward incompatibilities and I'm half-way up, camped in a tent, too far now to turn back, I can almost see the snow caps and I probably don't have to tell you all this because you've been here dozens of times if you do anything at all with technology.

stay tuned.

if there are any drupalers out there watching my pains, does anyone know how I can get the new textile applied to several hundred articles? I migrated the body but it seems each one must be ... ah ... er ... reloaded ...

Summary page fix ...

Submitted by garym on Sun, 10/10/2004 - 03:21.

doh --

far easier than I'd thought, or more likely, it's just 4 am and I'm really not thinking right and May's going to kill me in the morning but the solution is to just fix'er up in the SQL:

update node set teaser = concat( '[textile]', teaser ) where body like '[textile]%' and teaser not like '[textile]%';

and like magic, the summary pages are cool again. well ... cooler.

For the record, my other magic bits of migration SQL:

  • fix obvious textile pages: update node set body = concat('[textile]',body) where body like '%textile%' or body like '%":http://%' or body like '%bq. %';
  • fix some missed clues: update node set body = concat('[textile]',body) where body like '%textile2%' or body like '%!http%' or body like '%!:%' and not body like '[textile]%';
  • fix the textile1 much the same way, but I learned later hey why not just search for char(1)? -- like I said, it's late.
  • then get rid of it ... update node set body = substring(body,1,locate(char(1),body)-1) where body like concat('%', char(1),'%');