Results 1 to 2 of 2

Thread: FreeBusy works for user Admin only?

  1. #1
    tj@estreet.com is offline Sugar Community Member
    Join Date
    Feb 2006
    Posts
    163

    Red face FreeBusy ONLY works for user Admin USER?

    Hey All,

    Really stuck here. My freebusy Availability pop-up only works for user Admin. (see sugarcrm.log code below)

    Logged in as Admin, debug log returns
    07/18/06 18:28:50,163 [5136] DEBUG 127.0.0.1 - Getting freebusy for user tj@areainspect.com
    07/18/06 18:28:50,164 [5136] DEBUG 127.0.0.1 - Getting inspections for user 450f379a-f9d2-dd2c-b1e0-44b31816b41c (current user = 1)
    07/18/06 18:28:50,171 [5136] DEBUG 127.0.0.1 - get_full_list: order_by = '' and where = '(DATE_FORMAT(inspections.date_start,'%Y-%m') >= '2006-07' AND DATE_FORMAT(inspections.date_start,'%Y-%m') <= '2006-07') AND inspections.inspector_id='450f379a-f9d2-dd2c-b1e0-44b31816b41c' '
    07/18/06 18:28:50,172 [5136] DEBUG 127.0.0.1 - process_full_list_query: query is SELECT inspections.* FROM inspections where (DATE_FORMAT(inspections.date_start,'%Y-%m') >= '2006-07' AND DATE_FORMAT(inspections.date_start,'%Y-%m') <= '2006-07') AND inspections.inspector_id='450f379a-f9d2-dd2c-b1e0-44b31816b41c' AND (inspections.deleted=0) ORDER BY inspections.order_id
    07/18/06 18:28:50,173 [5136] INFO 127.0.0.1 - Query:SELECT inspections.* FROM inspections where (DATE_FORMAT(inspections.date_start,'%Y-%m') >= '2006-07' AND DATE_FORMAT(inspections.date_start,'%Y-%m') <= '2006-07') AND inspections.inspector_id='450f379a-f9d2-dd2c-b1e0-44b31816b41c' AND (inspections.deleted=0) ORDER BY inspections.order_id
    07/18/06 18:28:50,174 [5136] INFO 127.0.0.1 - Query Execution Time:0.00108
    07/18/06 18:28:50,175 [5136] DEBUG 127.0.0.1 - process_full_list_query: result is Resource id #332
    07/18/06 18:28:50,177 [5136] DEBUG 127.0.0.1 - process_full_list: Inspections(c1533697-31f8-26f2-b07e-44bc3f63010c): id = c1533697-31f8-26f2-b07e-44bc3f63010c
    Which is as it should be, works fine, but logged in as nonAdmin user sugarcrm.log returns:
    07/18/06 18:16:47,481 [5136] DEBUG 127.0.0.1 - Getting freebusy for user tj@areainspect.com
    07/18/06 18:16:47,482 [5136] DEBUG 127.0.0.1 - Not authorized to get inspections for user 450f379a-f9d2-dd2c-b1e0-44b31816b41c (current user = 450f379a-f9d2-dd2c-b1e0-44b31816b41c)
    I can't figure out where or how that 'authorization' is derived. Why wouldn't current user be authorized to get his own record? Where do I look, how can I fix this?

    SOMEBODY PLEASE!


    Desperate for a clue. Willing to pay. Please help.
    Will email URL, user/pass upon request.

    Thanks!

    SugarOS Version 4.0.1f
    Apache version :Apache/2.0.55 (Win32)
    PHP version :4.4.2 Loaded extensions :
    standard, bcmath, calendar, ctype, com, ftp, mysql, odbc, overload, pcre, session, tokenizer, xml, wddx, zlib, apache2handler, mbstring, curl, gd, imap, pdf
    MySQL version :5.0.18-nt
    Last edited by tj@estreet.com; 2006-07-19 at 02:02 AM.

  2. #2
    tj@estreet.com is offline Sugar Community Member
    Join Date
    Feb 2006
    Posts
    163

    Default Re: FreeBusy works for user Admin only?

    Awfully quite around here. Is everyone on holiday?

    My original post has been in the first page of returns for 3 days now. I can remember not so long ago when an unanswered post here wouldn't last 12 hrs. before being pushed down to the 2nd or 3rd page of returns.

    Come on... fess up. Somebody has an idea here. What user parameters might allow Admin to recognize user freeBusy where any nonAdminUser will not?

    Anyone? Someone? Members?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •