Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #1880 Tracker DB error
    Actions
    Infos
    #1880
    Ben Yahmed Haythem (byh)
    2013-01-14 14:53
    2012-11-29 11:16
    980
    Details
    Tracker DB error
    after updating i observe some problems with trackers the template don't appear when i want to submit or consult my artifact in /var/log/httpd/error_log i have:

    HP Notice: DB error ==> SELECT id, source_field_id, source_value_id, target_field_id, rule_type, target_value_id FROM tracker_rule JOIN tracker_rule_list\n ON (tracker_rule.id = tracker_rule_list.tracker_rule_id) WHERE tracker_id = 22 ORDER BY id @@ /usr/share/codendi/plugins/tracker/include/Tracker/Rule/Tracker_RuleFactory.class.php at line 54 in /usr/share/codendi/src/common/dao/include/DataAccessObject.class.php on line 81, referer: http://192.168.24.58/plugins/tracker/?tracker=22&func=admin-formElements
    [Thu Nov 29 09:56:29 2012] [error] [client 192.168.24.37] PHP Fatal error: Call to a member function getRow() on a non-object in /usr/share/codendi/plugins/tracker/include/Tracker/Rule/Tracker_RuleFactory.class.php on line 56, referer: http://192.168.24.58/plugins/tracker/?tracker=22&func=admin-formElements
    Trackers
    5.7
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Sandra Echinard (sechinard)
    Closed (disabled)
    Empty
    Attachments
    Artifact links
    Empty
    Empty
    References
    References list is empty
    Display settings

    Follow-ups

    User avatar
    Sandra Echinard (sechinard)2013-01-14 14:53
    • Status changed from New to Closed (disabled)
    • Platform set to
    • Is an Enhancement or an internal improvement? set to
    User avatar
    Nicolas Terray (nterray)2012-11-30 12:05
    Well it seems that your db is corrupt.

    What is the result of this :
    $ /usr/lib/forgeupgrade/bin/forgeupgrade --config=/etc/codendi/forgeupgrade/config.ini already-applied
    User avatar
    Ben Yahmed Haythem (byh)2012-11-29 17:33
    It seems that the table has not been created in my database:
    ERROR 1146 (42S02): Table 'codendi.tracker_workflow_transition_condition_field_notempty' doesn't exist
    User avatar
    Nicolas Terray (nterray)2012-11-29 17:13
    Could you please issue the following mysql statement:
    desc tracker_workflow_transition_condition_field_notempty;
    User avatar
    Ben Yahmed Haythem (byh)2012-11-29 13:04
    Hi,

    Thanks for your response.
    It fixed the errors, but now when I try to add a new artefact with Workflow TransiTions it doesn't work.

    /var/log/httpd/error_log:
    PHP Notice: DB error ==> SELECT *\n FROM tracker_workflow_transition_condition_field_notempty\n WHERE transition_id = 38\n ORDER BY id @@ /usr/share/codendi/plugins/tracker/include/workflow/Transition/Condition/FieldNotEmpty/Factory.class.php at line 38 in /usr/share/codendi/src/common/dao/include/DataAccessObject.class.php on line 81, referer: http://192.168.24.58/plugins/tracker/?tracker=11&func=new-artifact
    [Thu Nov 29 12:17:00 2012] [error] [client 192.168.24.37] PHP Fatal error: Call to a member function getRow() on a non-object in /usr/share/codendi/plugins/tracker/include/workflow/Transition/Condition/FieldNotEmpty/Factory.class.php on line 38, referer: http://192.168.24.58/plugins/tracker/?tracker=11&func=new-artifact


    Can you help me?

    Tnx
    Haythem
    User avatar
    Sandra Echinard (sechinard)2012-11-29 11:59
    Did you apply data upgrades when updating your Tuleap version by making this 
    /usr/lib/forgeupgrade/bin/forgeupgrade --config=/etc/codendi/forgeupgrade/config.ini update
    ?
    • Status set to New
    • Assigned to changed from None to Sandra Echinard (sechinard)