[Savannah-dev] Re: Forum / news transformation

[Marcus Hardt]

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