hello,

    I used two OTRS systems, one for testing, one for using. Yesterday after I

found both of them had the same problem : admin users have no admin priveledges,

I couldn't find "Admin-Area" at the navigation bar.

    I have seen your solution from the original archives, but I just couldn't use

that. Your sql commands are:

ALTER TABLE group_user ADD permission_value SMALLINT;

UPDATE group_user SET permission_key = 'ro', permission_value = 1 WHERE
permission_read = 1;
UPDATE group_user SET permission_key = 'rw', permission_value = 1 WHERE
permission_write = 1;
UPDATE group_user SET permission_key = 'rw', permission_value = 1 WHERE
permission_write = 0 and permission_read = 0;

DELETE FROM group_user WHERE permission_value IS NULL;
ALTER TABLE group_user ALTER permission_value SET NOT NULL;
ALTER TABLE group_user DROP permission_read;
ALTER TABLE group_user DROP permission_write;
   

       My group_user table already has column permission_value, but have no

columns called permission_read or permission_write.

    My otrs version are 1.3.2 release in Redhat7.0 and 1.2.4 in WindowsXP

PRO with SP1.

    Eager for your answer.

Best wishes

Silver