savannah-dev
[Top][All Lists]
Advanced

[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





reply via email to

[Prev in Thread] Current Thread [Next in Thread]