Results 1 to 6 of 6

Thread: SugarCRM 4.5.1e Lead list problem

  1. #1
    Zeonz is offline Sugar Community Member
    Join Date
    Dec 2005
    Posts
    23

    Default SugarCRM 4.5.1e Lead list problem

    Hi guys, i have problem on the lead list as i selected a lead and error come out as :

    Error retrieving Lead list: Query Failed:SELECT leads.*, users.user_name assigned_user_name , leads_cstm.* FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c where leads.deleted=0 ORDER BY name DESC LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'order clause'


    which mean i cannot go into the lead details... Please help me out with this.


    thank you!

  2. #2
    kuske's Avatar
    kuske is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Germany
    Posts
    2,597

    Default Re: SugarCRM 4.5.1e Lead list problem

    The correct statement should be:

    SELECT leads.id , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.email1 , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN users jt0 ON
    jt0.id= leads.assigned_user_id AND jt0.deleted=0
    AND jt0.deleted=0 where leads.deleted=0 ORDER BY name

    Here you can see that the CONCAT function is missing in your statement.

    Did you change the listview layout and did you remove the lead name from it?
    Then an old order by can produce this error. Just click on status heading to sort for status.

    Or is there no entry

    'db_type' => 'mysql',

    in your config.php?

  3. #3
    Zeonz is offline Sugar Community Member
    Join Date
    Dec 2005
    Posts
    23

    Default Re: SugarCRM 4.5.1e Lead list problem

    Thank Kuske for reply on my problem.

    in config.php already point to mysql

    I try a fresh installation also give the same problem after i click on the column name for sorting and click on lead that i created.

    i would not like to upgrade the version as my project is using this version and i hope can solve the problem on this verison.



    Thank you

  4. #4
    kuske's Avatar
    kuske is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Germany
    Posts
    2,597

    Default Re: SugarCRM 4.5.1e Lead list problem

    Can you post your config.php or better your diagnostic zip file here?
    That could help a lot.

  5. #5
    Zeonz is offline Sugar Community Member
    Join Date
    Dec 2005
    Posts
    23

    Default Re: SugarCRM 4.5.1e Lead list problem

    Hi Kuske you can get the diagnostic file at this URL

    http://download.yousendit.com/E1C144967BF91D90


    Thank you

  6. #6
    Zeonz is offline Sugar Community Member
    Join Date
    Dec 2005
    Posts
    23

    Default Re: SugarCRM 4.5.1e Lead list problem

    Anyone can help on this issue?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 61
    Last Post: 2006-10-22, 08:40 AM
  2. Merge Contacts show sql error
    By hheckner in forum General Discussion
    Replies: 5
    Last Post: 2006-10-04, 01:57 PM
  3. Studio and Lead List problem
    By mmgareth in forum Help
    Replies: 1
    Last Post: 2006-07-03, 03:35 PM
  4. Replies: 0
    Last Post: 2006-05-04, 01:27 AM
  5. Serious issue with sugarcrm 3.5.1.c
    By wp.rauchholz in forum Help
    Replies: 17
    Last Post: 2005-12-01, 07:22 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
  •