[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-dev] Forum / news transformation
From: |
Marcus Hardt |
Subject: |
[Savannah-dev] Forum / news transformation |
Date: |
Mon, 1 Dec 2003 19:05:00 +0100 |
User-agent: |
KMail/1.5.4 |
Hi!
I'm just writing that script that renubmers the news and the forums and make
the assumption that forum.msg_id, forum.thread_id and forum
forum.is_followup_to are never below 100 anywhere. Should anyone encounter
this in his own installation I can add these fields with ease.
To find out type:
SELECT msg_id,group_forum_id,is_followup_to,thread_id FROM forum ORDER
BY
thread_id LIMIT 10;
SELECT msg_id,group_forum_id,is_followup_to,thread_id FROM forum ORDER
BY
msg_id LIMIT 10;)
Another issue is that the news are affected! This is because the news_bytes
table contains forum_id. Thus it is shifted as well. However, the script is
still called
renumber_forum.pl
The affected tables are:
forum
forum_group_list
forum_monitored_forums
forum_saved_place
Where in the cvs shall I add it?
--
Marcus
- [Savannah-dev] Forum / news transformation,
Marcus Hardt <=