Results 1 to 5 of 5

Thread: Can't find where the query being stored

  1. #1
    kingikra is offline Member
    Join Date
    Aug 2010
    Posts
    18

    Default Can't find where the query being stored

    Hi All,

    I had a user in these forums named: gil shinar. This is still my name but I have lost my password so I have created a new user. kingikra.
    Now for my problem, we are trying to upgrade sugarCRM from 4.5.1 to 5.X or 6.X. We are using an external module that causes us to fail the upgrade. I have explained a lot about the problem in my former messages such as:
    http://www.sugarcrm.com/forums/showthread.php?t=54801
    http://www.sugarcrm.com/forums/showthread.php?t=55892

    I went over the code and found the exact line that fails with this error. The line is in the file:
    include/DetailView/DetailView.php

    and the actual line is:
    $response = $seed->process_detail_query(SugarVCR::retrieve($seed->module_dir), 0, -1, -1, '', $current_offset);

    Basically, the problem lies is the SQL query that comes from:
    SugarVCR::retrieve($seed->module_dir)

    I was looking for the place in the code where the query being stored in the session (e.g. SugarVCR::store($seed->module_dir)) but coundn't find it.

    Can you please assist?

    Thanks

    Gil

  2. #2
    davidboris is offline Sugar Community Member
    Join Date
    May 2010
    Posts
    1,113

    Default Re: Can't find where the query being stored

    Hi,

    Have checked both the threads you have mentioned here. But can you tell us, did you manage to upgrade to 5.0 or not? Before upgrade you face issue or after?

    If you can attach some screenshot here, it would be help to understand your exact problem.
    Thumbs up.

    Skype ID - david__boris

    SugarForge Projects:

    WYSIWYG now in studio!(Version 1.1 is out now!)

    Sugar Feeds on your personalized home pages like iGoogle, My Yahoo!, etc.

    Fab Tools! > Dashlet Not Followed Opportunities for past six Months

  3. #3
    kingikra is offline Member
    Join Date
    Aug 2010
    Posts
    18

    Default Re: Can't find where the query being stored

    Hi DavidBoris,

    I couldn't upgrade to 5.0.0. It fails. I could only upgrade to 5.1.0 and after the upgrade, when I try to see
    candidate's details, I get the following error:
    Attached Images Attached Images  
    Last edited by kingikra; 2010-08-29 at 11:29 AM.

  4. #4
    davidboris is offline Sugar Community Member
    Join Date
    May 2010
    Posts
    1,113

    Default Re: Can't find where the query being stored

    Hello,

    The error suggests that you have something badly defined. Have you wrote any logic hook or extended listview to match your requirement for candidate module?

    Have you tried Quick Repair and Rebuild? Run repair relationship, repair extension couple of times as well.
    Thumbs up.

    Skype ID - david__boris

    SugarForge Projects:

    WYSIWYG now in studio!(Version 1.1 is out now!)

    Sugar Feeds on your personalized home pages like iGoogle, My Yahoo!, etc.

    Fab Tools! > Dashlet Not Followed Opportunities for past six Months

  5. #5
    kingikra is offline Member
    Join Date
    Aug 2010
    Posts
    18

    Default Re: Can't find where the query being stored

    Quote Originally Posted by davidboris View Post
    Hello,

    The error suggests that you have something badly defined. Have you wrote any logic hook or extended listview to match your requirement for candidate module?

    Have you tried Quick Repair and Rebuild? Run repair relationship, repair extension couple of times as well.
    We have used an external module named spice hire. We assume that the problem lies somewhere in the module. The candidtes module is their external module.
    I have tried quick repair, Rebuild, repair relationship and any other rebuild or repair procedure with no success.

    Thanks

    Gil

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 2011-08-18, 01:48 PM
  2. Replies: 2
    Last Post: 2008-10-20, 06:01 AM
  3. Query Failed: ::MySQL error 1065: Query was empty
    By darcy.rippon in forum Developer Help
    Replies: 3
    Last Post: 2008-10-10, 07:24 AM
  4. Replies: 3
    Last Post: 2008-09-30, 08:43 PM
  5. Replies: 2
    Last Post: 2006-10-20, 12:00 AM

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
  •