what is this customer <-> group management about?
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. > ------------------------------------------------------------- > > _______________________________________________ > 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!
_______________________________________________ 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/
_______________________________________________ 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
