Results 1 to 10 of 10

Thread: Project Task Problems with 5.2.0

  1. #1
    vietise is offline Junior Member
    Join Date
    Nov 2008
    Posts
    1

    Question Project Task Problems with 5.2.0

    I have just Install SugarCE-5.2.0 on:
    MySQL Server 5.1
    PHP 5.2.8
    Apache 2.2

    When i create a project task in the main project, there are many invisible field: Task ID, Duration, Start date, Finish date, Percent Complete (%), Resource, LBL_TEAM (???). Then, clik save button Sugar have notice: "Query Failed:INSERT into project_task set id='d2f1dcbb-63ec-d79c-461d-495052a77bbc', date_entered='2008-12-23 02:54:31', date_modified='2008-12-23 02:54:31', project_id='a073a830-f698-6a27-7e22-495051f83203', name='nghhdt', status='Not Started', description=null, actual_duration=null, percent_complete=null, assigned_user_id='1', modified_user_id='1', priority='High', created_by='1', milestone_flag='0', order_number=1, task_number=null, estimated_effort=null, deleted='0', utilization=100::MySQL error 1364: Field 'project_task_id' doesn't have a default value"

    What is this problem?
    Are there any patch to fix it?

    Many thanks!!!
    Last edited by vietise; 2008-12-23 at 02:02 AM. Reason: add smile

  2. #2
    reedber is offline Senior Member
    Join Date
    Dec 2008
    Posts
    26

    Default Re: Project Task Problems with 5.2.0

    I am also getting LBL_TEAM showing up in project tasks in 5.2 Also most fields can not be edited. This module is foobar.

  3. #3
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Project Task Problems with 5.2.0

    they again mixed up CE and Pro. That's why you must not touch a GA release (just another word for early beta).

    Try to set up new detail/edit views or change the existing ones so that the non existing fields do not show up. Or wait for the next patch.
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

  4. #4
    reedber is offline Senior Member
    Join Date
    Dec 2008
    Posts
    26

    Default Re: Project Task Problems with 5.2.0

    Thank you roblaus. They really push that version on you when you go to download... What release should I be using? I can re-install.

    Also, removing the non-existing fields does not help me edit the fields that do exist but seem to be uneditable...

    Maybe this will all go away with the re-install. Can I save my info, or do I have to start all over?

  5. #5
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Project Task Problems with 5.2.0

    Most probably it won't go away- Try 5.1c, there it seems to be ok if you really need this functionality. You may also wait and scan the forum for other solutions, there are others with the same problem.
    If you switch back: export your data and reimport them, this is pretty straightforward. You may also use mysql routines directly but you should then know what are you doing.

    hope this helps
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

  6. #6
    reedber is offline Senior Member
    Join Date
    Dec 2008
    Posts
    26

    Default Re: Project Task Problems with 5.2.0

    Thank you. I installed 5.1c and the problem dissapeared.

    However, although exporting the data may seem straightforward to you it is daunting to me (this is my first SugarCRM install). I added a lot of custom fields, layouts, notes, relations, etc that I am not interested in re-doing and am not sure how to export so that they will be compatible with an old version. So I will stick with 5.2 and hope someone from SugarCRM comes to my rescue with a patch (if this is a bug) or some more information. (esp. since I will have to upgrade eventually anyway)

  7. #7
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Project Task Problems with 5.2.0

    ok, thought you just wanted to rescue your data. If you did some customizations the situation is different. There would be a (50:50) way but your decision is a wise one.
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

  8. #8
    cherter is offline Junior Member
    Join Date
    Sep 2008
    Posts
    2

    Default Re: Project Task Problems with 5.2.0

    I've installed 5.2.0a today and this problem has been solved for me.

  9. #9
    reedber is offline Senior Member
    Join Date
    Dec 2008
    Posts
    26

    Default Re: Project Task Problems with 5.2.0

    cherter, I applied the 5.2.0a patch today and it didn't do anything for this problem. Do I need to do a clean install?

  10. #10
    Jannie is offline Junior Member
    Join Date
    Jan 2009
    Location
    Cape Town, South Africa
    Posts
    3

    Default Re: Project Task Problems with 5.2.0

    The patch also did not work for me. Fields are still missing.

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: 2009-05-27, 01:36 PM
  2. Replies: 2
    Last Post: 2008-05-07, 04:46 PM
  3. Problem when I crete a Project Task and Assigning to a Project.
    By rollno51 in forum General Discussion
    Replies: 0
    Last Post: 2007-07-26, 09:01 AM
  4. Replies: 0
    Last Post: 2006-06-23, 04:41 PM
  5. Replies: 0
    Last Post: 2005-08-19, 08:43 PM

Tags for this Thread

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
  •