Hi Alex, On Tue, Dec 09, 2003 at 02:39:11PM -0800, Alex Zheng wrote: > what is this customer <-> group management about?
You will be able to put customers into groups, so customers just can create/see tickets in this groups/queues via the customer panel. -Martin > At 12:03 PM 12/8/2003, Martin Edenhofer wrote: > >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 [EMAIL PROTECTED] 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. > >> ------------------------------------------------------------- Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication! _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
