[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-dev] Re: Forum / news transformation
From: |
Marcus Hardt |
Subject: |
[Savannah-dev] Re: Forum / news transformation |
Date: |
Mon, 1 Dec 2003 19:31:55 +0100 |
User-agent: |
KMail/1.5.4 |
I have also modified/added initvalues for the tables
forum
forum_group_list
forum_monitored_forums
forum_saved_place
news_bytes
On Monday 01 December 2003 19:05, Marcus Hardt wrote:
> 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