Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Empty rows when using listview with custom fields

  1. #1
    MJBVrijmoed is offline Sugar Community Member
    Join Date
    Sep 2007
    Posts
    20

    Default Empty rows when using listview with custom fields

    Hi,

    i'm using SugarCRM CE 5.0.0b and when i add custom fields to my listview everything is ok. But when I use the massupdate option i get an empty row on every refresh and the delete option won't work.

    Does anybody has the same issue or knows the solution to this problem.

    Thanks,

    Martijn


    SugarCRM 5.0.0b
    Windows Server 2003
    IIS 6
    Php 5.2.4
    SQL Server 2005 Standard
    Last edited by MJBVrijmoed; 2008-03-02 at 05:32 PM.

  2. #2
    ptemplin7 is offline Sugar Community Member
    Join Date
    Jun 2007
    Location
    Puget Sound Washington
    Posts
    380

    Default Re: Empty rows when using listview with custom fields

    Is the field a relate field?

    If so, there is a bug in the coding. See the following to fix:

    http://www.sugarcrm.com/wiki/index.p...s_in_Sugar_5.0

    For some reason the powers that be gave us the relate field in Studio and module builder but failed to provide the coding to the vardefs!

    I have a bunch of coding to do myself to fix a similar problem within the standard modules and in a custom module.

    Hope this is the solution to your problem.

    Paris

  3. #3
    MJBVrijmoed is offline Sugar Community Member
    Join Date
    Sep 2007
    Posts
    20

    Default Re: Empty rows when using listview with custom fields

    Hi Paris,

    thanx for your help. It is not a relatefield though. The 1 to many relationship is another headbreaker. But i just use a custom field (text or dropdown) in the listview. This will result in a listviewdef.php in custom/modules/Accounts/metadata. When i delete this file everything works in order.

    Hope you can help me.


    Thanks again

    Martijn

  4. #4
    clint's Avatar
    clint is offline Sugar Team Member | Forums Lead Moderator
    Join Date
    Aug 2004
    Location
    Silicon Valley
    Posts
    2,120

    Default Re: Empty rows when using listview with custom fields

    This definitely sounds like a bug to me, though this is the first time I've heard of this behavior. Can you give more details on what you did so that we can try to reproduce the issue. What module were you working in? What field types are your custom fields? Does this happen when you add any of your custom fields to the list view or only with certain fields?
    Sugar Developer Zone - developer resources | Sugar University - user and admin training
    Sugar Docs - user and admin documentation |
    Sugar Bug Tracker - Enter or view bugs
    SugarForge- open source modules, themes, lang packs | SugarExchange - commercial extensions

    Clint Oram
    Chief Technology Officer and Co-founder
    SugarCRM

  5. #5
    ptemplin7 is offline Sugar Community Member
    Join Date
    Jun 2007
    Location
    Puget Sound Washington
    Posts
    380

    Question Re: Empty rows when using listview with custom fields

    Hi Clint,

    Thanks for looking at our forums. I need to dig deeper and get the relate field mess cleaned out so I can find if I have been getting the same errors.

    I do know that my customer added an account, two contacts, and two children (custom module) sucessfully. The data is in the DB and linked correctly. BUT now when you open the account list and select the account created the subpanels are just plain gone. Open the contact list, I get the search header fields and nothing else, no contacts no nothing, Children is the same.

    I'm going to follow the instructions from the Wiki to check the Vardefs and set the relations if needed. BTW all the three above are interlinked with relate fields. I have also done extensive customization (fields) and renaming of of labels in the modules. Will let you know if I run into other errors.

    Any ideas on why the blank screens even if we have vardef issues? Shouldn't I be getting an error instead of just a blank screen?

    Thanks again for your work on this project and help,
    Paris

  6. #6
    clint's Avatar
    clint is offline Sugar Team Member | Forums Lead Moderator
    Join Date
    Aug 2004
    Location
    Silicon Valley
    Posts
    2,120

    Default Re: Empty rows when using listview with custom fields

    Blank screens almost always come from a PHP error, usually in a language pack. Set display_errors=On and error_reporting=E_ALL in your php.ini file and you will where the blank screen error is coming from.
    Sugar Developer Zone - developer resources | Sugar University - user and admin training
    Sugar Docs - user and admin documentation |
    Sugar Bug Tracker - Enter or view bugs
    SugarForge- open source modules, themes, lang packs | SugarExchange - commercial extensions

    Clint Oram
    Chief Technology Officer and Co-founder
    SugarCRM

  7. #7
    ptemplin7 is offline Sugar Community Member
    Join Date
    Jun 2007
    Location
    Puget Sound Washington
    Posts
    380

    Default Re: Empty rows when using listview with custom fields

    Thanks Clint

    I will be back with more info. Since I ran into this on the production machine and it open to the world I have the php errors hidden. Will check the log file! Have to remember to do that more often in the furture!

    Thanks for the help,
    Paris

  8. #8
    ptemplin7 is offline Sugar Community Member
    Join Date
    Jun 2007
    Location
    Puget Sound Washington
    Posts
    380

    Question Re: Empty rows when using listview with custom fields

    Clint,

    No PHP errors! I turned all errors on to log and display. Got no errors. Could the relate fields be doing this?

    I have attached the screen printouts from the contacts and clients (Account) modules. as they are appearing. The account has no custom relate fields other modules do relate to it and the subpanel was added to that custom module. If you need the studio info I have that but will need to pdf it.

    I will be working on fixing the relationships as described int he Wiki for 1 to many in 5.0 and checking my vardefs and I will also take a look at the language files as you suggested.

    Any other suggestions would be great. Can't tell whether this is a bug or undocumented feature opps (as in allowing us to create a custom relate field but not fixing the vardefs, glad to hear the 5.1 will fix this) or some other issue.

    BTW I give kudos to the sugar team for making the studio much more user friendly. The module builder is great too. Thanks for your help and work, I look forward to hearing if you have any suggestions.

    Thanks Paris


    PS Addendum: The test client is too big to upload. It is not relate to anything at the moment and all subpanels do show up correctly for it!
    Attached Images Attached Images
    Last edited by ptemplin7; 2008-03-03 at 09:56 PM. Reason: forgot the attachments!

  9. #9
    ptemplin7 is offline Sugar Community Member
    Join Date
    Jun 2007
    Location
    Puget Sound Washington
    Posts
    380

    Default Re: Empty rows when using listview with custom fields

    Update:

    reset the web server. lo and behold I did have a php error! here is the log file. With some notes!

    Paris
    Attached Images Attached Images
    Last edited by ptemplin7; 2008-03-03 at 10:36 PM. Reason: new error log

  10. #10
    ljbutler is offline Sugar Community Member
    Join Date
    Sep 2007
    Location
    Derbyshire, UK
    Posts
    30

    Default Re: Empty rows when using listview with custom fields

    Is this related to the problems in this thread:-

    http://www.sugarcrm.com/forums/showthread.php?t=31047

    sounds like there is a problem with list views not working properly.
    Lucy.

    --------------------------------------------------
    Sugar Version - 5.0.0.a
    Sugar Edition - Community Edition
    Operating System - Centos 5.1
    PHP Version - 5.1.6
    Database - MySQL 5.0.22
    Web Server - Apache 2.2.3
    --------------------------------------------------

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. upgraded to 4.5.1e, received "Metadata for table tracker does not exist"
    By sfgeorge in forum Installation and Upgrade Help
    Replies: 0
    Last Post: 2007-09-03, 02:24 PM
  2. Replies: 0
    Last Post: 2006-12-20, 11:39 PM
  3. Asterisk Patch 1.1.0 Crash on logon
    By skyracer in forum Help
    Replies: 6
    Last Post: 2006-07-08, 06:30 AM
  4. Replies: 7
    Last Post: 2006-06-06, 07:56 PM
  5. Replies: 0
    Last Post: 2005-10-19, 02:49 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
  •