Hi Roger, the dev mailing list is the right place for cvs version questions. Thanks! :) -Martin On Fri, Dec 05, 2003 at 12:09:32PM +0100, Roger Meier wrote:
hi community
Yesterday, i checkout the current cvs head, because i woul'd test the customer user <-> group management as Patrick wrote, and some of you say that work with the currenct cvs head.
I have replace the last otrs rpm files and replace all with the cvs content. Change the database fields and inserted new tables. Copy the old Config.pm to the Kernel/ Dir. (Add for the root@localhost manual in the db the admin permission, because i see that the management has changed)
But now i have some Problems:
1. Problem: Admin Area: [Customer User <-> Groups ] I see the users and the Groups but when i check a box, the change doesn't affect correctly. It has a Database Entry now, but the Customer User ID is not the ID of the user that shoul'd grant access it is 0. I Show the Code and see that it insert the loginname (customerkey), into the user_id field in the group_customer_user table. I think something is wrong. In my Configfile (tell me what) or in the Sourcecode (can you fix it?).
2. Problem: I have changed the user_id seen in Problem 1 manuely to the customer_user which shoul'd have access to that group. this group is owner of a queue, which have also an email address, for creating ticket to that queue. but i can't add a ticket. The queue has also some entries, but i don't see it in the customer view. only in the apache error log i see folowing: --snip-- [Fri Dec 5 11:45:11 2003] null: DBD::mysql::st execute failed: You have an error in your SQL syntax near ') AND st.customer_id = 'CUST_Franke' AND st.ticket_state_id in ( 1, 4, 6, 7, ' at line 1 at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 265. ERROR: OTRS-CGI-10 Perl: 5.8.0 OS: linux Time: Fri Dec 5 11:45:11 2003
Message: You have an error in your SQL syntax near ') AND st.customer_id = 'CUST_Franke' AND st.ticket_state_id in ( 1, 4, 6, 7, ' at line 1, SQL: 'SELECT count(*) FROM ticket st, queue q WHERE st.queue_id = q.id AND q.group_id IN ( ) AND st.customer_id = 'CUST_Franke' AND st.ticket_state_id in ( 1, 4, 6, 7, 8, 9, 10 ) '
Traceback (3387): Module: Kernel::Modules::CustomerTicketOverView::Run (v1.18) Line: 137 Module: Apache::ROOT::otrs::customer_2epl::handler (v1.22) Line: 690 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 --snip--
I hope somebody can help me.
Roger
-- ------------------------------------------------------------- addr://Rathausgasse 31, CH-5001 Aarau fon://++41 62 823 9355 http://www.terreactive.com fax://++41 62 823 9356 ------------------------------------------------------------- terreActive AG Wir sichern Ihren Erfolg. -------------------------------------------------------------
_______________________________________________ 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 Support oder Consulting f?r Ihr OTRS System? => http://www.otrs.de/
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!