On 10/13/08 12:13 PM, "Wes Plate" wrote:

>> I had a similar problem, and could not find "add new category" button, I
>> found
>> that the group admin_faq was not created and once I created this and added
>> the
>> correct users to the group everything worked.
>
> Thank you.  I also noticed the problem with the missing table, but I wasn't
> able to get the categories link back even after creating it and (I thought)
> adding users.
>
> I'm going to try again though.

I haven't worked on OTRS in a few days so what happened last time is abit
hazy, please forgive me.  Coming back to it I see I did manage to get myself
the category button at the top, but I cannot access all of the categories
for my old FAQ articles.

Do I need to go into phpMyAdmin to fix this?  It seems to work but since I'm
on the edge of understanding I'm a little scared.

In my DB I need to migrate I have 9 FAQ categories with IDs 1 through 9.
Groups for Admin, and Users and FAQ and FAQ Admin are Group ID 1, 2,5 and 7.

So I did this, and afterward I seem to be able to access all my FAQ articles
(but is this right?)...


INSERT INTO `otrs2`.`faq_category_group` (
`id` ,
`category_id` ,
`group_id` ,
`created` ,
`created_by` ,
`changed` ,
`changed_by`
)
VALUES
(NULL , '2', '1', NULL , '2', NULL , '2'),
(NULL , '2', '2', NULL , '2', NULL , '2'),
(NULL , '2', '5', NULL , '2', NULL , '2'),
(NULL , '2', '7', NULL , '2', NULL , '2'),
(NULL , '3', '1', NULL , '2', NULL , '2'),
(NULL , '3', '2', NULL , '2', NULL , '2'),
(NULL , '3', '5', NULL , '2', NULL , '2'),
(NULL , '3', '7', NULL , '2', NULL , '2'),
(NULL , '4', '1', NULL , '2', NULL , '2'),
(NULL , '4', '2', NULL , '2', NULL , '2'),
(NULL , '4', '5', NULL , '2', NULL , '2'),
(NULL , '4', '7', NULL , '2', NULL , '2'),
(NULL , '5', '1', NULL , '2', NULL , '2'),
(NULL , '5', '2', NULL , '2', NULL , '2'),
(NULL , '5', '5', NULL , '2', NULL , '2'),
(NULL , '5', '7', NULL , '2', NULL , '2'),
(NULL , '6', '1', NULL , '2', NULL , '2'),
(NULL , '6', '2', NULL , '2', NULL , '2'),
(NULL , '6', '5', NULL , '2', NULL , '2'),
(NULL , '6', '7', NULL , '2', NULL , '2'),
(NULL , '7', '1', NULL , '2', NULL , '2'),
(NULL , '7', '2', NULL , '2', NULL , '2'),
(NULL , '7', '5', NULL , '2', NULL , '2'),
(NULL , '7', '7', NULL , '2', NULL , '2'),
(NULL , '8', '1', NULL , '2', NULL , '2'),
(NULL , '8', '2', NULL , '2', NULL , '2'),
(NULL , '8', '5', NULL , '2', NULL , '2'),
(NULL , '8', '7', NULL , '2', NULL , '2'),
(NULL , '9', '1', NULL , '2', NULL , '2'),
(NULL , '9', '2', NULL , '2', NULL , '2'),
(NULL , '9', '5', NULL , '2', NULL , '2'),
(NULL , '9', '7', NULL , '2', NULL , '2');

--
Wes Plate
Automatic Duck, Inc.
  http://www.automaticduck.com


_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs