Distress!

[John Robinson]

mysql> update topic_list set topic_title = 'General Interest' where forum_id = 4;
Query OK, 32 rows affected (0.01 sec)
Rows matched: 32 Changed: 32 Warnings: 0

OH NO!

[John Robinson]

What the heck was I thinking!?

[John Robinson]

Needless to say, ALL the topics on this forum are now titled "General Interest". Just in case you were wondering what happened.

[Admin Moderator]

Better than DELETE FROM ALL_COMMENTS_AND_THREADS WHERE FORUM_ID = 1; COMMIT;

[SCalGal]

Oops?

[Admin Moderator]

lol as if John would give me access to the database directly :-D

[Focault's Pendulum]

What the heck was I thinking!?

Whew! For a moment there I thought it was me.

[AppyPappy]

Blame SQl. That's what I do.

[otterpond]

Query OK, 32 rows affected (0.01 sec)

At least it was quick and painless.....

[AppyPappy]

Is there any way to add both forums to Self-Search?

[John Robinson]

I have to do some heavy wizardry. Be afraid. Be very afraid.

It is on the todo list.

[AppyPappy]

This will help:

Fons Rademakers writes: "ROOT-Apache (aka Carrot) is an open source scripting module for the Apache webserver. Based on the ROOT framework which is using C++ as scripting language, via the CINT interpreter, it has a number of powerful features, including the ability to embed C++ code into HTML pages, run interpreted and compiled C++ macros, dynamically extend the framework with external libraries, access and manipulate databases, and generate graphics on-the-fly, among many others."

C++ for Apache

[John Robinson]

Why not assembly language?

[BraveMan]

When I joined this forum, you promised me there would be no math. Then along came the Freepathons . . .

Now I have to dust off my SQL skills?

What next? MFC? Windows API?

[AppyPappy]

Select * from posts, articles where posts.article_nbr = articles.article_nbr and articles.forum_id in (1, 4) and posts.userid = $user;

Assembly? Are you mad? We all use Algol now.

[Spunky]

Do you have a thread somewhere where I can read what the heck is going on here? :-)
Last night I saw chit-chat 1 minute. Now you know no one can chit-chat for one minute.
This morning I see general interest 2 minutes.

WHAAATZZZZZZZZZZZ UP?

[John Robinson]

Actually, most of the work is in rebuilding the 6 million record self-search table to use a different key. (I should purge that thing on occassion.) It would take some time, all of it down time.

[John Robinson]

1 minute/2 minute etc is the time the last post was made to the forum. I'm going to change that to just flag if there are new posts since the last visit.

[John Robinson]

Hey... waita minute.............. argh!