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