Results 1 to 6 of 6

Thread: Error when sorting in Lead List

  1. #1
    Hidshadows is offline Junior Member
    Join Date
    Apr 2009
    Posts
    3

    Default Error when sorting in Lead List

    I have a Lead List of about 60 people.

    I can click on the column headers to sort everyone correctly.

    When I have everyone sorted I can advance through the pages of users without problems except for when i sort by the columns where I have created a custom field for.

    Resulting error is: SQL Error : Incorrect syntax near ','.

    Thanks

  2. #2
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Error when sorting in Lead List

    Hi Hidshadows

    Which version are you using?
    I believe this one is a known bug and it had been fixed in the last release.

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  3. #3
    Hidshadows is offline Junior Member
    Join Date
    Apr 2009
    Posts
    3

    Default Re: Error when sorting in Lead List

    Version 5.2.0c (Build 5505)

    I just installed this 1 week ago.

  4. #4
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Error when sorting in Lead List

    So weird!

    I had read a bug regarding this same issue sometime ago.
    Try to reproduce it in a clean installation containing demo data.
    If you can reproduce so you may fell free for filing a new bug in the bugs.sugarcrm.com

    Kind regards
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  5. #5
    Hidshadows is offline Junior Member
    Join Date
    Apr 2009
    Posts
    3

    Default Re: Error when sorting in Lead List

    Yup still does it on a clean, demo filled install, on a different computer

  6. #6
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Error when sorting in Lead List

    Hi Hidshadows

    Thank you for the fast test.
    Fell free for adding this new bug.

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error Retrieving lead list
    By cyberitpros in forum Help
    Replies: 7
    Last Post: 2008-02-06, 09:09 AM
  2. Query Error in Lead List
    By wesmon in forum Help
    Replies: 9
    Last Post: 2007-06-15, 04:50 AM
  3. Error Retrieving Lead List.
    By kenlohwh in forum Help
    Replies: 1
    Last Post: 2007-04-11, 01:52 PM
  4. Error Retrieving Lead List
    By csaling in forum Help
    Replies: 2
    Last Post: 2005-11-18, 01:30 PM
  5. Error retrieving Lead list (3.5.1c)
    By osmedd in forum Help
    Replies: 0
    Last Post: 2005-11-11, 01:59 PM

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
  •