Bug Tracker Incident #15833

 


Summary
Project
INCDT - xTuple ERP
Incident Category
Bugs
Incident Number
15833
Visibility
public


Product Version
3.8.0Beta
Fixed In Version
3.8.0Beta2


Summary
*Selecting to create a new task for a project generates DB log error


Description

DB log error is generated when selecting to create a new task for a project

Pre-condition:
te 2.0.4 package should be installed in the Database

Steps to Reproduce:
1. CRM->Project->List
2. Open 'GREENLEAF' project in edit mode and navigate to the 'Tasks' tab
3. Click on 'New' button, enter the Number, Name, Description and other details
4. Click on 'Save' button, observe that a System message is displayed and a DB log error is generated

DB log error:
Tue 4. Oct 15:20:21 2011 ERROR: record "new" has no field "prj_owner_username"
CONTEXT: SQL statement "SELECT (NEW.prj_owner_username=getEffectiveXtUser())"
PL/pgSQL function "_prjtasktrigger" line 9 at IF
QPSQL: Unable to create query
INSERT INTO prjtask ( prjtask_id, prjtask_prj_id, prjtask_number, prjtask_name, prjtask_descrip, prjtask_status, prjtask_hours_budget, prjtask_hours_actual, prjtask_exp_budget, prjtask_exp_actual, prjtask_start_date, prjtask_due_date, prjtask_assigned_date, prjtask_completed_date, prjtask_owner_username, prjtask_username ) VALUES ( 13, 5, 'dd', 'dd', 'dd', 'P', 0, 0, 0, 0, '2010-12-20', '2011-02-15', '2010-12-20', NULL, 'admin', 'admin' );


Details
Reporter
nagesh
CRM Account
ZenQA
Status
Closed
Assigned
reddog


Priority
Normal
Severity
Block
Updated
10-10-11 08:34
Resolution
Duplicate



Comments

DateUsernameComment
10/05/11 16:48reddog

fixed with incident #15501

10/04/11 14:56ptyler

Confirmed in 3.8 beta demo db.

10/04/11 05:51nagesh

DB log error is generated when selecting to create a new task for a project

Pre-condition:
te 2.0.4 package should be installed in the Database

Steps to Reproduce:
1. CRM->Project->List
2. Open 'GREENLEAF' project in edit mode and navigate to the 'Tasks' tab
3. Click on 'New' button, enter the Number, Name, Description and other details
4. Click on 'Save' button, observe that a System message is displayed and a DB log error is generated

DB log error:
Tue 4. Oct 15:20:21 2011 ERROR: record "new" has no field "prj_owner_username"
CONTEXT: SQL statement "SELECT (NEW.prj_owner_username=getEffectiveXtUser())"
PL/pgSQL function "_prjtasktrigger" line 9 at IF
QPSQL: Unable to create query
INSERT INTO prjtask ( prjtask_id, prjtask_prj_id, prjtask_number, prjtask_name, prjtask_descrip, prjtask_status, prjtask_hours_budget, prjtask_hours_actual, prjtask_exp_budget, prjtask_exp_actual, prjtask_start_date, prjtask_due_date, prjtask_assigned_date, prjtask_completed_date, prjtask_owner_username, prjtask_username ) VALUES ( 13, 5, 'dd', 'dd', 'dd', 'P', 0, 0, 0, 0, '2010-12-20', '2011-02-15', '2010-12-20', NULL, 'admin', 'admin' );



Characteristics

Backport
No
CodeReview
None
Operating System
all
Doc Flag
False
Copyright Assigned
Yes
HaxTuple
No
Points
None

Files

No Files

Related Documents

TypeNumberDescriptionRelationshipRemove
Incident15501Add personal/all security throughout CRMRelated tox
ProjectXTUPLEAPPSPorted From Mantisx


Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
10/04/11 05:51nageshNewIncident Added
10/04/11 05:51nageshCharacteristic Backport Added: "No"
10/04/11 05:51nageshCharacteristic CodeReview Added: ""
10/04/11 05:51nageshCharacteristic Operating System Added: "all"
10/04/11 05:51nageshCharacteristic haxTuple Added: "No"
10/04/11 05:51nageshCharacteristic Estimated Hours Added: ""
10/04/11 05:51nageshCharacteristic Doc Flag Added: "False"
10/04/11 05:51nageshCharacteristic Copyright Assigned Added: "Yes"
10/04/11 05:51acdrupalFound In: -> 2.0.4-xtte
10/04/11 06:45nageshDescription Updated: "DB log error is gene..." -> "DB log error is gene..."
10/04/11 06:45nageshSeveritySeverity Changed: Minor -> Block
10/04/11 14:56ptylerDescription Updated: "DB log error is gene..." -> "DB log error is gene..."
10/04/11 14:58ptylerStatusStatus Changed: New -> Confirmed
10/05/11 16:49reddogFound In: 2.0.4-xtte -> 3.8.0Beta
10/05/11 16:48reddogStatusStatus Changed: Confirmed -> Closed
10/05/11 16:48reddogAssignedAssigned to: "" -> "reddog"
10/05/11 16:48reddogResolutionResolution Changed: -> Duplicate
10/05/11 16:49reddogFixed In: -> 3.8.0

 

mead